1SET @start_global_value = @@global.myisam_repair_threads;
2SELECT @start_global_value;
3@start_global_value
41
5SET @start_session_value = @@session.myisam_repair_threads;
6SELECT @start_session_value;
7@start_session_value
81
9'#--------------------FN_DYNVARS_005_01-------------------------#'
10SET @@global.myisam_repair_threads  = 100;
11SET @@global.myisam_repair_threads  = DEFAULT;
12SELECT @@global.myisam_repair_threads ;
13@@global.myisam_repair_threads
141
15SET @@session.myisam_repair_threads  = 200;
16SET @@session.myisam_repair_threads  = DEFAULT;
17SELECT @@session.myisam_repair_threads ;
18@@session.myisam_repair_threads
191
20'#--------------------FN_DYNVARS_005_02-------------------------#'
21SET @@global.myisam_repair_threads  = DEFAULT;
22SELECT @@global.myisam_repair_threads  = 1;
23@@global.myisam_repair_threads  = 1
241
25SET @@session.myisam_repair_threads  = DEFAULT;
26SELECT @@session.myisam_repair_threads  = 1;
27@@session.myisam_repair_threads  = 1
281
29'#--------------------FN_DYNVARS_005_03-------------------------#'
30SET @@global.myisam_repair_threads  = 1;
31SELECT @@global.myisam_repair_threads ;
32@@global.myisam_repair_threads
331
34SET @@global.myisam_repair_threads  = 4294967295;
35SELECT @@global.myisam_repair_threads ;
36@@global.myisam_repair_threads
374294967295
38SET @@global.myisam_repair_threads  = 655354;
39SELECT @@global.myisam_repair_threads ;
40@@global.myisam_repair_threads
41655354
42'#--------------------FN_DYNVARS_005_04-------------------------#'
43SET @@session.myisam_repair_threads  = 1;
44SELECT @@session.myisam_repair_threads ;
45@@session.myisam_repair_threads
461
47SET @@session.myisam_repair_threads  = 4294967295;
48SELECT @@session.myisam_repair_threads ;
49@@session.myisam_repair_threads
504294967295
51SET @@session.myisam_repair_threads  = 655345;
52SELECT @@session.myisam_repair_threads ;
53@@session.myisam_repair_threads
54655345
55'#------------------FN_DYNVARS_005_05-----------------------#'
56SET @@global.myisam_repair_threads  = 0;
57Warnings:
58Warning	1292	Truncated incorrect myisam_repair_threads value: '0'
59SELECT @@global.myisam_repair_threads ;
60@@global.myisam_repair_threads
611
62SET @@global.myisam_repair_threads  = -1024;
63Warnings:
64Warning	1292	Truncated incorrect myisam_repair_threads value: '-1024'
65SELECT @@global.myisam_repair_threads ;
66@@global.myisam_repair_threads
671
68SET @@global.myisam_repair_threads  = 429496729533;
69SELECT @@global.myisam_repair_threads ;
70@@global.myisam_repair_threads
71429496729533
72SET @@global.myisam_repair_threads  = 65530.34;
73ERROR 42000: Incorrect argument type to variable 'myisam_repair_threads'
74SELECT @@global.myisam_repair_threads ;
75@@global.myisam_repair_threads
76429496729533
77SET @@global.myisam_repair_threads  = test;
78ERROR 42000: Incorrect argument type to variable 'myisam_repair_threads'
79SELECT @@global.myisam_repair_threads ;
80@@global.myisam_repair_threads
81429496729533
82SET @@global.myisam_repair_threads  = "test";
83ERROR 42000: Incorrect argument type to variable 'myisam_repair_threads'
84SELECT @@global.myisam_repair_threads ;
85@@global.myisam_repair_threads
86429496729533
87SET @@global.myisam_repair_threads  = 'test';
88ERROR 42000: Incorrect argument type to variable 'myisam_repair_threads'
89SELECT @@global.myisam_repair_threads ;
90@@global.myisam_repair_threads
91429496729533
92SET @@global.myisam_repair_threads  = ON;
93ERROR 42000: Incorrect argument type to variable 'myisam_repair_threads'
94SELECT @@global.myisam_repair_threads ;
95@@global.myisam_repair_threads
96429496729533
97SET @@session.myisam_repair_threads  = 0;
98Warnings:
99Warning	1292	Truncated incorrect myisam_repair_threads value: '0'
100SELECT @@session.myisam_repair_threads ;
101@@session.myisam_repair_threads
1021
103SET @@session.myisam_repair_threads  = -2;
104Warnings:
105Warning	1292	Truncated incorrect myisam_repair_threads value: '-2'
106SELECT @@session.myisam_repair_threads ;
107@@session.myisam_repair_threads
1081
109SET @@session.myisam_repair_threads  = 65530.34;
110ERROR 42000: Incorrect argument type to variable 'myisam_repair_threads'
111SELECT @@session.myisam_repair_threads ;
112@@session.myisam_repair_threads
1131
114SET @@session.myisam_repair_threads  = test;
115ERROR 42000: Incorrect argument type to variable 'myisam_repair_threads'
116SELECT @@session.myisam_repair_threads ;
117@@session.myisam_repair_threads
1181
119SET @@session.myisam_repair_threads  = "test";
120ERROR 42000: Incorrect argument type to variable 'myisam_repair_threads'
121SELECT @@session.myisam_repair_threads ;
122@@session.myisam_repair_threads
1231
124'#------------------FN_DYNVARS_005_06-----------------------#'
125SELECT @@global.myisam_repair_threads  = VARIABLE_VALUE
126FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
127WHERE VARIABLE_NAME='myisam_repair_threads ';
128@@global.myisam_repair_threads  = VARIABLE_VALUE
1291
130'#------------------FN_DYNVARS_005_07-----------------------#'
131SELECT @@session.myisam_repair_threads  = VARIABLE_VALUE
132FROM INFORMATION_SCHEMA.SESSION_VARIABLES
133WHERE VARIABLE_NAME='myisam_repair_threads ';
134@@session.myisam_repair_threads  = VARIABLE_VALUE
1351
136'#------------------FN_DYNVARS_005_08-----------------------#'
137SET @@global.myisam_repair_threads  = TRUE;
138SELECT @@global.myisam_repair_threads ;
139@@global.myisam_repair_threads
1401
141SET @@global.myisam_repair_threads  = FALSE;
142Warnings:
143Warning	1292	Truncated incorrect myisam_repair_threads value: '0'
144SELECT @@global.myisam_repair_threads ;
145@@global.myisam_repair_threads
1461
147'#---------------------FN_DYNVARS_001_09----------------------#'
148SET @@global.myisam_repair_threads  = 10;
149SELECT @@myisam_repair_threads  = @@global.myisam_repair_threads ;
150@@myisam_repair_threads  = @@global.myisam_repair_threads
1510
152'#---------------------FN_DYNVARS_001_10----------------------#'
153SET @@myisam_repair_threads  = 100;
154SELECT @@myisam_repair_threads  = @@local.myisam_repair_threads ;
155@@myisam_repair_threads  = @@local.myisam_repair_threads
1561
157SELECT @@local.myisam_repair_threads  = @@session.myisam_repair_threads ;
158@@local.myisam_repair_threads  = @@session.myisam_repair_threads
1591
160'#---------------------FN_DYNVARS_001_11----------------------#'
161SET myisam_repair_threads  = 1;
162SELECT @@myisam_repair_threads ;
163@@myisam_repair_threads
1641
165SELECT local.myisam_repair_threads ;
166ERROR 42S02: Unknown table 'local' in field list
167SELECT session.myisam_repair_threads ;
168ERROR 42S02: Unknown table 'session' in field list
169SELECT myisam_repair_threads  = @@session.myisam_repair_threads ;
170ERROR 42S22: Unknown column 'myisam_repair_threads' in 'field list'
171SET @@global.myisam_repair_threads  = @start_global_value;
172SELECT @@global.myisam_repair_threads ;
173@@global.myisam_repair_threads
1741
175SET @@session.myisam_repair_threads  = @start_session_value;
176SELECT @@session.myisam_repair_threads ;
177@@session.myisam_repair_threads
1781
179