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