Debian Codegraph @

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

raw
1 SET @start_value = @@global.delay_key_write;
2 SELECT @start_value;
3 @start_value
4 ON
5 '#--------------------FN_DYNVARS_023_01------------------------#'
6 SET @@global.delay_key_write = OFF;
7 SET @@global.delay_key_write = DEFAULT;
8 SELECT @@global.delay_key_write;
9 @@global.delay_key_write
10 ON
11 '#---------------------FN_DYNVARS_023_02-------------------------#'
12 SET @@global.delay_key_write = NULL;
13 ERROR 42000: Variable 'delay_key_write' can't be set to the value of 'NULL'
14 '#--------------------FN_DYNVARS_023_03------------------------#'
15 SET @@global.delay_key_write = ON;
16 SELECT @@global.delay_key_write;
17 @@global.delay_key_write
18 ON
19 SET @@global.delay_key_write = OFF;
20 SELECT @@global.delay_key_write;
21 @@global.delay_key_write
22 OFF
23 SET @@global.delay_key_write = ALL;
24 SELECT @@global.delay_key_write;
25 @@global.delay_key_write
26 ALL
27 '#--------------------FN_DYNVARS_023_04-------------------------#'
28 SET @@global.delay_key_write = 3;
29 ERROR 42000: Variable 'delay_key_write' can't be set to the value of '3'
30 SET @@global.delay_key_write = -1;
31 ERROR 42000: Variable 'delay_key_write' can't be set to the value of '-1'
32 SET @@global.delay_key_write = TRU;
33 ERROR 42000: Variable 'delay_key_write' can't be set to the value of 'TRU'
34 SET @@global.delay_key_write = ERROR;
35 ERROR 42000: Variable 'delay_key_write' can't be set to the value of 'ERROR'
36 SET @@global.delay_key_write = FALSE0;
37 ERROR 42000: Variable 'delay_key_write' can't be set to the value of 'FALSE0'
38 SET @@global.delay_key_write = ONN;
39 ERROR 42000: Variable 'delay_key_write' can't be set to the value of 'ONN'
40 SET @@global.delay_key_write = OF;
41 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OF' at line 1
42 SET @@global.delay_key_write = ' ';
43 ERROR 42000: Variable 'delay_key_write' can't be set to the value of ' '
44 SET @@global.delay_key_write = "";
45 ERROR 42000: Variable 'delay_key_write' can't be set to the value of ''
46 '#-------------------FN_DYNVARS_023_05----------------------------#'
47 SET @@delay_key_write = 0;
48 ERROR HY000: Variable 'delay_key_write' is a GLOBAL variable and should be set with SET GLOBAL
49 SELECT @@session.delay_key_write;
50 ERROR HY000: Variable 'delay_key_write' is a GLOBAL variable
51 '#----------------------FN_DYNVARS_023_06------------------------#'
52 SELECT @@delay_key_write = VARIABLE_VALUE
53 FROM performance_schema.global_variables
54 WHERE VARIABLE_NAME='delay_key_write';
55 @@delay_key_write = VARIABLE_VALUE
56 1
57 '#---------------------FN_DYNVARS_023_07-------------------------#'
58 SET @@global.delay_key_write = 0;
59 SELECT @@global.delay_key_write;
60 @@global.delay_key_write
61 OFF
62 SET @@global.delay_key_write = 1;
63 SELECT @@global.delay_key_write;
64 @@global.delay_key_write
65 ON
66 SET @@global.delay_key_write = 2;
67 SELECT @@global.delay_key_write;
68 @@global.delay_key_write
69 ALL
70 '#---------------------FN_DYNVARS_023_08----------------------#'
71 SET @@global.delay_key_write = TRUE;
72 SELECT @@global.delay_key_write;
73 @@global.delay_key_write
74 ON
75 SET @@global.delay_key_write = FALSE;
76 SELECT @@global.delay_key_write;
77 @@global.delay_key_write
78 OFF
79 '#---------------------FN_DYNVARS_023_09----------------------#'
80 SET delay_key_write = ON;
81 ERROR HY000: Variable 'delay_key_write' is a GLOBAL variable and should be set with SET GLOBAL
82 SELECT @@delay_key_write;
83 @@delay_key_write
84 OFF
85 SET GLOBAL delay_key_write = OFF;
86 SELECT @@global.delay_key_write;
87 @@global.delay_key_write
88 OFF
89 SET @@global.delay_key_write = @start_value;
90 SELECT @@global.delay_key_write;
91 @@global.delay_key_write
92 ON