1
SET @start_value = @@global.delay_key_write;
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
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
19
SET @@global.delay_key_write = OFF;
20
SELECT @@global.delay_key_write;
21
@@global.delay_key_write
23
SET @@global.delay_key_write = ALL;
24
SELECT @@global.delay_key_write;
25
@@global.delay_key_write
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: Variable 'delay_key_write' can't be set to the value of 'OF'
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 INFORMATION_SCHEMA.GLOBAL_VARIABLES
54
WHERE VARIABLE_NAME='delay_key_write';
55
@@delay_key_write = VARIABLE_VALUE
57
'#---------------------FN_DYNVARS_023_07-------------------------#'
58
SET @@global.delay_key_write = 0;
59
SELECT @@global.delay_key_write;
60
@@global.delay_key_write
62
SET @@global.delay_key_write = 1;
63
SELECT @@global.delay_key_write;
64
@@global.delay_key_write
66
SET @@global.delay_key_write = 2;
67
SELECT @@global.delay_key_write;
68
@@global.delay_key_write
70
'#---------------------FN_DYNVARS_023_08----------------------#'
71
SET @@global.delay_key_write = TRUE;
72
SELECT @@global.delay_key_write;
73
@@global.delay_key_write
75
SET @@global.delay_key_write = FALSE;
76
SELECT @@global.delay_key_write;
77
@@global.delay_key_write
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;
85
SET GLOBAL delay_key_write = OFF;
86
SELECT @@global.delay_key_write;
87
@@global.delay_key_write
89
SET @@global.delay_key_write = @start_value;
90
SELECT @@global.delay_key_write;
91
@@global.delay_key_write