summaryrefslogtreecommitdiff
path: root/mysql-test/include/check_var_limit.inc
blob: f955aeb345eed3093b63cfaa9927fac9dab4e11c (plain)
1
2
3
4
5
6
7
8
9
#
# Check that second part of $LIMIT is between $MIN_LIMIT and $MAX_LIMIT
# This is useful to check that a variable from SHOW_VARIABLES is within
# certain limits. Check query_cache_merge.test for an example of using this.
#
-- require r/check_var_limit.require
disable_query_log;
eval select SUBSTRING_INDEX("$LIMIT", "\\t", -1) BETWEEN $MIN_LIMIT AND $MAX_LIMIT as "limit";
enable_query_log;