Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.histogram_size;
2 SET @start_session_value = @@session.histogram_size;
3 SELECT @start_global_value = @start_session_value;
4 @start_global_value = @start_session_value
5 1
6 '#--------------------FN_DYNVARS_053_01-------------------------#'
7 SET @@global.histogram_size = DEFAULT;
8 SELECT @@global.histogram_size;
9 @@global.histogram_size
10 254
11 SET @@session.histogram_size = DEFAULT;
12 SELECT @@session.histogram_size;
13 @@session.histogram_size
14 254
15 '#--------------------FN_DYNVARS_053_03-------------------------#'
16 SET @@global.histogram_size = 1;
17 SELECT @@global.histogram_size;
18 @@global.histogram_size
19 1
20 SET @@global.histogram_size = 31;
21 SELECT @@global.histogram_size;
22 @@global.histogram_size
23 31
24 SET @@global.histogram_size = 255;
25 SELECT @@global.histogram_size;
26 @@global.histogram_size
27 255
28 '#--------------------FN_DYNVARS_053_04-------------------------#'
29 SET @@session.histogram_size = 1;
30 SELECT @@session.histogram_size;
31 @@session.histogram_size
32 1
33 SET @@session.histogram_size = 31;
34 SELECT @@session.histogram_size;
35 @@session.histogram_size
36 31
37 SET @@session.histogram_size = 255;
38 SELECT @@session.histogram_size;
39 @@session.histogram_size
40 255
41 '#------------------FN_DYNVARS_053_05-----------------------#'
42 SET @@global.histogram_size = -1;
43 Warnings:
44 Warning 1292 Truncated incorrect histogram_size value: '-1'
45 SELECT @@global.histogram_size;
46 @@global.histogram_size
47 0
48 SET @@global.histogram_size = 256;
49 Warnings:
50 Warning 1292 Truncated incorrect histogram_size value: '256'
51 SELECT @@global.histogram_size;
52 @@global.histogram_size
53 255
54 SET @@global.histogram_size = 1024;
55 Warnings:
56 Warning 1292 Truncated incorrect histogram_size value: '1024'
57 SELECT @@global.histogram_size;
58 @@global.histogram_size
59 255
60 SET @@global.histogram_size = 4.5;
61 ERROR 42000: Incorrect argument type to variable 'histogram_size'
62 SELECT @@global.histogram_size;
63 @@global.histogram_size
64 255
65 SET @@global.histogram_size = test;
66 ERROR 42000: Incorrect argument type to variable 'histogram_size'
67 SELECT @@global.histogram_size;
68 @@global.histogram_size
69 255
70 SET @@session.histogram_size = -1;
71 Warnings:
72 Warning 1292 Truncated incorrect histogram_size value: '-1'
73 SELECT @@session.histogram_size;
74 @@session.histogram_size
75 0
76 SET @@session.histogram_size = 256;
77 Warnings:
78 Warning 1292 Truncated incorrect histogram_size value: '256'
79 SELECT @@session.histogram_size;
80 @@session.histogram_size
81 255
82 SET @@session.histogram_size = 1024;
83 Warnings:
84 Warning 1292 Truncated incorrect histogram_size value: '1024'
85 SELECT @@session.histogram_size;
86 @@session.histogram_size
87 255
88 SET @@session.histogram_size = 4.5;
89 ERROR 42000: Incorrect argument type to variable 'histogram_size'
90 SELECT @@session.histogram_size;
91 @@session.histogram_size
92 255
93 SET @@session.histogram_size = test;
94 ERROR 42000: Incorrect argument type to variable 'histogram_size'
95 SELECT @@session.histogram_size;
96 @@session.histogram_size
97 255
98 '#------------------FN_DYNVARS_053_06-----------------------#'
99 SELECT @@global.histogram_size = VARIABLE_VALUE
100 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
101 WHERE VARIABLE_NAME='histogram_size';
102 @@global.histogram_size = VARIABLE_VALUE
103 1
104 '#------------------FN_DYNVARS_053_07-----------------------#'
105 SELECT @@session.histogram_size = VARIABLE_VALUE
106 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
107 WHERE VARIABLE_NAME='histogram_size';
108 @@session.histogram_size = VARIABLE_VALUE
109 1
110 '#------------------FN_DYNVARS_053_08-----------------------#'
111 SET @@global.histogram_size = TRUE;
112 SET @@global.histogram_size = FALSE;
113 '#---------------------FN_DYNVARS_001_09----------------------#'
114 SET @@global.histogram_size = 10;
115 SELECT @@histogram_size = @@global.histogram_size;
116 @@histogram_size = @@global.histogram_size
117 0
118 '#---------------------FN_DYNVARS_001_10----------------------#'
119 SET @@histogram_size = 100;
120 SELECT @@histogram_size = @@local.histogram_size;
121 @@histogram_size = @@local.histogram_size
122 1
123 SELECT @@local.histogram_size = @@session.histogram_size;
124 @@local.histogram_size = @@session.histogram_size
125 1
126 SET @@global.histogram_size = @start_global_value;
127 SET @@session.histogram_size = @start_session_value;