1SET @start_global_value = @@global.histogram_size;
2SET @start_session_value = @@session.histogram_size;
3SELECT @start_global_value = @start_session_value;
4@start_global_value = @start_session_value
51
6'#--------------------FN_DYNVARS_053_01-------------------------#'
7SET @@global.histogram_size = DEFAULT;
8SELECT @@global.histogram_size;
9@@global.histogram_size
100
11SET @@session.histogram_size = DEFAULT;
12SELECT @@session.histogram_size;
13@@session.histogram_size
140
15'#--------------------FN_DYNVARS_053_03-------------------------#'
16SET @@global.histogram_size = 1;
17SELECT @@global.histogram_size;
18@@global.histogram_size
191
20SET @@global.histogram_size = 31;
21SELECT @@global.histogram_size;
22@@global.histogram_size
2331
24SET @@global.histogram_size = 255;
25SELECT @@global.histogram_size;
26@@global.histogram_size
27255
28'#--------------------FN_DYNVARS_053_04-------------------------#'
29SET @@session.histogram_size = 1;
30SELECT @@session.histogram_size;
31@@session.histogram_size
321
33SET @@session.histogram_size = 31;
34SELECT @@session.histogram_size;
35@@session.histogram_size
3631
37SET @@session.histogram_size = 255;
38SELECT @@session.histogram_size;
39@@session.histogram_size
40255
41'#------------------FN_DYNVARS_053_05-----------------------#'
42SET @@global.histogram_size = -1;
43Warnings:
44Warning	1292	Truncated incorrect histogram_size value: '-1'
45SELECT @@global.histogram_size;
46@@global.histogram_size
470
48SET @@global.histogram_size = 256;
49Warnings:
50Warning	1292	Truncated incorrect histogram_size value: '256'
51SELECT @@global.histogram_size;
52@@global.histogram_size
53255
54SET @@global.histogram_size = 1024;
55Warnings:
56Warning	1292	Truncated incorrect histogram_size value: '1024'
57SELECT @@global.histogram_size;
58@@global.histogram_size
59255
60SET @@global.histogram_size = 4.5;
61ERROR 42000: Incorrect argument type to variable 'histogram_size'
62SELECT @@global.histogram_size;
63@@global.histogram_size
64255
65SET @@global.histogram_size = test;
66ERROR 42000: Incorrect argument type to variable 'histogram_size'
67SELECT @@global.histogram_size;
68@@global.histogram_size
69255
70SET @@session.histogram_size = -1;
71Warnings:
72Warning	1292	Truncated incorrect histogram_size value: '-1'
73SELECT @@session.histogram_size;
74@@session.histogram_size
750
76SET @@session.histogram_size = 256;
77Warnings:
78Warning	1292	Truncated incorrect histogram_size value: '256'
79SELECT @@session.histogram_size;
80@@session.histogram_size
81255
82SET @@session.histogram_size = 1024;
83Warnings:
84Warning	1292	Truncated incorrect histogram_size value: '1024'
85SELECT @@session.histogram_size;
86@@session.histogram_size
87255
88SET @@session.histogram_size = 4.5;
89ERROR 42000: Incorrect argument type to variable 'histogram_size'
90SELECT @@session.histogram_size;
91@@session.histogram_size
92255
93SET @@session.histogram_size = test;
94ERROR 42000: Incorrect argument type to variable 'histogram_size'
95SELECT @@session.histogram_size;
96@@session.histogram_size
97255
98'#------------------FN_DYNVARS_053_06-----------------------#'
99SELECT @@global.histogram_size = VARIABLE_VALUE
100FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
101WHERE VARIABLE_NAME='histogram_size';
102@@global.histogram_size = VARIABLE_VALUE
1031
104'#------------------FN_DYNVARS_053_07-----------------------#'
105SELECT @@session.histogram_size = VARIABLE_VALUE
106FROM INFORMATION_SCHEMA.SESSION_VARIABLES
107WHERE VARIABLE_NAME='histogram_size';
108@@session.histogram_size = VARIABLE_VALUE
1091
110'#------------------FN_DYNVARS_053_08-----------------------#'
111SET @@global.histogram_size = TRUE;
112SET @@global.histogram_size = FALSE;
113'#---------------------FN_DYNVARS_001_09----------------------#'
114SET @@global.histogram_size = 10;
115SELECT @@histogram_size = @@global.histogram_size;
116@@histogram_size = @@global.histogram_size
1170
118'#---------------------FN_DYNVARS_001_10----------------------#'
119SET @@histogram_size = 100;
120SELECT @@histogram_size = @@local.histogram_size;
121@@histogram_size = @@local.histogram_size
1221
123SELECT @@local.histogram_size = @@session.histogram_size;
124@@local.histogram_size = @@session.histogram_size
1251
126SET @@global.histogram_size = @start_global_value;
127SET @@session.histogram_size = @start_session_value;
128