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.000000
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.000000
17 SELECT local.innodb_adaptive_flushing_lwm;
18 ERROR 42S02: Unknown table 'local' in SELECT
19 SET global innodb_adaptive_flushing_lwm = 1;
20 SELECT @@global.innodb_adaptive_flushing_lwm;
21 @@global.innodb_adaptive_flushing_lwm
22 1.000000
23 '#--------------------FN_DYNVARS_046_03------------------------#'
24 SET @@global.innodb_adaptive_flushing_lwm = 1;
25 SELECT @@global.innodb_adaptive_flushing_lwm;
26 @@global.innodb_adaptive_flushing_lwm
27 1.000000
28 SET @@global.innodb_adaptive_flushing_lwm = 60;
29 SELECT @@global.innodb_adaptive_flushing_lwm;
30 @@global.innodb_adaptive_flushing_lwm
31 60.000000
32 SET @@global.innodb_adaptive_flushing_lwm = 70;
33 SELECT @@global.innodb_adaptive_flushing_lwm;
34 @@global.innodb_adaptive_flushing_lwm
35 70.000000
36 '#--------------------FN_DYNVARS_046_04-------------------------#'
37 SET @@global.innodb_adaptive_flushing_lwm = -1;
38 Warnings:
39 Warning 1292 Truncated incorrect innodb_adaptive_flushing_lwm value: '-1'
40 SELECT @@global.innodb_adaptive_flushing_lwm;
41 @@global.innodb_adaptive_flushing_lwm
42 0.000000
43 SET @@global.innodb_adaptive_flushing_lwm = "T";
44 ERROR 42000: Incorrect argument type to variable 'innodb_adaptive_flushing_lwm'
45 SELECT @@global.innodb_adaptive_flushing_lwm;
46 @@global.innodb_adaptive_flushing_lwm
47 0.000000
48 SET @@global.innodb_adaptive_flushing_lwm = "Y";
49 ERROR 42000: Incorrect argument type to variable 'innodb_adaptive_flushing_lwm'
50 SELECT @@global.innodb_adaptive_flushing_lwm;
51 @@global.innodb_adaptive_flushing_lwm
52 0.000000
53 SET @@global.innodb_adaptive_flushing_lwm = 71;
54 Warnings:
55 Warning 1292 Truncated incorrect innodb_adaptive_flushing_lwm value: '71'
56 SELECT @@global.innodb_adaptive_flushing_lwm;
57 @@global.innodb_adaptive_flushing_lwm
58 70.000000
59 '#----------------------FN_DYNVARS_046_05------------------------#'
60 SELECT @@global.innodb_adaptive_flushing_lwm =
61 VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
62 WHERE VARIABLE_NAME='innodb_adaptive_flushing_lwm';
63 @@global.innodb_adaptive_flushing_lwm =
64 VARIABLE_VALUE
65 1
66 SELECT @@global.innodb_adaptive_flushing_lwm;
67 @@global.innodb_adaptive_flushing_lwm
68 70.000000
69 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
70 WHERE VARIABLE_NAME='innodb_adaptive_flushing_lwm';
71 VARIABLE_VALUE
72 70.000000
73 '#---------------------FN_DYNVARS_046_06-------------------------#'
74 SET @@global.innodb_adaptive_flushing_lwm = OFF;
75 ERROR 42000: Incorrect argument type to variable 'innodb_adaptive_flushing_lwm'
76 SELECT @@global.innodb_adaptive_flushing_lwm;
77 @@global.innodb_adaptive_flushing_lwm
78 70.000000
79 SET @@global.innodb_adaptive_flushing_lwm = ON;
80 ERROR 42000: Incorrect argument type to variable 'innodb_adaptive_flushing_lwm'
81 SELECT @@global.innodb_adaptive_flushing_lwm;
82 @@global.innodb_adaptive_flushing_lwm
83 70.000000
84 '#---------------------FN_DYNVARS_046_07----------------------#'
85 SET @@global.innodb_adaptive_flushing_lwm = TRUE;
86 SELECT @@global.innodb_adaptive_flushing_lwm;
87 @@global.innodb_adaptive_flushing_lwm
88 1.000000
89 SET @@global.innodb_adaptive_flushing_lwm = FALSE;
90 SELECT @@global.innodb_adaptive_flushing_lwm;
91 @@global.innodb_adaptive_flushing_lwm
92 0.000000
93 SET @@global.innodb_adaptive_flushing_lwm = @global_start_value;
94 SELECT @@global.innodb_adaptive_flushing_lwm;
95 @@global.innodb_adaptive_flushing_lwm
96 10.000000