Debian Codegraph @

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

raw
1
2
3 # 2011-11-16 - Added
4 #
5
6 --source include/have_innodb.inc
7
8 SET @start_global_value = @@global.innodb_optimize_fulltext_only;
9 SELECT @start_global_value;
10
11 #
12 # exists as global only
13 #
14 --echo Valid values are 'ON' and 'OFF'
15 select @@global.innodb_optimize_fulltext_only in (0, 1);
16 select @@global.innodb_optimize_fulltext_only;
17 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
18 select @@session.innodb_optimize_fulltext_only;
19 show global variables like 'innodb_optimize_fulltext_only';
20 show session variables like 'innodb_optimize_fulltext_only';
21 --disable_warnings
22 select * from information_schema.global_variables where variable_name='innodb_optimize_fulltext_only';
23 select * from information_schema.session_variables where variable_name='innodb_optimize_fulltext_only';
24 --enable_warnings
25
26 #
27 # show that it's writable
28 #
29 set global innodb_optimize_fulltext_only='ON';
30 select @@global.innodb_optimize_fulltext_only;
31 --disable_warnings
32 select * from information_schema.global_variables where variable_name='innodb_optimize_fulltext_only';
33 select * from information_schema.session_variables where variable_name='innodb_optimize_fulltext_only';
34 --enable_warnings
35 set @@global.innodb_optimize_fulltext_only=0;
36 select @@global.innodb_optimize_fulltext_only;
37 --disable_warnings
38 select * from information_schema.global_variables where variable_name='innodb_optimize_fulltext_only';
39 select * from information_schema.session_variables where variable_name='innodb_optimize_fulltext_only';
40 --enable_warnings
41 set global innodb_optimize_fulltext_only=1;
42 select @@global.innodb_optimize_fulltext_only;
43 --disable_warnings
44 select * from information_schema.global_variables where variable_name='innodb_optimize_fulltext_only';
45 select * from information_schema.session_variables where variable_name='innodb_optimize_fulltext_only';
46 --enable_warnings
47 set @@global.innodb_optimize_fulltext_only='OFF';
48 select @@global.innodb_optimize_fulltext_only;
49 --disable_warnings
50 select * from information_schema.global_variables where variable_name='innodb_optimize_fulltext_only';
51 select * from information_schema.session_variables where variable_name='innodb_optimize_fulltext_only';
52 --enable_warnings
53 --error ER_GLOBAL_VARIABLE
54 set session innodb_optimize_fulltext_only='OFF';
55 --error ER_GLOBAL_VARIABLE
56 set @@session.innodb_optimize_fulltext_only='ON';
57
58 #
59 # incorrect types
60 #
61 --error ER_WRONG_TYPE_FOR_VAR
62 set global innodb_optimize_fulltext_only=1.1;
63 --error ER_WRONG_TYPE_FOR_VAR
64 set global innodb_optimize_fulltext_only=1e1;
65 --error ER_WRONG_VALUE_FOR_VAR
66 set global innodb_optimize_fulltext_only=2;
67 --error ER_WRONG_VALUE_FOR_VAR
68 set global innodb_optimize_fulltext_only=-3;
69 select @@global.innodb_optimize_fulltext_only;
70 --disable_warnings
71 select * from information_schema.global_variables where variable_name='innodb_optimize_fulltext_only';
72 select * from information_schema.session_variables where variable_name='innodb_optimize_fulltext_only';
73 --enable_warnings
74 --error ER_WRONG_VALUE_FOR_VAR
75 set global innodb_optimize_fulltext_only='AUTO';
76
77 #
78 # Cleanup
79 #
80
81 SET @@global.innodb_optimize_fulltext_only = @start_global_value;
82 SELECT @@global.innodb_optimize_fulltext_only;