Debian Codegraph @

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

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