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 Warnings:
8 Warning 1287 '@@big_tables' is deprecated and will be removed in a future release
9 SET @@big_tables = DEFAULT;
10 Warnings:
11 Warning 1287 '@@big_tables' is deprecated and will be removed in a future release
12 SELECT @@big_tables;
13 @@big_tables
14 0
15 '#--------------------FN_DYNVARS_005_02------------------------#'
16 SET @@big_tables = 0;
17 Warnings:
18 Warning 1287 '@@big_tables' is deprecated and will be removed in a future release
19 SELECT @@big_tables;
20 @@big_tables
21 0
22 SET @@big_tables = 1;
23 Warnings:
24 Warning 1287 '@@big_tables' is deprecated and will be removed in a future release
25 SELECT @@big_tables;
26 @@big_tables
27 1
28 '#--------------------FN_DYNVARS_005_03-------------------------#'
29 SET @@big_tables = 2;
30 ERROR 42000: Variable 'big_tables' can't be set to the value of '2'
31 SET @@big_tables = -1;
32 ERROR 42000: Variable 'big_tables' can't be set to the value of '-1'
33 SET @@big_tables = TRUEF;
34 ERROR 42000: Variable 'big_tables' can't be set to the value of 'TRUEF'
35 SET @@big_tables = TRUE_F;
36 ERROR 42000: Variable 'big_tables' can't be set to the value of 'TRUE_F'
37 SET @@big_tables = FALSE0;
38 ERROR 42000: Variable 'big_tables' can't be set to the value of 'FALSE0'
39 SET @@big_tables = OON;
40 ERROR 42000: Variable 'big_tables' can't be set to the value of 'OON'
41 SET @@big_tables = ONN;
42 ERROR 42000: Variable 'big_tables' can't be set to the value of 'ONN'
43 SET @@big_tables = OOFF;
44 ERROR 42000: Variable 'big_tables' can't be set to the value of 'OOFF'
45 SET @@big_tables = 0FF;
46 ERROR 42000: Variable 'big_tables' can't be set to the value of '0FF'
47 SET @@big_tables = ' ';
48 ERROR 42000: Variable 'big_tables' can't be set to the value of ' '
49 SET @@big_tables = " ";
50 ERROR 42000: Variable 'big_tables' can't be set to the value of ' '
51 SET @@big_tables = '';
52 ERROR 42000: Variable 'big_tables' can't be set to the value of ''
53 '#-------------------FN_DYNVARS_005_04----------------------------#'
54 SET @@global.big_tables = 1-@@global.big_tables;
55 Warnings:
56 Warning 1287 '@@big_tables' is deprecated and will be removed in a future release
57 SELECT @@global.big_tables;
58 @@global.big_tables
59 1
60 SET @@global.big_tables = 1-@@global.big_tables;
61 Warnings:
62 Warning 1287 '@@big_tables' is deprecated and will be removed in a future release
63 '#----------------------FN_DYNVARS_005_05------------------------#'
64 SELECT IF(@@big_tables, "ON", "OFF") = VARIABLE_VALUE
65 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
66 WHERE VARIABLE_NAME='big_tables';
67 IF(@@big_tables, "ON", "OFF") = VARIABLE_VALUE
68 1
69 '#---------------------FN_DYNVARS_005_06----------------------#'
70 SET @@big_tables = OFF;
71 Warnings:
72 Warning 1287 '@@big_tables' is deprecated and will be removed in a future release
73 SELECT @@big_tables;
74 @@big_tables
75 0
76 SET @@big_tables = ON;
77 Warnings:
78 Warning 1287 '@@big_tables' is deprecated and will be removed in a future release
79 SELECT @@big_tables;
80 @@big_tables
81 1
82 '#---------------------FN_DYNVARS_005_07----------------------#'
83 SET @@big_tables = TRUE;
84 Warnings:
85 Warning 1287 '@@big_tables' is deprecated and will be removed in a future release
86 SELECT @@big_tables;
87 @@big_tables
88 1
89 SET @@big_tables = FALSE;
90 Warnings:
91 Warning 1287 '@@big_tables' is deprecated and will be removed in a future release
92 SELECT @@big_tables;
93 @@big_tables
94 0
95 '#---------------------FN_DYNVARS_005_08----------------------#'
96 SET @@big_tables = 0;
97 Warnings:
98 Warning 1287 '@@big_tables' is deprecated and will be removed in a future release
99 SELECT @@big_tables = @@session.big_tables;
100 @@big_tables = @@session.big_tables
101 1
102 SET @@big_tables = 1;
103 Warnings:
104 Warning 1287 '@@big_tables' is deprecated and will be removed in a future release
105 SELECT @@big_tables = @@local.big_tables and @@local.big_tables = @@session.big_tables;
106 @@big_tables = @@local.big_tables and @@local.big_tables = @@session.big_tables
107 1
108 '#---------------------FN_DYNVARS_005_09----------------------#'
109 SET big_tables = 1;
110 Warnings:
111 Warning 1287 '@@big_tables' is deprecated and will be removed in a future release
112 SELECT @@big_tables;
113 @@big_tables
114 1
115 SELECT local.big_tables;
116 ERROR 42S02: Unknown table 'local' in SELECT
117 SELECT session.big_tables;
118 ERROR 42S02: Unknown table 'session' in SELECT
119 select big_tables;
120 ERROR 42S22: Unknown column 'big_tables' in 'SELECT'
121 SET @@big_tables = @start_value;
122 Warnings:
123 Warning 1287 '@@big_tables' is deprecated and will be removed in a future release
124 SELECT @@big_tables;
125 @@big_tables
126 0