Debian Codegraph @

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

raw
1 SET @start_value = @@global.binlog_stmt_cache_size;
2 set @@global.binlog_stmt_cache_size=default;
3 SELECT @@global.binlog_stmt_cache_size;
4 @@global.binlog_stmt_cache_size
5 32768
6 '#--------------------FN_DYNVARS_006_01------------------------#'
7 SET @@global.binlog_stmt_cache_size = 100;
8 Warnings:
9 Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '100'
10 SET @@global.binlog_stmt_cache_size = DEFAULT;
11 SELECT @@global.binlog_stmt_cache_size;
12 @@global.binlog_stmt_cache_size
13 32768
14 '#---------------------FN_DYNVARS_006_02-------------------------#'
15 SET @@global.binlog_stmt_cache_size = default;
16 SELECT @@global.binlog_stmt_cache_size = 32768;
17 @@global.binlog_stmt_cache_size = 32768
18 1
19 '#--------------------FN_DYNVARS_006_03------------------------#'
20 SET @@global.binlog_stmt_cache_size = 4096;
21 SELECT @@global.binlog_stmt_cache_size;
22 @@global.binlog_stmt_cache_size
23 4096
24 SET @@global.binlog_stmt_cache_size = 4294967295;
25 Warnings:
26 Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '4294967295'
27 SELECT @@global.binlog_stmt_cache_size;
28 @@global.binlog_stmt_cache_size
29 4294963200
30 SET @@global.binlog_stmt_cache_size = 10000;
31 Warnings:
32 Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '10000'
33 SELECT @@global.binlog_stmt_cache_size;
34 @@global.binlog_stmt_cache_size
35 8192
36 SET @@global.binlog_stmt_cache_size = 21221204;
37 Warnings:
38 Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '21221204'
39 SELECT @@global.binlog_stmt_cache_size;
40 @@global.binlog_stmt_cache_size
41 21217280
42 'Bug: Invalid values are coming in variable on assigning valid values'
43 '#--------------------FN_DYNVARS_006_04-------------------------#'
44 SET @@global.binlog_stmt_cache_size = 1024;
45 Warnings:
46 Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '1024'
47 SELECT @@global.binlog_stmt_cache_size;
48 @@global.binlog_stmt_cache_size
49 4096
50 SET @@global.binlog_stmt_cache_size = 10000.01;
51 ERROR 42000: Incorrect argument type to variable 'binlog_stmt_cache_size'
52 SET @@global.binlog_stmt_cache_size = -1024;
53 Warnings:
54 Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '-1024'
55 SELECT @@global.binlog_stmt_cache_size;
56 @@global.binlog_stmt_cache_size
57 4096
58 SET @@global.binlog_stmt_cache_size = 42949672950;
59 Warnings:
60 Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '42949672950'
61 SELECT @@global.binlog_stmt_cache_size;
62 @@global.binlog_stmt_cache_size
63 max_binlog_cache_size
64 'Bug: Errors are not coming on assigning invalid values to variable'
65 SET @@global.binlog_stmt_cache_size = ON;
66 ERROR 42000: Incorrect argument type to variable 'binlog_stmt_cache_size'
67 SET @@global.binlog_stmt_cache_size = 'test';
68 ERROR 42000: Incorrect argument type to variable 'binlog_stmt_cache_size'
69 '#-------------------FN_DYNVARS_006_05----------------------------#'
70 SET @@session.binlog_stmt_cache_size = 0;
71 ERROR HY000: Variable 'binlog_stmt_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
72 '#----------------------FN_DYNVARS_006_06------------------------#'
73 SELECT @@global.binlog_stmt_cache_size = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='binlog_stmt_cache_size';
74 @@global.binlog_stmt_cache_size = VARIABLE_VALUE
75 1
76 '#---------------------FN_DYNVARS_006_07----------------------#'
77 SET @@global.binlog_stmt_cache_size = TRUE;
78 Warnings:
79 Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '1'
80 SELECT @@global.binlog_stmt_cache_size;
81 @@global.binlog_stmt_cache_size
82 4096
83 SET @@global.binlog_stmt_cache_size = FALSE;
84 Warnings:
85 Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '0'
86 SELECT @@global.binlog_stmt_cache_size;
87 @@global.binlog_stmt_cache_size
88 4096
89 'Bug: Errors are not coming on assigning TRUE/FALSE to variable'
90 '#---------------------FN_DYNVARS_006_08----------------------#'
91 SET @@global.binlog_stmt_cache_size = 1;
92 Warnings:
93 Warning 1292 Truncated incorrect binlog_stmt_cache_size value: '1'
94 SELECT @@binlog_stmt_cache_size = @@global.binlog_stmt_cache_size;
95 @@binlog_stmt_cache_size = @@global.binlog_stmt_cache_size
96 1
97 '#---------------------FN_DYNVARS_006_09----------------------#'
98 SET binlog_stmt_cache_size = 1;
99 ERROR HY000: Variable 'binlog_stmt_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
100 SELECT global.binlog_stmt_cache_size;
101 ERROR 42S02: Unknown table 'global' in SELECT
102 SELECT binlog_stmt_cache_size = @@session.binlog_stmt_cache_size;
103 ERROR 42S22: Unknown column 'binlog_stmt_cache_size' in 'SELECT'
104 SET @@global.binlog_stmt_cache_size = @start_value;