1SET @session_start_value = @@session.foreign_key_checks;
2SELECT @session_start_value;
3@session_start_value
41
5'#--------------------FN_DYNVARS_032_01------------------------#'
6SET @@session.foreign_key_checks = 1;
7SET @@session.foreign_key_checks = DEFAULT;
8SELECT @@session.foreign_key_checks;
9@@session.foreign_key_checks
101
11'#---------------------FN_DYNVARS_032_02-------------------------#'
12SET foreign_key_checks = 1;
13SELECT @@foreign_key_checks;
14@@foreign_key_checks
151
16SELECT session.foreign_key_checks;
17ERROR 42S02: Unknown table 'session' in field list
18SELECT local.foreign_key_checks;
19ERROR 42S02: Unknown table 'local' in field list
20SET session foreign_key_checks = 0;
21SELECT @@session.foreign_key_checks;
22@@session.foreign_key_checks
230
24'#--------------------FN_DYNVARS_032_03------------------------#'
25SET @@session.foreign_key_checks = 0;
26SELECT @@session.foreign_key_checks;
27@@session.foreign_key_checks
280
29SET @@session.foreign_key_checks = 1;
30SELECT @@session.foreign_key_checks;
31@@session.foreign_key_checks
321
33'#--------------------FN_DYNVARS_032_04-------------------------#'
34SET @@session.foreign_key_checks = -1;
35ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of '-1'
36SET @@session.foreign_key_checks = 2;
37ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of '2'
38SET @@session.foreign_key_checks = "T";
39ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of 'T'
40SET @@session.foreign_key_checks = "Y";
41ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of 'Y'
42SET @@session.foreign_key_checks = TR�E;
43ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of 'TR�E'
44SET @@session.foreign_key_checks = �N;
45ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of '�N'
46SET @@session.foreign_key_checks = OF;
47ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of 'OF'
48SET @@session.foreign_key_checks = �FF;
49ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of '�FF'
50SET @@session.foreign_key_checks = '�';
51ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of '�'
52SET @@session.foreign_key_checks = NO;
53ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of 'NO'
54'#-------------------FN_DYNVARS_032_05----------------------------#'
55SET @@global.foreign_key_checks = 0;
56SELECT @@global.foreign_key_checks;
57@@global.foreign_key_checks
580
59SET @@global.foreign_key_checks = 1;
60'#----------------------FN_DYNVARS_032_06------------------------#'
61SELECT count(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='foreign_key_checks';
62count(VARIABLE_VALUE)
631
64'#----------------------FN_DYNVARS_032_07------------------------#'
65SELECT IF(@@session.foreign_key_checks, "ON", "OFF") = VARIABLE_VALUE
66FROM INFORMATION_SCHEMA.SESSION_VARIABLES
67WHERE VARIABLE_NAME='foreign_key_checks';
68IF(@@session.foreign_key_checks, "ON", "OFF") = VARIABLE_VALUE
691
70SELECT @@session.foreign_key_checks;
71@@session.foreign_key_checks
721
73SELECT VARIABLE_VALUE
74FROM INFORMATION_SCHEMA.SESSION_VARIABLES
75WHERE VARIABLE_NAME='foreign_key_checks';
76VARIABLE_VALUE
77ON
78'#---------------------FN_DYNVARS_032_08-------------------------#'
79SET @@session.foreign_key_checks = OFF;
80SELECT @@session.foreign_key_checks;
81@@session.foreign_key_checks
820
83SET @@session.foreign_key_checks = ON;
84SELECT @@session.foreign_key_checks;
85@@session.foreign_key_checks
861
87'#---------------------FN_DYNVARS_032_09----------------------#'
88SET @@session.foreign_key_checks = TRUE;
89SELECT @@session.foreign_key_checks;
90@@session.foreign_key_checks
911
92SET @@session.foreign_key_checks = FALSE;
93SELECT @@session.foreign_key_checks;
94@@session.foreign_key_checks
950
96SET @@session.foreign_key_checks = @session_start_value;
97SELECT @@session.foreign_key_checks;
98@@session.foreign_key_checks
991
100