Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.read_rnd_buffer_size;
2 SELECT @start_global_value;
3 @start_global_value
4 262144
5 SET @start_session_value = @@session.read_rnd_buffer_size;
6 SELECT @start_session_value;
7 @start_session_value
8 262144
9 '#--------------------FN_DYNVARS_140_01-------------------------#'
10 SET @@global.read_rnd_buffer_size = 1000;
11 SET @@global.read_rnd_buffer_size = DEFAULT;
12 SELECT @@global.read_rnd_buffer_size;
13 @@global.read_rnd_buffer_size
14 262144
15 SET @@session.read_rnd_buffer_size = 2000;
16 SET @@session.read_rnd_buffer_size = DEFAULT;
17 SELECT @@session.read_rnd_buffer_size;
18 @@session.read_rnd_buffer_size
19 262144
20 '#--------------------FN_DYNVARS_140_03-------------------------#'
21 SET @@global.read_rnd_buffer_size = 1;
22 SELECT @@global.read_rnd_buffer_size;
23 @@global.read_rnd_buffer_size
24 1
25 SET @@global.read_rnd_buffer_size = 8201;
26 SELECT @@global.read_rnd_buffer_size;
27 @@global.read_rnd_buffer_size
28 8201
29 SET @@global.read_rnd_buffer_size = 8200;
30 SELECT @@global.read_rnd_buffer_size;
31 @@global.read_rnd_buffer_size
32 8200
33 SET @@global.read_rnd_buffer_size = 2147479552;
34 SELECT @@global.read_rnd_buffer_size;
35 @@global.read_rnd_buffer_size
36 2147479552
37 SET @@global.read_rnd_buffer_size = 2147483647;
38 SELECT @@global.read_rnd_buffer_size;
39 @@global.read_rnd_buffer_size
40 2147483647
41 '#--------------------FN_DYNVARS_140_04-------------------------#'
42 SET @@session.read_rnd_buffer_size = 1;
43 SELECT @@session.read_rnd_buffer_size;
44 @@session.read_rnd_buffer_size
45 1
46 SET @@session.read_rnd_buffer_size = 8200;
47 SELECT @@session.read_rnd_buffer_size;
48 @@session.read_rnd_buffer_size
49 8200
50 SET @@session.read_rnd_buffer_size = 8201;
51 SELECT @@session.read_rnd_buffer_size;
52 @@session.read_rnd_buffer_size
53 8201
54 SET @@session.read_rnd_buffer_size = 2147479552;
55 SELECT @@session.read_rnd_buffer_size;
56 @@session.read_rnd_buffer_size
57 2147479552
58 SET @@session.read_rnd_buffer_size = 2147483647;
59 SELECT @@session.read_rnd_buffer_size;
60 @@session.read_rnd_buffer_size
61 2147483647
62 '#------------------FN_DYNVARS_140_05-----------------------#'
63 SET @@global.read_rnd_buffer_size = 0;
64 Warnings:
65 Warning 1292 Truncated incorrect read_rnd_buffer_size value: '0'
66 SELECT @@global.read_rnd_buffer_size;
67 @@global.read_rnd_buffer_size
68 1
69 SET @@global.read_rnd_buffer_size = -1024;
70 Warnings:
71 Warning 1292 Truncated incorrect read_rnd_buffer_size value: '-1024'
72 SELECT @@global.read_rnd_buffer_size;
73 @@global.read_rnd_buffer_size
74 1
75 SET @@global.read_rnd_buffer_size = 2147483648;
76 Warnings:
77 Warning 1292 Truncated incorrect read_rnd_buffer_size value: '2147483648'
78 SELECT @@global.read_rnd_buffer_size;
79 @@global.read_rnd_buffer_size
80 2147483647
81 SET @@global.read_rnd_buffer_size = 4147483648;
82 Warnings:
83 Warning 1292 Truncated incorrect read_rnd_buffer_size value: '4147483648'
84 SELECT @@global.read_rnd_buffer_size;
85 @@global.read_rnd_buffer_size
86 2147483647
87 SET @@global.read_rnd_buffer_size = 65530.34;
88 ERROR 42000: Incorrect argument type to variable 'read_rnd_buffer_size'
89 SET @@global.read_rnd_buffer_size = test;
90 ERROR 42000: Incorrect argument type to variable 'read_rnd_buffer_size'
91 SET @@session.read_rnd_buffer_size = 0;
92 Warnings:
93 Warning 1292 Truncated incorrect read_rnd_buffer_size value: '0'
94 SELECT @@session.read_rnd_buffer_size;
95 @@session.read_rnd_buffer_size
96 1
97 SET @@session.read_rnd_buffer_size = -1024;
98 Warnings:
99 Warning 1292 Truncated incorrect read_rnd_buffer_size value: '-1024'
100 SELECT @@session.read_rnd_buffer_size;
101 @@session.read_rnd_buffer_size
102 1
103 SET @@session.read_rnd_buffer_size = 2147483648;
104 Warnings:
105 Warning 1292 Truncated incorrect read_rnd_buffer_size value: '2147483648'
106 SELECT @@session.read_rnd_buffer_size;
107 @@session.read_rnd_buffer_size
108 2147483647
109 SET @@session.read_rnd_buffer_size = 4147483648;
110 Warnings:
111 Warning 1292 Truncated incorrect read_rnd_buffer_size value: '4147483648'
112 SELECT @@session.read_rnd_buffer_size;
113 @@session.read_rnd_buffer_size
114 2147483647
115 SET @@session.read_rnd_buffer_size = 65530.34;
116 ERROR 42000: Incorrect argument type to variable 'read_rnd_buffer_size'
117 SET @@session.read_rnd_buffer_size = test;
118 ERROR 42000: Incorrect argument type to variable 'read_rnd_buffer_size'
119 '#------------------FN_DYNVARS_140_06-----------------------#'
120 SELECT @@global.read_rnd_buffer_size = VARIABLE_VALUE FROM performance_schema.global_variables WHERE VARIABLE_NAME='read_rnd_buffer_size';
121 @@global.read_rnd_buffer_size = VARIABLE_VALUE
122 1
123 '#------------------FN_DYNVARS_140_07-----------------------#'
124 SELECT @@session.read_rnd_buffer_size =
125 VARIABLE_VALUE FROM performance_schema.session_variables WHERE VARIABLE_NAME='read_rnd_buffer_size';
126 @@session.read_rnd_buffer_size =
127 VARIABLE_VALUE
128 1
129 '#------------------FN_DYNVARS_140_08-----------------------#'
130 SET @@global.read_rnd_buffer_size = TRUE;
131 SELECT @@global.read_rnd_buffer_size;
132 @@global.read_rnd_buffer_size
133 1
134 SET @@global.read_rnd_buffer_size = FALSE;
135 Warnings:
136 Warning 1292 Truncated incorrect read_rnd_buffer_size value: '0'
137 SELECT @@global.read_rnd_buffer_size;
138 @@global.read_rnd_buffer_size
139 1
140 '#---------------------FN_DYNVARS_140_09----------------------#'
141 SET @@global.read_rnd_buffer_size = 9000;
142 SELECT @@read_rnd_buffer_size = @@global.read_rnd_buffer_size;
143 @@read_rnd_buffer_size = @@global.read_rnd_buffer_size
144 0
145 '#---------------------FN_DYNVARS_140_10----------------------#'
146 SET @@read_rnd_buffer_size = 9000;
147 SELECT @@read_rnd_buffer_size = @@local.read_rnd_buffer_size;
148 @@read_rnd_buffer_size = @@local.read_rnd_buffer_size
149 1
150 SELECT @@local.read_rnd_buffer_size = @@session.read_rnd_buffer_size;
151 @@local.read_rnd_buffer_size = @@session.read_rnd_buffer_size
152 1
153 '#---------------------FN_DYNVARS_140_11----------------------#'
154 SET read_rnd_buffer_size = 9100;
155 SELECT @@read_rnd_buffer_size;
156 @@read_rnd_buffer_size
157 9100
158 SELECT local.read_rnd_buffer_size;
159 ERROR 42S02: Unknown table 'local' in field list
160 SELECT session.read_rnd_buffer_size;
161 ERROR 42S02: Unknown table 'session' in field list
162 SELECT read_rnd_buffer_size = @@session.read_rnd_buffer_size;
163 ERROR 42S22: Unknown column 'read_rnd_buffer_size' in 'field list'
164 SET @@global.read_rnd_buffer_size = @start_global_value;
165 SELECT @@global.read_rnd_buffer_size;
166 @@global.read_rnd_buffer_size
167 262144
168 SET @@session.read_rnd_buffer_size = @start_session_value;
169 SELECT @@session.read_rnd_buffer_size;
170 @@session.read_rnd_buffer_size
171 262144