Lines Matching refs:tmp_memory_table_size

3 # Variable Name: tmp_memory_table_size                                        #
20 #           START OF tmp_memory_table_size TESTS                    #
27 SET @start_global_value = @@global.tmp_memory_table_size;
28 SET @start_session_value = @@session.tmp_memory_table_size;
32 #     Display the DEFAULT value of tmp_memory_table_size            #
35 SET @@global.tmp_memory_table_size = 10000;
36 SELECT @@global.tmp_memory_table_size;
37 SET @@global.tmp_memory_table_size = DEFAULT;
38 SELECT @@global.tmp_memory_table_size;
40 SET @@session.tmp_memory_table_size = 20000;
41 SELECT @@session.tmp_memory_table_size;
42 SET @@session.tmp_memory_table_size = DEFAULT;
43 SELECT @@session.tmp_memory_table_size;
47 #     Check the DEFAULT value of tmp_memory_table_size                        #
51 SELECT @@global.tmp_memory_table_size >= 16777216;
52 SELECT @@session.tmp_memory_table_size >= 16777216;
56 # Change the value of tmp_memory_table_size to a valid value for GLOBAL Scope #
59 SET @@global.tmp_memory_table_size = 1024;
60 SELECT @@global.tmp_memory_table_size;
61 SET @@global.tmp_memory_table_size = 60020;
62 SELECT @@global.tmp_memory_table_size;
63 SET @@global.tmp_memory_table_size = 4294967295;
64 SELECT @@global.tmp_memory_table_size;
69 # Change the value of tmp_memory_table_size to a valid value for SESSION Scope #
72 SET @@session.tmp_memory_table_size = 1024;
73 SELECT @@session.tmp_memory_table_size;
75 SET @@session.tmp_memory_table_size = 4294967295;
76 SELECT @@session.tmp_memory_table_size;
77 SET @@session.tmp_memory_table_size = 65535;
78 SELECT @@session.tmp_memory_table_size;
83 # Change the value of tmp_memory_table_size to an invalid value #
86 SET @@global.tmp_memory_table_size = 0;
87 SELECT @@global.tmp_memory_table_size;
89 SET @@global.tmp_memory_table_size = -1024;
90 SELECT @@global.tmp_memory_table_size;
92 SET @@global.tmp_memory_table_size = 1000;
93 SELECT @@global.tmp_memory_table_size;
96 SET @@global.tmp_memory_table_size = ON;
99 SET @@global.tmp_memory_table_size = OFF;
101 SET @@global.tmp_memory_table_size = True;
102 SELECT @@global.tmp_memory_table_size;
104 SET @@global.tmp_memory_table_size = False;
105 SELECT @@global.tmp_memory_table_size;
108 SET @@global.tmp_memory_table_size = 65530.34;
111 SET @@global.tmp_memory_table_size ="Test";
114 SET @@session.tmp_memory_table_size = ON;
117 SET @@session.tmp_memory_table_size = OFF;
119 SET @@session.tmp_memory_table_size = True;
120 SELECT @@session.tmp_memory_table_size;
122 SET @@session.tmp_memory_table_size = False;
123 SELECT @@session.tmp_memory_table_size;
126 SET @@session.tmp_memory_table_size = "Test";
129 SET @@session.tmp_memory_table_size = 12345678901;
132 SELECT @@session.tmp_memory_table_size IN (12345678901,4294967295);
139 SELECT @@global.tmp_memory_table_size = VARIABLE_VALUE
141 WHERE VARIABLE_NAME='tmp_memory_table_size';
148 SELECT @@session.tmp_memory_table_size = VARIABLE_VALUE
150 WHERE VARIABLE_NAME='tmp_memory_table_size';
157 SET @@global.tmp_memory_table_size = 1024;
158 SET @@tmp_memory_table_size = 4294967295;
159 SELECT @@tmp_memory_table_size = @@global.tmp_memory_table_size;
167 SET @@tmp_memory_table_size = 100;
168 SELECT @@tmp_memory_table_size = @@local.tmp_memory_table_size;
169 SELECT @@local.tmp_memory_table_size = @@session.tmp_memory_table_size;
174 #   Check if tmp_memory_table_size can be accessed with and without @@ sign    #
177 SET tmp_memory_table_size = 1027;
178 SELECT @@tmp_memory_table_size;
181 SELECT local.tmp_memory_table_size;
184 SELECT global.tmp_memory_table_size;
187 SELECT tmp_memory_table_size = @@session.tmp_memory_table_size;
190 --echo "Check that tmp_memory_table_size and tmp_table_size are the same"
193 set @@session.tmp_memory_table_size=100000;
194 select @@session.tmp_memory_table_size,@@session.tmp_table_size;
195 set @@session.tmp_memory_table_size=200000;
196 select @@session.tmp_memory_table_size,@@session.tmp_table_size;
203 SET @@global.tmp_memory_table_size = @start_global_value;
204 SET @@session.tmp_memory_table_size = @start_session_value;
207 #                 END OF tmp_memory_table_size TESTS     #