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
ERROR 42000: Variable 'delay_key_write' doesn't have a default value
9
'Bug # 34878: Documentation specifies a DEFAULT value of ON for variable but';
11
SELECT @@global.delay_key_write;
12
@@global.delay_key_write
14
'#---------------------FN_DYNVARS_023_02-------------------------#'
15
SET @@global.delay_key_write = NULL;
16
ERROR 42000: Variable 'delay_key_write' can't be set to the value of 'NULL'
17
'#--------------------FN_DYNVARS_023_03------------------------#'
18
SET @@global.delay_key_write = ON;
19
SELECT @@global.delay_key_write;
20
@@global.delay_key_write
22
SET @@global.delay_key_write = OFF;
23
SELECT @@global.delay_key_write;
24
@@global.delay_key_write
26
SET @@global.delay_key_write = ALL;
27
SELECT @@global.delay_key_write;
28
@@global.delay_key_write
30
'#--------------------FN_DYNVARS_023_04-------------------------#'
31
SET @@global.delay_key_write = 3;
32
ERROR 42000: Variable 'delay_key_write' can't be set to the value of '3'
33
SET @@global.delay_key_write = -1;
34
ERROR 42000: Variable 'delay_key_write' can't be set to the value of '-1'
35
SET @@global.delay_key_write = TRU;
36
ERROR 42000: Variable 'delay_key_write' can't be set to the value of 'TRU'
37
SET @@global.delay_key_write = ERROR;
38
ERROR 42000: Variable 'delay_key_write' can't be set to the value of 'ERROR'
39
SET @@global.delay_key_write = FALSE0;
40
ERROR 42000: Variable 'delay_key_write' can't be set to the value of 'FALSE0'
41
SET @@global.delay_key_write = ONN;
42
ERROR 42000: Variable 'delay_key_write' can't be set to the value of 'ONN'
43
SET @@global.delay_key_write = OF;
44
SELECT @@global.delay_key_write;
45
@@global.delay_key_write
47
'Bug# 34828: Variable is incorrectly accepting OF as a value'
48
SET @@global.delay_key_write = ' ';
49
ERROR 42000: Variable 'delay_key_write' can't be set to the value of ' '
50
SET @@global.delay_key_write = "";
51
ERROR 42000: Variable 'delay_key_write' can't be set to the value of ''
52
'#-------------------FN_DYNVARS_023_05----------------------------#'
53
SET @@delay_key_write = 0;
54
ERROR HY000: Variable 'delay_key_write' is a GLOBAL variable and should be set with SET GLOBAL
55
SELECT @@session.delay_key_write;
56
ERROR HY000: Variable 'delay_key_write' is a GLOBAL variable
57
'#----------------------FN_DYNVARS_023_06------------------------#'
58
SELECT @@delay_key_write = VARIABLE_VALUE
59
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
60
WHERE VARIABLE_NAME='delay_key_write';
61
@@delay_key_write = VARIABLE_VALUE
63
'#---------------------FN_DYNVARS_023_07-------------------------#'
64
SET @@global.delay_key_write = 0;
65
SELECT @@global.delay_key_write;
66
@@global.delay_key_write
68
SET @@global.delay_key_write = 1;
69
SELECT @@global.delay_key_write;
70
@@global.delay_key_write
72
SET @@global.delay_key_write = 2;
73
SELECT @@global.delay_key_write;
74
@@global.delay_key_write
76
'#---------------------FN_DYNVARS_023_08----------------------#'
77
SET @@global.delay_key_write = TRUE;
78
SELECT @@global.delay_key_write;
79
@@global.delay_key_write
81
SET @@global.delay_key_write = FALSE;
82
SELECT @@global.delay_key_write;
83
@@global.delay_key_write
85
'#---------------------FN_DYNVARS_023_09----------------------#'
86
SET delay_key_write = ON;
87
ERROR HY000: Variable 'delay_key_write' is a GLOBAL variable and should be set with SET GLOBAL
88
SELECT @@delay_key_write;
91
SET GLOBAL delay_key_write = OFF;
92
SELECT @@global.delay_key_write;
93
@@global.delay_key_write
95
SET @@global.delay_key_write = @start_value;
96
SELECT @@global.delay_key_write;
97
@@global.delay_key_write