1
SET @session_start_value = @@session.foreign_key_checks;
2
SELECT @session_start_value;
5
'#--------------------FN_DYNVARS_032_01------------------------#'
6
SET @@session.foreign_key_checks = 1;
7
SET @@session.foreign_key_checks = DEFAULT;
8
SELECT @@session.foreign_key_checks;
9
@@session.foreign_key_checks
11
'Bug# 34878: No DEFAULT value for variable. Also setting DEFAULT does not give error'
12
'#---------------------FN_DYNVARS_032_02-------------------------#'
13
SET foreign_key_checks = 1;
14
SELECT @@foreign_key_checks;
17
SELECT session.foreign_key_checks;
18
ERROR 42S02: Unknown table 'session' in field list
19
SELECT local.foreign_key_checks;
20
ERROR 42S02: Unknown table 'local' in field list
21
SET session foreign_key_checks = 0;
22
SELECT @@session.foreign_key_checks;
23
@@session.foreign_key_checks
25
'#--------------------FN_DYNVARS_032_03------------------------#'
26
SET @@session.foreign_key_checks = 0;
27
SELECT @@session.foreign_key_checks;
28
@@session.foreign_key_checks
30
SET @@session.foreign_key_checks = 1;
31
SELECT @@session.foreign_key_checks;
32
@@session.foreign_key_checks
34
'#--------------------FN_DYNVARS_032_04-------------------------#'
35
SET @@session.foreign_key_checks = -1;
36
ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of '-1'
37
SET @@session.foreign_key_checks = 2;
38
ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of '2'
39
SET @@session.foreign_key_checks = "T";
40
ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of 'T'
41
SET @@session.foreign_key_checks = "Y";
42
ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of 'Y'
43
SET @@session.foreign_key_checks = TR�E;
44
ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of 'TRÜE'
45
SET @@session.foreign_key_checks = �N;
46
ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of 'ÕN'
47
SET @@session.foreign_key_checks = OF;
48
SELECT @@session.foreign_key_checks;
49
@@session.foreign_key_checks
51
'Bug# 34828: OF is taken as OFF and a value of 0 is set.'
52
SET @@session.foreign_key_checks = �FF;
53
ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of 'ÓFF'
54
SET @@session.foreign_key_checks = '�';
55
ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of '�'
56
SET @@session.foreign_key_checks = NO;
57
ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of 'NO'
58
'#-------------------FN_DYNVARS_032_05----------------------------#'
59
SET @@global.foreign_key_checks = 0;
60
ERROR HY000: Variable 'foreign_key_checks' is a SESSION variable and can't be used with SET GLOBAL
61
SELECT @@global.foreign_key_checks;
62
ERROR HY000: Variable 'foreign_key_checks' is a SESSION variable
63
'#----------------------FN_DYNVARS_032_06------------------------#'
64
SELECT count(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='foreign_key_checks';
67
'#----------------------FN_DYNVARS_032_07------------------------#'
68
SELECT @@session.foreign_key_checks = VARIABLE_VALUE
69
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
70
WHERE VARIABLE_NAME='foreign_key_checks';
71
@@session.foreign_key_checks = VARIABLE_VALUE
73
SELECT @@session.foreign_key_checks;
74
@@session.foreign_key_checks
77
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
78
WHERE VARIABLE_NAME='foreign_key_checks';
81
'#---------------------FN_DYNVARS_032_08-------------------------#'
82
SET @@session.foreign_key_checks = OFF;
83
SELECT @@session.foreign_key_checks;
84
@@session.foreign_key_checks
86
SET @@session.foreign_key_checks = ON;
87
SELECT @@session.foreign_key_checks;
88
@@session.foreign_key_checks
90
'#---------------------FN_DYNVARS_032_09----------------------#'
91
SET @@session.foreign_key_checks = TRUE;
92
SELECT @@session.foreign_key_checks;
93
@@session.foreign_key_checks
95
SET @@session.foreign_key_checks = FALSE;
96
SELECT @@session.foreign_key_checks;
97
@@session.foreign_key_checks
99
SET @@session.foreign_key_checks = @session_start_value;
100
SELECT @@session.foreign_key_checks;
101
@@session.foreign_key_checks