1SET @global_start_value = @@global.ft_boolean_syntax;
2SELECT @global_start_value;
3@global_start_value
4+ -><()~*:""&|
5'#--------------------FN_DYNVARS_033_01------------------#'
6SELECT ft_boolean_syntax;
7ERROR 42S22: Unknown column 'ft_boolean_syntax' in 'field list'
8SELECT @@ft_boolean_syntax;
9@@ft_boolean_syntax
10+ -><()~*:""&|
11SET @@global.ft_boolean_syntax='+ -><()~*:""&|';
12SELECT @@global.ft_boolean_syntax;
13@@global.ft_boolean_syntax
14+ -><()~*:""&|
15SET global ft_boolean_syntax='$ -><()`*:""&|';
16SELECT global ft_boolean_syntax;
17ERROR 42S22: Unknown column 'global' in 'field list'
18'#--------------------FN_DYNVARS_033_02-------------------------#'
19SET @@global.ft_boolean_syntax = '# -><()!*:""&|';
20SET @@global.ft_boolean_syntax = DEFAULT;
21SELECT @@global.ft_boolean_syntax;
22@@global.ft_boolean_syntax
23+ -><()~*:""&|
24'#--------------------FN_DYNVARS_033_03-------------------------#'
25SET @@session.ft_boolean_syntax = '# -><()!*:""&|';
26ERROR HY000: Variable 'ft_boolean_syntax' is a GLOBAL variable and should be set with SET GLOBAL
27SET @@ft_boolean_syntax = '# -><()!*:""&|';
28ERROR HY000: Variable 'ft_boolean_syntax' is a GLOBAL variable and should be set with SET GLOBAL
29SELECT @@session.ft_boolean_syntax;
30ERROR HY000: Variable 'ft_boolean_syntax' is a GLOBAL variable
31SELECT @@local.ft_boolean_syntax;
32ERROR HY000: Variable 'ft_boolean_syntax' is a GLOBAL variable
33'#--------------------FN_DYNVARS_033_04-------------------------#'
34SET @@global.ft_boolean_syntax='+ -><()~*:""&|';
35SELECT @@global.ft_boolean_syntax;
36@@global.ft_boolean_syntax
37+ -><()~*:""&|
38SET @@global.ft_boolean_syntax=' +-><()~*:""&|';
39SELECT @@global.ft_boolean_syntax;
40@@global.ft_boolean_syntax
41 +-><()~*:""&|
42SET @@global.ft_boolean_syntax=' -+()<>~*:``&|';
43SELECT @@global.ft_boolean_syntax;
44@@global.ft_boolean_syntax
45 -+()<>~*:``&|
46SET @@global.ft_boolean_syntax='+ -><()~*:""@!';
47SELECT @@global.ft_boolean_syntax;
48@@global.ft_boolean_syntax
49+ -><()~*:""@!
50SET @@global.ft_boolean_syntax=" +-><()~*:''&|";
51SELECT @@global.ft_boolean_syntax;
52@@global.ft_boolean_syntax
53 +-><()~*:''&|
54SET @@global.ft_boolean_syntax=' ~/!@#$%^&*()-';
55SELECT @@global.ft_boolean_syntax;
56@@global.ft_boolean_syntax
57 ~/!@#$%^&*()-
58'#--------------------FN_DYNVARS_033_05-------------------------#'
59SET @@global.ft_boolean_syntax = '+-> <()~*:""&|';
60ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '+-> <()~*:""&|'
61SET @@global.ft_boolean_syntax = '0';
62ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '0'
63SET @@global.ft_boolean_syntax = '1 -><()~*:11&|';
64ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '1 -><()~*:11&|'
65SET @@global.ft_boolean_syntax = '# -><()~*:11&1';
66ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '# -><()~*:11&1'
67SET @@global.ft_boolean_syntax = '1234567890ABCD';
68ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '1234567890ABCD'
69SET @@global.ft_boolean_syntax = -1;
70ERROR 42000: Incorrect argument type to variable 'ft_boolean_syntax'
71SET @@global.ft_boolean_syntax = '+-> <((~*:".&|';
72ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '+-> <((~*:".&|'
73SET @@global.ft_boolean_syntax = ' ';
74ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of ' '
75SET @@global.ft_boolean_syntax = ON;
76ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of 'ON'
77SET @@global.ft_boolean_syntax = true;
78ERROR 42000: Incorrect argument type to variable 'ft_boolean_syntax'
79SET @@global.ft_boolean_syntax = + -><()~*:""&|;
80ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-><()~*:""&|' at line 1
81SET @@global.ft_boolean_syntax = ENABLE;
82ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of 'ENABLE'
83SET @@global.ft_boolean_syntax = 'IGNORE';
84ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of 'IGNORE'
85'#--------------------FN_DYNVARS_033_06-------------------------#'
86SELECT @@global.ft_boolean_syntax = (SELECT VARIABLE_VALUE
87FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
88WHERE VARIABLE_NAME='ft_boolean_syntax') AS res;
89res
901
91'#--------------------FN_DYNVARS_033_07-------------------------#'
92SELECT @global_start_value;
93@global_start_value
94+ -><()~*:""&|
95SET @@global.ft_boolean_syntax = @global_start_value;
96SET @@global.ft_boolean_syntax = DEFAULT;
97SELECT @@global.ft_boolean_syntax;
98@@global.ft_boolean_syntax
99+ -><()~*:""&|
100