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