Debian Codegraph @

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

raw
1 SET @start_rpl_read_size = @@global.rpl_read_size;
2 SELECT @start_rpl_read_size;
3 @start_rpl_read_size
4 8192
5 '#--------------------TEST 01------------------------#'
6 SET @@global.rpl_read_size = 102400;
7 SET @@global.rpl_read_size = DEFAULT;
8 SELECT @@global.rpl_read_size;
9 @@global.rpl_read_size
10 8192
11 '#---------------------TEST_02-------------------------#'
12 SET @@global.rpl_read_size = @start_rpl_read_size;
13 SELECT @@global.rpl_read_size = 8192;
14 @@global.rpl_read_size = 8192
15 1
16 '#--------------------TEST_03------------------------#'
17 SET @@global.rpl_read_size = 81920;
18 SELECT @@global.rpl_read_size;
19 @@global.rpl_read_size
20 81920
21 SET @@global.rpl_read_size = 102400;
22 SELECT @@global.rpl_read_size;
23 @@global.rpl_read_size
24 102400
25 '#--------------------TEST_04-------------------------#'
26 SET @@global.rpl_read_size = -1;
27 Warnings:
28 Warning 1292 Truncated incorrect rpl_read_size value: '-1'
29 SELECT @@global.rpl_read_size;
30 @@global.rpl_read_size
31 8192
32 SET @@global.rpl_read_size = 4096;
33 Warnings:
34 Warning 1292 Truncated incorrect rpl_read_size value: '4096'
35 SELECT @@global.rpl_read_size;
36 @@global.rpl_read_size
37 8192
38 SET @@global.rpl_read_size = 18446744073709551616;
39 ERROR 42000: Incorrect argument type to variable 'rpl_read_size'
40 SELECT @@global.rpl_read_size;
41 @@global.rpl_read_size
42 8192
43 SET @@global.rpl_read_size = 10000.01;
44 ERROR 42000: Incorrect argument type to variable 'rpl_read_size'
45 SELECT @@global.rpl_read_size;
46 @@global.rpl_read_size
47 8192
48 SET @@global.rpl_read_size = ON;
49 ERROR 42000: Incorrect argument type to variable 'rpl_read_size'
50 SELECT @@global.rpl_read_size;
51 @@global.rpl_read_size
52 8192
53 SET @@global.rpl_read_size = 'test';
54 ERROR 42000: Incorrect argument type to variable 'rpl_read_size'
55 SELECT @@global.rpl_read_size;
56 @@global.rpl_read_size
57 8192
58 '#-------------------TEST_05----------------------------#'
59 SET @@session.rpl_read_size = 8192;
60 ERROR HY000: Variable 'rpl_read_size' is a GLOBAL variable and should be set with SET GLOBAL
61 SELECT @@session.rpl_read_size;
62 ERROR HY000: Variable 'rpl_read_size' is a GLOBAL variable
63 '#----------------------TEST_06------------------------#'
64 SELECT @@global.rpl_read_size = VARIABLE_VALUE
65 FROM performance_schema.global_variables
66 WHERE VARIABLE_NAME='rpl_read_size';
67 @@global.rpl_read_size = VARIABLE_VALUE
68 1
69 SELECT @@rpl_read_size = VARIABLE_VALUE
70 FROM performance_schema.session_variables
71 WHERE VARIABLE_NAME='rpl_read_size';
72 @@rpl_read_size = VARIABLE_VALUE
73 1
74 '#---------------------TEST_07----------------------#'
75 SET @@global.rpl_read_size = 16384;
76 SELECT @@rpl_read_size = @@global.rpl_read_size;
77 @@rpl_read_size = @@global.rpl_read_size
78 1
79 '#---------------------TEST_08----------------------#'
80 SET rpl_read_size = 8192;
81 ERROR HY000: Variable 'rpl_read_size' is a GLOBAL variable and should be set with SET GLOBAL
82 SELECT @@rpl_read_size;
83 @@rpl_read_size
84 16384
85 SET local.rpl_read_size = 8192
86 --Error ER_UNKNOWN_TABLE
87 SELECT local.rpl_read_size;
88 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.rpl_read_size = 8192
89 --Error ER_UNKNOWN_TABLE
90 SELECT local.rpl_read_size' at line 1
91 SET global.rpl_read_size = 8192;
92 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.rpl_read_size = 8192' at line 1
93 SELECT global.rpl_read_size;
94 ERROR 42S02: Unknown table 'global' in field list
95 SELECT rpl_read_size;
96 ERROR 42S22: Unknown column 'rpl_read_size' in 'field list'
97 SELECT @@session.rpl_read_size;
98 ERROR HY000: Variable 'rpl_read_size' is a GLOBAL variable
99 SET @@global.rpl_read_size = @start_rpl_read_size;
100 SELECT @@global.rpl_read_size;
101 @@global.rpl_read_size
102 8192