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 = 8201;
22 SELECT @@global.read_rnd_buffer_size;
23 @@global.read_rnd_buffer_size
24 8201
25 SET @@global.read_rnd_buffer_size = 8200;
26 SELECT @@global.read_rnd_buffer_size;
27 @@global.read_rnd_buffer_size
28 8200
29 SET @@global.read_rnd_buffer_size = 2147479552;
30 SELECT @@global.read_rnd_buffer_size;
31 @@global.read_rnd_buffer_size
32 2147479552
33 SET @@global.read_rnd_buffer_size = 2147479551;
34 SELECT @@global.read_rnd_buffer_size;
35 @@global.read_rnd_buffer_size
36 2147479551
37 '#--------------------FN_DYNVARS_140_04-------------------------#'
38 SET @@session.read_rnd_buffer_size = 8200;
39 SELECT @@session.read_rnd_buffer_size;
40 @@session.read_rnd_buffer_size
41 8200
42 SET @@session.read_rnd_buffer_size = 8201;
43 SELECT @@session.read_rnd_buffer_size;
44 @@session.read_rnd_buffer_size
45 8201
46 SET @@session.read_rnd_buffer_size = 2147479552;
47 SELECT @@session.read_rnd_buffer_size;
48 @@session.read_rnd_buffer_size
49 2147479552
50 SET @@session.read_rnd_buffer_size = 2147479551;
51 SELECT @@session.read_rnd_buffer_size;
52 @@session.read_rnd_buffer_size
53 2147479551
54 '#------------------FN_DYNVARS_140_05-----------------------#'
55 SET @@global.read_rnd_buffer_size = 8199;
56 SELECT @@global.read_rnd_buffer_size;
57 @@global.read_rnd_buffer_size
58 8199
59 SET @@global.read_rnd_buffer_size = -1024;
60 Warnings:
61 Warning 1292 Truncated incorrect read_rnd_buffer_size value: '-1024'
62 SELECT @@global.read_rnd_buffer_size;
63 @@global.read_rnd_buffer_size
64 1
65 SET @@global.read_rnd_buffer_size = 2147479553;
66 SELECT @@global.read_rnd_buffer_size;
67 @@global.read_rnd_buffer_size
68 2147479553
69 SET @@global.read_rnd_buffer_size = 65530.34;
70 ERROR 42000: Incorrect argument type to variable 'read_rnd_buffer_size'
71 SET @@global.read_rnd_buffer_size = test;
72 ERROR 42000: Incorrect argument type to variable 'read_rnd_buffer_size'
73 SET @@session.read_rnd_buffer_size = 8199;
74 SELECT @@session.read_rnd_buffer_size;
75 @@session.read_rnd_buffer_size
76 8199
77 SET @@session.read_rnd_buffer_size = -2;
78 Warnings:
79 Warning 1292 Truncated incorrect read_rnd_buffer_size value: '-2'
80 SELECT @@session.read_rnd_buffer_size;
81 @@session.read_rnd_buffer_size
82 1
83 SET @@session.read_rnd_buffer_size = 65530.34;
84 ERROR 42000: Incorrect argument type to variable 'read_rnd_buffer_size'
85 SET @@session.read_rnd_buffer_size = test;
86 ERROR 42000: Incorrect argument type to variable 'read_rnd_buffer_size'
87 '#------------------FN_DYNVARS_140_06-----------------------#'
88 SELECT @@global.read_rnd_buffer_size = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='read_rnd_buffer_size';
89 @@global.read_rnd_buffer_size = VARIABLE_VALUE
90 1
91 '#------------------FN_DYNVARS_140_07-----------------------#'
92 SELECT @@session.read_rnd_buffer_size =
93 VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='read_rnd_buffer_size';
94 @@session.read_rnd_buffer_size =
95 VARIABLE_VALUE
96 1
97 '#------------------FN_DYNVARS_140_08-----------------------#'
98 SET @@global.read_rnd_buffer_size = TRUE;
99 SELECT @@global.read_rnd_buffer_size;
100 @@global.read_rnd_buffer_size
101 1
102 SET @@global.read_rnd_buffer_size = FALSE;
103 Warnings:
104 Warning 1292 Truncated incorrect read_rnd_buffer_size value: '0'
105 SELECT @@global.read_rnd_buffer_size;
106 @@global.read_rnd_buffer_size
107 1
108 '#---------------------FN_DYNVARS_140_09----------------------#'
109 SET @@global.read_rnd_buffer_size = 9000;
110 SELECT @@read_rnd_buffer_size = @@global.read_rnd_buffer_size;
111 @@read_rnd_buffer_size = @@global.read_rnd_buffer_size
112 0
113 '#---------------------FN_DYNVARS_140_10----------------------#'
114 SET @@read_rnd_buffer_size = 9000;
115 SELECT @@read_rnd_buffer_size = @@local.read_rnd_buffer_size;
116 @@read_rnd_buffer_size = @@local.read_rnd_buffer_size
117 1
118 SELECT @@local.read_rnd_buffer_size = @@session.read_rnd_buffer_size;
119 @@local.read_rnd_buffer_size = @@session.read_rnd_buffer_size
120 1
121 '#---------------------FN_DYNVARS_140_11----------------------#'
122 SET read_rnd_buffer_size = 9100;
123 SELECT @@read_rnd_buffer_size;
124 @@read_rnd_buffer_size
125 9100
126 SELECT local.read_rnd_buffer_size;
127 ERROR 42S02: Unknown table 'local' in SELECT
128 SELECT session.read_rnd_buffer_size;
129 ERROR 42S02: Unknown table 'session' in SELECT
130 SELECT read_rnd_buffer_size = @@session.read_rnd_buffer_size;
131 ERROR 42S22: Unknown column 'read_rnd_buffer_size' in 'SELECT'
132 SET @@global.read_rnd_buffer_size = @start_global_value;
133 SELECT @@global.read_rnd_buffer_size;
134 @@global.read_rnd_buffer_size
135 262144
136 SET @@session.read_rnd_buffer_size = @start_session_value;
137 SELECT @@session.read_rnd_buffer_size;
138 @@session.read_rnd_buffer_size
139 262144