Debian Codegraph @

mysql-test/suite/sys_vars/r/ft_boolean_syntax_basic.result

raw
1 SET @global_start_value = @@global.ft_boolean_syntax;
2 SELECT @global_start_value;
3 @global_start_value
4 + -><()~*:""&|
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;
9 @@ft_boolean_syntax
10 + -><()~*:""&|
11 SET @@global.ft_boolean_syntax='+ -><()~*:""&|';
12 SELECT @@global.ft_boolean_syntax;
13 @@global.ft_boolean_syntax
14 + -><()~*:""&|
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
23 + -><()~*:""&|
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
37 + -><()~*:""&|
38 SET @@global.ft_boolean_syntax=' +-><()~*:""&|';
39 SELECT @@global.ft_boolean_syntax;
40 @@global.ft_boolean_syntax
41 +-><()~*:""&|
42 SET @@global.ft_boolean_syntax=' -+()<>~*:``&|';
43 SELECT @@global.ft_boolean_syntax;
44 @@global.ft_boolean_syntax
45 -+()<>~*:``&|
46 SET @@global.ft_boolean_syntax='+ -><()~*:""@!';
47 SELECT @@global.ft_boolean_syntax;
48 @@global.ft_boolean_syntax
49 + -><()~*:""@!
50 SET @@global.ft_boolean_syntax=" +-><()~*:''&|";
51 SELECT @@global.ft_boolean_syntax;
52 @@global.ft_boolean_syntax
53 +-><()~*:''&|
54 SET @@global.ft_boolean_syntax=' ~/!@#$%^&*()-';
55 SELECT @@global.ft_boolean_syntax;
56 @@global.ft_boolean_syntax
57 ~/!@#$%^&*()-
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 performance_schema.global_variables
88 WHERE VARIABLE_NAME='ft_boolean_syntax') AS res;
89 res
90 1
91 '#--------------------FN_DYNVARS_033_07-------------------------#'
92 SELECT @global_start_value;
93 @global_start_value
94 + -><()~*:""&|
95 SET @@global.ft_boolean_syntax = @global_start_value;
96 SET @@global.ft_boolean_syntax = DEFAULT;
97 SELECT @@global.ft_boolean_syntax;
98 @@global.ft_boolean_syntax
99 + -><()~*:""&|