Debian Codegraph @

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

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