Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_ft_result_cache_limit_basic.test

raw
1
2 #
3 # 2013-05-09 - Added
4 #
5
6
7 #
8 # show the global and session values;
9 #
10 select @@global.innodb_ft_result_cache_limit;
11 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
12 select @@session.innodb_ft_result_cache_limit;
13 show global variables like 'innodb_ft_result_cache_limit';
14 show session variables like 'innodb_ft_result_cache_limit';
15 --disable_warnings
16 select * from performance_schema.global_variables where variable_name='innodb_ft_result_cache_limit';
17 select * from performance_schema.session_variables where variable_name='innodb_ft_result_cache_limit';
18 --enable_warnings
19
20 #
21 # test default, min, max value
22 #
23 let $innodb_ft_result_cache_limit_orig=`select @@innodb_ft_result_cache_limit`;
24
25 set global innodb_ft_result_cache_limit=900000;
26 select @@innodb_ft_result_cache_limit;
27
28 set global innodb_ft_result_cache_limit=1000000;
29 select @@innodb_ft_result_cache_limit;
30
31 set global innodb_ft_result_cache_limit=4294967295;
32 select @@innodb_ft_result_cache_limit;
33
34 set global innodb_ft_result_cache_limit=4*1024*1024*1024;
35 select @@innodb_ft_result_cache_limit;
36
37 eval set global innodb_ft_result_cache_limit=$innodb_ft_result_cache_limit_orig;