1SET @start_value = @@global.sync_frm;
2SELECT @start_value;
3@start_value
4VAL
5'#--------------------FN_DYNVARS_169_01------------------------#'
6SET @@global.sync_frm = FALSE;
7SET @@global.sync_frm = DEFAULT;
8SELECT @@global.sync_frm;
9@@global.sync_frm
101
11'#---------------------FN_DYNVARS_169_02-------------------------#'
12SET @@global.sync_frm = DEFAULT;
13SELECT @@global.sync_frm = TRUE;
14@@global.sync_frm = TRUE
151
16'#--------------------FN_DYNVARS_169_03------------------------#'
17SET @@global.sync_frm = ON;
18SELECT @@global.sync_frm;
19@@global.sync_frm
201
21SET @@global.sync_frm = OFF;
22SELECT @@global.sync_frm;
23@@global.sync_frm
240
25SET @@global.sync_frm = 0;
26SELECT @@global.sync_frm;
27@@global.sync_frm
280
29SET @@global.sync_frm = 1;
30SELECT @@global.sync_frm;
31@@global.sync_frm
321
33SET @@global.sync_frm = TRUE;
34SELECT @@global.sync_frm;
35@@global.sync_frm
361
37SET @@global.sync_frm = FALSE;
38SELECT @@global.sync_frm;
39@@global.sync_frm
400
41'#--------------------FN_DYNVARS_169_04-------------------------#'
42SET @@global.sync_frm = 2;
43ERROR 42000: Variable 'sync_frm' can't be set to the value of '2'
44SET @@global.sync_frm = -1;
45ERROR 42000: Variable 'sync_frm' can't be set to the value of '-1'
46SET @@global.sync_frm = TRUEF;
47ERROR 42000: Variable 'sync_frm' can't be set to the value of 'TRUEF'
48SET @@global.sync_frm = TRUE_F;
49ERROR 42000: Variable 'sync_frm' can't be set to the value of 'TRUE_F'
50SET @@global.sync_frm = FALSE0;
51ERROR 42000: Variable 'sync_frm' can't be set to the value of 'FALSE0'
52SET @@global.sync_frm = OON;
53ERROR 42000: Variable 'sync_frm' can't be set to the value of 'OON'
54SET @@global.sync_frm = ONN;
55ERROR 42000: Variable 'sync_frm' can't be set to the value of 'ONN'
56SET @@global.sync_frm = OOFF;
57ERROR 42000: Variable 'sync_frm' can't be set to the value of 'OOFF'
58SET @@global.sync_frm = 0FF;
59ERROR 42000: Variable 'sync_frm' can't be set to the value of '0FF'
60SET @@global.sync_frm = ' ';
61ERROR 42000: Variable 'sync_frm' can't be set to the value of ' '
62SET @@global.sync_frm = " ";
63ERROR 42000: Variable 'sync_frm' can't be set to the value of ' '
64SET @@global.sync_frm = '';
65ERROR 42000: Variable 'sync_frm' can't be set to the value of ''
66'#-------------------FN_DYNVARS_169_05----------------------------#'
67SET @@session.sync_frm = 1;
68ERROR HY000: Variable 'sync_frm' is a GLOBAL variable and should be set with SET GLOBAL
69SELECT @@session.sync_frm;
70ERROR HY000: Variable 'sync_frm' is a GLOBAL variable
71'#----------------------FN_DYNVARS_169_06------------------------#'
72SELECT IF(@@global.sync_frm, "ON", "OFF") = VARIABLE_VALUE
73FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
74WHERE VARIABLE_NAME='sync_frm';
75IF(@@global.sync_frm, "ON", "OFF") = VARIABLE_VALUE
761
77'#---------------------FN_DYNVARS_169_07----------------------#'
78SET @@global.sync_frm = 1;
79SELECT @@sync_frm = @@global.sync_frm;
80@@sync_frm = @@global.sync_frm
811
82'#---------------------FN_DYNVARS_169_08----------------------#'
83SET sync_frm = 1;
84ERROR HY000: Variable 'sync_frm' is a GLOBAL variable and should be set with SET GLOBAL
85SELECT @@sync_frm;
86@@sync_frm
871
88SELECT global.sync_frm;
89ERROR 42S02: Unknown table 'global' in field list
90SELECT sync_frm = @@session.sync_frm;
91ERROR 42S22: Unknown column 'sync_frm' in 'field list'
92SET @@global.sync_frm = @start_value;
93SELECT @@global.sync_frm;
94@@global.sync_frm
95VAL
96