Debian Codegraph @

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

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