Debian Codegraph @

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

raw
1 SET @start_value = @@big_tables;
2 SELECT @start_value;
3 @start_value
4 0
5 '#--------------------FN_DYNVARS_005_01------------------------#'
6 SET @@big_tables = 1;
7 SET @@big_tables = DEFAULT;
8 SELECT @@big_tables;
9 @@big_tables
10 0
11 '#--------------------FN_DYNVARS_005_02------------------------#'
12 SET @@big_tables = 0;
13 SELECT @@big_tables;
14 @@big_tables
15 0
16 SET @@big_tables = 1;
17 SELECT @@big_tables;
18 @@big_tables
19 1
20 '#--------------------FN_DYNVARS_005_03-------------------------#'
21 SET @@big_tables = 2;
22 ERROR 42000: Variable 'big_tables' can't be set to the value of '2'
23 SET @@big_tables = -1;
24 ERROR 42000: Variable 'big_tables' can't be set to the value of '-1'
25 SET @@big_tables = TRUEF;
26 ERROR 42000: Variable 'big_tables' can't be set to the value of 'TRUEF'
27 SET @@big_tables = TRUE_F;
28 ERROR 42000: Variable 'big_tables' can't be set to the value of 'TRUE_F'
29 SET @@big_tables = FALSE0;
30 ERROR 42000: Variable 'big_tables' can't be set to the value of 'FALSE0'
31 SET @@big_tables = OON;
32 ERROR 42000: Variable 'big_tables' can't be set to the value of 'OON'
33 SET @@big_tables = ONN;
34 ERROR 42000: Variable 'big_tables' can't be set to the value of 'ONN'
35 SET @@big_tables = OOFF;
36 ERROR 42000: Variable 'big_tables' can't be set to the value of 'OOFF'
37 SET @@big_tables = 0FF;
38 ERROR 42000: Variable 'big_tables' can't be set to the value of '0FF'
39 SET @@big_tables = ' ';
40 ERROR 42000: Variable 'big_tables' can't be set to the value of ' '
41 SET @@big_tables = " ";
42 ERROR 42000: Variable 'big_tables' can't be set to the value of ' '
43 SET @@big_tables = '';
44 ERROR 42000: Variable 'big_tables' can't be set to the value of ''
45 '#-------------------FN_DYNVARS_005_04----------------------------#'
46 SET @@global.big_tables = 1-@@global.big_tables;
47 SELECT @@global.big_tables;
48 @@global.big_tables
49 1
50 SET @@global.big_tables = 1-@@global.big_tables;
51 '#----------------------FN_DYNVARS_005_05------------------------#'
52 SELECT IF(@@big_tables, "ON", "OFF") = VARIABLE_VALUE
53 FROM performance_schema.session_variables
54 WHERE VARIABLE_NAME='big_tables';
55 IF(@@big_tables, "ON", "OFF") = VARIABLE_VALUE
56 1
57 '#---------------------FN_DYNVARS_005_06----------------------#'
58 SET @@big_tables = OFF;
59 SELECT @@big_tables;
60 @@big_tables
61 0
62 SET @@big_tables = ON;
63 SELECT @@big_tables;
64 @@big_tables
65 1
66 '#---------------------FN_DYNVARS_005_07----------------------#'
67 SET @@big_tables = TRUE;
68 SELECT @@big_tables;
69 @@big_tables
70 1
71 SET @@big_tables = FALSE;
72 SELECT @@big_tables;
73 @@big_tables
74 0
75 '#---------------------FN_DYNVARS_005_08----------------------#'
76 SET @@big_tables = 0;
77 SELECT @@big_tables = @@session.big_tables;
78 @@big_tables = @@session.big_tables
79 1
80 SET @@big_tables = 1;
81 SELECT @@big_tables = @@local.big_tables and @@local.big_tables = @@session.big_tables;
82 @@big_tables = @@local.big_tables and @@local.big_tables = @@session.big_tables
83 1
84 '#---------------------FN_DYNVARS_005_09----------------------#'
85 SET big_tables = 1;
86 SELECT @@big_tables;
87 @@big_tables
88 1
89 SET local.big_tables = 1;
90 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.big_tables = 1' at line 1
91 SELECT local.big_tables;
92 ERROR 42S02: Unknown table 'local' in field list
93 SET session.big_tables = 1;
94 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'session.big_tables = 1' at line 1
95 SELECT session.big_tables;
96 ERROR 42S02: Unknown table 'session' in field list
97 select big_tables;
98 ERROR 42S22: Unknown column 'big_tables' in 'field list'
99 SET @@big_tables = @start_value;
100 SELECT @@big_tables;
101 @@big_tables
102 0