Debian Codegraph @

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

raw
1
2 #
3 # 2010-01-20 OBN - added check of I_S values after variable value changed
4 #
5
6 SET @start_global_value = @@global.old_alter_table;
7 SELECT @start_global_value;
8
9 #
10 # exists as global and session
11 #
12 select @@global.old_alter_table;
13 select @@session.old_alter_table;
14 show global variables like 'old_alter_table';
15 show session variables like 'old_alter_table';
16 --disable_warnings
17 select * from performance_schema.global_variables where variable_name='old_alter_table';
18 select * from performance_schema.session_variables where variable_name='old_alter_table';
19 --enable_warnings
20
21 #
22 # show that it's writable
23 #
24 set global old_alter_table=1;
25 set session old_alter_table=ON;
26 select @@global.old_alter_table;
27 select @@session.old_alter_table;
28 show global variables like 'old_alter_table';
29 show session variables like 'old_alter_table';
30 --disable_warnings
31 select * from performance_schema.global_variables where variable_name='old_alter_table';
32 select * from performance_schema.session_variables where variable_name='old_alter_table';
33 --enable_warnings
34
35 #
36 # Display the default value
37 #
38
39 SET @@global.old_alter_table=DEFAULT;
40 SELECT @@global.old_alter_table;
41
42 SET @@session.old_alter_table=DEFAULT;
43 SELECT @@session.old_alter_table;
44
45 #
46 # incorrect types
47 #
48 --error ER_WRONG_TYPE_FOR_VAR
49 set global old_alter_table=1.1;
50 --error ER_WRONG_TYPE_FOR_VAR
51 set global old_alter_table=1e1;
52 --error ER_WRONG_VALUE_FOR_VAR
53 set global old_alter_table="foo";
54
55 SET @@global.old_alter_table = @start_global_value;
56 SELECT @@global.old_alter_table;