Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.tmp_table_size;
2 SET @start_session_value = @@session.tmp_table_size;
3 '#--------------------FN_DYNVARS_005_01-------------------------#'
4 SET @@global.tmp_table_size = 100;
5 Warnings:
6 Warning 1292 Truncated incorrect tmp_table_size value: '100'
7 SET @@global.tmp_table_size = DEFAULT;
8 SET @@session.tmp_table_size = 200;
9 Warnings:
10 Warning 1292 Truncated incorrect tmp_table_size value: '200'
11 SET @@session.tmp_table_size = DEFAULT;
12 '#--------------------FN_DYNVARS_005_02-------------------------#'
13 SELECT @@global.tmp_table_size >= 16777216;
14 @@global.tmp_table_size >= 16777216
15 1
16 SELECT @@session.tmp_table_size >= 16777216;
17 @@session.tmp_table_size >= 16777216
18 1
19 '#--------------------FN_DYNVARS_005_03-------------------------#'
20 SET @@global.tmp_table_size = 1024;
21 SELECT @@global.tmp_table_size;
22 @@global.tmp_table_size
23 1024
24 SET @@global.tmp_table_size = 60020;
25 SELECT @@global.tmp_table_size;
26 @@global.tmp_table_size
27 60020
28 SET @@global.tmp_table_size = 4294967295;
29 SELECT @@global.tmp_table_size;
30 @@global.tmp_table_size
31 4294967295
32 '#--------------------FN_DYNVARS_005_04-------------------------#'
33 SET @@session.tmp_table_size = 1024;
34 SELECT @@session.tmp_table_size;
35 @@session.tmp_table_size
36 1024
37 SET @@session.tmp_table_size = 4294967295;
38 SELECT @@session.tmp_table_size;
39 @@session.tmp_table_size
40 4294967295
41 SET @@session.tmp_table_size = 65535;
42 SELECT @@session.tmp_table_size;
43 @@session.tmp_table_size
44 65535
45 '#------------------FN_DYNVARS_005_05-----------------------#'
46 SET @@global.tmp_table_size = 0;
47 Warnings:
48 Warning 1292 Truncated incorrect tmp_table_size value: '0'
49 SELECT @@global.tmp_table_size;
50 @@global.tmp_table_size
51 1024
52 SET @@global.tmp_table_size = -1024;
53 Warnings:
54 Warning 1292 Truncated incorrect tmp_table_size value: '-1024'
55 SELECT @@global.tmp_table_size;
56 @@global.tmp_table_size
57 1024
58 SET @@global.tmp_table_size = 1000;
59 Warnings:
60 Warning 1292 Truncated incorrect tmp_table_size value: '1000'
61 SELECT @@global.tmp_table_size;
62 @@global.tmp_table_size
63 1024
64 SET @@global.tmp_table_size = 4294967299;
65 SELECT @@global.tmp_table_size;
66 @@global.tmp_table_size
67 4294967299
68 SET @@global.tmp_table_size = ' ';
69 ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
70 SELECT @@global.tmp_table_size;
71 @@global.tmp_table_size
72 4294967299
73 SET @@global.tmp_table_size = ON;
74 ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
75 SET @@global.tmp_table_size = OFF;
76 ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
77 SET @@global.tmp_table_size = True;
78 Warnings:
79 Warning 1292 Truncated incorrect tmp_table_size value: '1'
80 SELECT @@global.tmp_table_size;
81 @@global.tmp_table_size
82 1024
83 SET @@global.tmp_table_size = False;
84 Warnings:
85 Warning 1292 Truncated incorrect tmp_table_size value: '0'
86 SELECT @@global.tmp_table_size;
87 @@global.tmp_table_size
88 1024
89 SET @@global.tmp_table_size = 65530.34;
90 ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
91 SET @@global.tmp_table_size ="Test";
92 ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
93 SET @@session.tmp_table_size = ON;
94 ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
95 SET @@session.tmp_table_size = OFF;
96 ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
97 SET @@session.tmp_table_size = True;
98 Warnings:
99 Warning 1292 Truncated incorrect tmp_table_size value: '1'
100 SELECT @@session.tmp_table_size;
101 @@session.tmp_table_size
102 1024
103 SET @@session.tmp_table_size = 65530.34;
104 ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
105 SET @@session.tmp_table_size = False;
106 Warnings:
107 Warning 1292 Truncated incorrect tmp_table_size value: '0'
108 SELECT @@session.tmp_table_size;
109 @@session.tmp_table_size
110 1024
111 SET @@session.tmp_table_size = "Test";
112 ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
113 SET @@session.tmp_table_size = ' ';
114 ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
115 SELECT @@session.tmp_table_size;
116 @@session.tmp_table_size
117 1024
118 SET @@session.tmp_table_size = 1000;
119 Warnings:
120 Warning 1292 Truncated incorrect tmp_table_size value: '1000'
121 SELECT @@session.tmp_table_size;
122 @@session.tmp_table_size
123 1024
124 SET @@session.tmp_table_size = 12345678901;
125 SELECT @@session.tmp_table_size IN (12345678901,4294967295);
126 @@session.tmp_table_size IN (12345678901,4294967295)
127 1
128 '#------------------FN_DYNVARS_005_06-----------------------#'
129 SELECT @@global.tmp_table_size = VARIABLE_VALUE
130 FROM performance_schema.global_variables
131 WHERE VARIABLE_NAME='tmp_table_size';
132 @@global.tmp_table_size = VARIABLE_VALUE
133 1
134 '#------------------FN_DYNVARS_005_07-----------------------#'
135 SELECT @@session.tmp_table_size = VARIABLE_VALUE
136 FROM performance_schema.session_variables
137 WHERE VARIABLE_NAME='tmp_table_size';
138 @@session.tmp_table_size = VARIABLE_VALUE
139 1
140 '#---------------------FN_DYNVARS_001_09----------------------#'
141 SET @@global.tmp_table_size = 1024;
142 SET @@tmp_table_size = 4294967295;
143 SELECT @@tmp_table_size = @@global.tmp_table_size;
144 @@tmp_table_size = @@global.tmp_table_size
145 0
146 '#---------------------FN_DYNVARS_001_10----------------------#'
147 SET @@tmp_table_size = 100;
148 Warnings:
149 Warning 1292 Truncated incorrect tmp_table_size value: '100'
150 SELECT @@tmp_table_size = @@local.tmp_table_size;
151 @@tmp_table_size = @@local.tmp_table_size
152 1
153 SELECT @@local.tmp_table_size = @@session.tmp_table_size;
154 @@local.tmp_table_size = @@session.tmp_table_size
155 1
156 '#---------------------FN_DYNVARS_001_11----------------------#'
157 SET tmp_table_size = 1027;
158 SELECT @@tmp_table_size;
159 @@tmp_table_size
160 1027
161 SELECT local.tmp_table_size;
162 ERROR 42S02: Unknown table 'local' in field list
163 SELECT global.tmp_table_size;
164 ERROR 42S02: Unknown table 'global' in field list
165 SELECT tmp_table_size = @@session.tmp_table_size;
166 ERROR 42S22: Unknown column 'tmp_table_size' in 'field list'
167 SET @@global.tmp_table_size = @start_global_value;
168 SET @@session.tmp_table_size = @start_session_value;