1
SET @global_start_value = @@global.ft_boolean_syntax;
2
SELECT @global_start_value;
5
'#--------------------FN_DYNVARS_033_01------------------#'
6
SELECT ft_boolean_syntax;
7
ERROR 42S22: Unknown column 'ft_boolean_syntax' in 'field list'
8
SELECT @@ft_boolean_syntax;
11
SET @@global.ft_boolean_syntax='+ -><()~*:""&|';
12
SELECT @@global.ft_boolean_syntax;
13
@@global.ft_boolean_syntax
15
SET global ft_boolean_syntax='$ -><()`*:""&|';
16
SELECT global ft_boolean_syntax;
17
ERROR 42S22: Unknown column 'global' in 'field list'
18
'#--------------------FN_DYNVARS_033_02-------------------------#'
19
SET @@global.ft_boolean_syntax = '# -><()!*:""&|';
20
SET @@global.ft_boolean_syntax = DEFAULT;
21
SELECT @@global.ft_boolean_syntax;
22
@@global.ft_boolean_syntax
24
'#--------------------FN_DYNVARS_033_03-------------------------#'
25
SET @@session.ft_boolean_syntax = '# -><()!*:""&|';
26
ERROR HY000: Variable 'ft_boolean_syntax' is a GLOBAL variable and should be set with SET GLOBAL
27
SET @@ft_boolean_syntax = '# -><()!*:""&|';
28
ERROR HY000: Variable 'ft_boolean_syntax' is a GLOBAL variable and should be set with SET GLOBAL
29
SELECT @@session.ft_boolean_syntax;
30
ERROR HY000: Variable 'ft_boolean_syntax' is a GLOBAL variable
31
SELECT @@local.ft_boolean_syntax;
32
ERROR HY000: Variable 'ft_boolean_syntax' is a GLOBAL variable
33
'#--------------------FN_DYNVARS_033_04-------------------------#'
34
SET @@global.ft_boolean_syntax='+ -><()~*:""&|';
35
SELECT @@global.ft_boolean_syntax;
36
@@global.ft_boolean_syntax
38
SET @@global.ft_boolean_syntax=' +-><()~*:""&|';
39
SELECT @@global.ft_boolean_syntax;
40
@@global.ft_boolean_syntax
42
SET @@global.ft_boolean_syntax=' -+()<>~*:``&|';
43
SELECT @@global.ft_boolean_syntax;
44
@@global.ft_boolean_syntax
46
SET @@global.ft_boolean_syntax='+ -><()~*:""@!';
47
SELECT @@global.ft_boolean_syntax;
48
@@global.ft_boolean_syntax
50
SET @@global.ft_boolean_syntax=" +-><()~*:''&|";
51
SELECT @@global.ft_boolean_syntax;
52
@@global.ft_boolean_syntax
54
SET @@global.ft_boolean_syntax=' ~/!@#$%^&*()-';
55
SELECT @@global.ft_boolean_syntax;
56
@@global.ft_boolean_syntax
58
'#--------------------FN_DYNVARS_033_05-------------------------#'
59
SET @@global.ft_boolean_syntax = '+-> <()~*:""&|';
60
ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '+-> <()~*:""&|'
61
SET @@global.ft_boolean_syntax = '0';
62
ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '0'
63
SET @@global.ft_boolean_syntax = '1 -><()~*:11&|';
64
ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '1 -><()~*:11&|'
65
SET @@global.ft_boolean_syntax = '# -><()~*:11&1';
66
ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '# -><()~*:11&1'
67
SET @@global.ft_boolean_syntax = '1234567890ABCD';
68
ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '1234567890ABCD'
69
SET @@global.ft_boolean_syntax = -1;
70
ERROR 42000: Incorrect argument type to variable 'ft_boolean_syntax'
71
SET @@global.ft_boolean_syntax = '+-> <((~*:".&|';
72
ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '+-> <((~*:".&|'
73
SET @@global.ft_boolean_syntax = ' ';
74
ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of ' '
75
SET @@global.ft_boolean_syntax = ON;
76
ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of 'ON'
77
SET @@global.ft_boolean_syntax = true;
78
ERROR 42000: Incorrect argument type to variable 'ft_boolean_syntax'
79
SET @@global.ft_boolean_syntax = + -><()~*:""&|;
80
ERROR 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
81
SET @@global.ft_boolean_syntax = ENABLE;
82
ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of 'ENABLE'
83
SET @@global.ft_boolean_syntax = 'IGNORE';
84
ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of 'IGNORE'
85
'#--------------------FN_DYNVARS_033_06-------------------------#'
86
SELECT @@global.ft_boolean_syntax = (SELECT VARIABLE_VALUE
87
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
88
WHERE VARIABLE_NAME='ft_boolean_syntax') AS res;
91
'#--------------------FN_DYNVARS_033_07-------------------------#'
92
SELECT @global_start_value;
95
SET @@global.ft_boolean_syntax = @global_start_value;
96
ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of ''
97
'Bug# 34883: ft_boolean_syntax cant be assigned values from session temporary';
99
SET @@global.ft_boolean_syntax = DEFAULT;
100
SELECT @@global.ft_boolean_syntax;
101
@@global.ft_boolean_syntax