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 --source include/have_innodb.inc
7 --source include/word_size.inc
8
9 #
10 # show the global and session values;
11 #
12 select @@global.innodb_ft_result_cache_limit;
13 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
14 select @@session.innodb_ft_result_cache_limit;
15 show global variables like 'innodb_ft_result_cache_limit';
16 show session variables like 'innodb_ft_result_cache_limit';
17 --disable_warnings
18 select * from information_schema.global_variables where variable_name='innodb_ft_result_cache_limit';
19 select * from information_schema.session_variables where variable_name='innodb_ft_result_cache_limit';
20 --enable_warnings
21
22 #
23 # test default, min, max value
24 #
25 SET @save_limit = @@innodb_ft_result_cache_limit;
26
27 set global innodb_ft_result_cache_limit=900000;
28 select @@innodb_ft_result_cache_limit;
29
30 set global innodb_ft_result_cache_limit=1000000;
31 select @@innodb_ft_result_cache_limit;
32
33 set global innodb_ft_result_cache_limit=4294967295;
34 select @@innodb_ft_result_cache_limit;
35
36 set global innodb_ft_result_cache_limit=4*1024*1024*1024;
37 select @@innodb_ft_result_cache_limit;
38
39 set global innodb_ft_result_cache_limit = @save_limit;