Debian Codegraph @

mysql-test/suite/sys_vars/r/old_alter_table_basic.result

raw
1 SET @start_global_value = @@global.old_alter_table;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 select @@global.old_alter_table;
6 @@global.old_alter_table
7 0
8 select @@session.old_alter_table;
9 @@session.old_alter_table
10 0
11 show global variables like 'old_alter_table';
12 Variable_name Value
13 old_alter_table OFF
14 show session variables like 'old_alter_table';
15 Variable_name Value
16 old_alter_table OFF
17 select * from performance_schema.global_variables where variable_name='old_alter_table';
18 VARIABLE_NAME VARIABLE_VALUE
19 old_alter_table OFF
20 select * from performance_schema.session_variables where variable_name='old_alter_table';
21 VARIABLE_NAME VARIABLE_VALUE
22 old_alter_table OFF
23 set global old_alter_table=1;
24 set session old_alter_table=ON;
25 select @@global.old_alter_table;
26 @@global.old_alter_table
27 1
28 select @@session.old_alter_table;
29 @@session.old_alter_table
30 1
31 show global variables like 'old_alter_table';
32 Variable_name Value
33 old_alter_table ON
34 show session variables like 'old_alter_table';
35 Variable_name Value
36 old_alter_table ON
37 select * from performance_schema.global_variables where variable_name='old_alter_table';
38 VARIABLE_NAME VARIABLE_VALUE
39 old_alter_table ON
40 select * from performance_schema.session_variables where variable_name='old_alter_table';
41 VARIABLE_NAME VARIABLE_VALUE
42 old_alter_table ON
43 SET @@global.old_alter_table=DEFAULT;
44 SELECT @@global.old_alter_table;
45 @@global.old_alter_table
46 0
47 SET @@session.old_alter_table=DEFAULT;
48 SELECT @@session.old_alter_table;
49 @@session.old_alter_table
50 0
51 set global old_alter_table=1.1;
52 ERROR 42000: Incorrect argument type to variable 'old_alter_table'
53 set global old_alter_table=1e1;
54 ERROR 42000: Incorrect argument type to variable 'old_alter_table'
55 set global old_alter_table="foo";
56 ERROR 42000: Variable 'old_alter_table' can't be set to the value of 'foo'
57 SET @@global.old_alter_table = @start_global_value;
58 SELECT @@global.old_alter_table;
59 @@global.old_alter_table
60 0