Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.innodb_purge_batch_size;
2 SELECT @global_start_value;
3 @global_start_value
4 300
5 '#--------------------FN_DYNVARS_046_01------------------------#'
6 SET @@global.innodb_purge_batch_size = 1;
7 SET @@global.innodb_purge_batch_size = DEFAULT;
8 SELECT @@global.innodb_purge_batch_size;
9 @@global.innodb_purge_batch_size
10 300
11 '#---------------------FN_DYNVARS_046_02-------------------------#'
12 SET innodb_purge_batch_size = 1;
13 ERROR HY000: Variable 'innodb_purge_batch_size' is a GLOBAL variable and should be set with SET GLOBAL
14 SELECT @@innodb_purge_batch_size;
15 @@innodb_purge_batch_size
16 300
17 SELECT local.innodb_purge_batch_size;
18 ERROR 42S02: Unknown table 'local' in field list
19 SET global innodb_purge_batch_size = 1;
20 SELECT @@global.innodb_purge_batch_size;
21 @@global.innodb_purge_batch_size
22 1
23 '#--------------------FN_DYNVARS_046_03------------------------#'
24 SET @@global.innodb_purge_batch_size = 1;
25 SELECT @@global.innodb_purge_batch_size;
26 @@global.innodb_purge_batch_size
27 1
28 SET @@global.innodb_purge_batch_size = 5000;
29 SELECT @@global.innodb_purge_batch_size;
30 @@global.innodb_purge_batch_size
31 5000
32 SET @@global.innodb_purge_batch_size = 4294967295;
33 Warnings:
34 Warning 1292 Truncated incorrect innodb_purge_batch_size value: '4294967295'
35 SELECT @@global.innodb_purge_batch_size;
36 @@global.innodb_purge_batch_size
37 5000
38 '#--------------------FN_DYNVARS_046_04-------------------------#'
39 SET @@global.innodb_purge_batch_size = 0;
40 Warnings:
41 Warning 1292 Truncated incorrect innodb_purge_batch_size value: '0'
42 SELECT @@global.innodb_purge_batch_size;
43 @@global.innodb_purge_batch_size
44 1
45 SET @@global.innodb_purge_batch_size = "T";
46 ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size'
47 SELECT @@global.innodb_purge_batch_size;
48 @@global.innodb_purge_batch_size
49 1
50 SET @@global.innodb_purge_batch_size = "Y";
51 ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size'
52 SELECT @@global.innodb_purge_batch_size;
53 @@global.innodb_purge_batch_size
54 1
55 SET @@global.innodb_purge_batch_size = ' ';
56 ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size'
57 SELECT @@global.innodb_purge_batch_size;
58 @@global.innodb_purge_batch_size
59 1
60 SET @@global.innodb_purge_batch_size = " ";
61 ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size'
62 SELECT @@global.innodb_purge_batch_size;
63 @@global.innodb_purge_batch_size
64 1
65 SET @@global.innodb_purge_batch_size = 1.1;
66 ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size'
67 SELECT @@global.innodb_purge_batch_size;
68 @@global.innodb_purge_batch_size
69 1
70 SET @@global.innodb_purge_batch_size = 4294967297;
71 Warnings:
72 Warning 1292 Truncated incorrect innodb_purge_batch_size value: '4294967297'
73 SELECT @@global.innodb_purge_batch_size;
74 @@global.innodb_purge_batch_size
75 5000
76 '#----------------------FN_DYNVARS_046_05------------------------#'
77 SELECT @@global.innodb_purge_batch_size =
78 VARIABLE_VALUE FROM performance_schema.global_variables
79 WHERE VARIABLE_NAME='innodb_purge_batch_size';
80 @@global.innodb_purge_batch_size =
81 VARIABLE_VALUE
82 1
83 SELECT @@global.innodb_purge_batch_size;
84 @@global.innodb_purge_batch_size
85 5000
86 SELECT VARIABLE_VALUE FROM performance_schema.global_variables
87 WHERE VARIABLE_NAME='innodb_purge_batch_size';
88 VARIABLE_VALUE
89 5000
90 '#---------------------FN_DYNVARS_046_06-------------------------#'
91 SET @@global.innodb_purge_batch_size = OFF;
92 ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size'
93 SELECT @@global.innodb_purge_batch_size;
94 @@global.innodb_purge_batch_size
95 5000
96 SET @@global.innodb_purge_batch_size = ON;
97 ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size'
98 SELECT @@global.innodb_purge_batch_size;
99 @@global.innodb_purge_batch_size
100 5000
101 '#---------------------FN_DYNVARS_046_07----------------------#'
102 SET @@global.innodb_purge_batch_size = TRUE;
103 SELECT @@global.innodb_purge_batch_size;
104 @@global.innodb_purge_batch_size
105 1
106 SET @@global.innodb_purge_batch_size = FALSE;
107 Warnings:
108 Warning 1292 Truncated incorrect innodb_purge_batch_size value: '0'
109 SELECT @@global.innodb_purge_batch_size;
110 @@global.innodb_purge_batch_size
111 1
112 SET @@global.innodb_purge_batch_size = @global_start_value;
113 SELECT @@global.innodb_purge_batch_size;
114 @@global.innodb_purge_batch_size
115 300