| Server IP : 45.40.142.9 / Your IP : 216.73.216.250 Web Server : Apache System : Linux s45-40-142-9.secureserver.net 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : bayspec ( 506) PHP Version : 5.6.40 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/mysql-test/suite/sys_vars/r/ |
Upload File : |
SET @global_start_value = @@global.ft_boolean_syntax; SELECT @global_start_value; @global_start_value + -><()~*:""&| '#--------------------FN_DYNVARS_033_01------------------#' SELECT ft_boolean_syntax; ERROR 42S22: Unknown column 'ft_boolean_syntax' in 'field list' SELECT @@ft_boolean_syntax; @@ft_boolean_syntax + -><()~*:""&| SET @@global.ft_boolean_syntax='+ -><()~*:""&|'; SELECT @@global.ft_boolean_syntax; @@global.ft_boolean_syntax + -><()~*:""&| SET global ft_boolean_syntax='$ -><()`*:""&|'; SELECT global ft_boolean_syntax; ERROR 42S22: Unknown column 'global' in 'field list' '#--------------------FN_DYNVARS_033_02-------------------------#' SET @@global.ft_boolean_syntax = '# -><()!*:""&|'; SET @@global.ft_boolean_syntax = DEFAULT; SELECT @@global.ft_boolean_syntax; @@global.ft_boolean_syntax + -><()~*:""&| '#--------------------FN_DYNVARS_033_03-------------------------#' SET @@session.ft_boolean_syntax = '# -><()!*:""&|'; ERROR HY000: Variable 'ft_boolean_syntax' is a GLOBAL variable and should be set with SET GLOBAL SET @@ft_boolean_syntax = '# -><()!*:""&|'; ERROR HY000: Variable 'ft_boolean_syntax' is a GLOBAL variable and should be set with SET GLOBAL SELECT @@session.ft_boolean_syntax; ERROR HY000: Variable 'ft_boolean_syntax' is a GLOBAL variable SELECT @@local.ft_boolean_syntax; ERROR HY000: Variable 'ft_boolean_syntax' is a GLOBAL variable '#--------------------FN_DYNVARS_033_04-------------------------#' SET @@global.ft_boolean_syntax='+ -><()~*:""&|'; SELECT @@global.ft_boolean_syntax; @@global.ft_boolean_syntax + -><()~*:""&| SET @@global.ft_boolean_syntax=' +-><()~*:""&|'; SELECT @@global.ft_boolean_syntax; @@global.ft_boolean_syntax +-><()~*:""&| SET @@global.ft_boolean_syntax=' -+()<>~*:``&|'; SELECT @@global.ft_boolean_syntax; @@global.ft_boolean_syntax -+()<>~*:``&| SET @@global.ft_boolean_syntax='+ -><()~*:""@!'; SELECT @@global.ft_boolean_syntax; @@global.ft_boolean_syntax + -><()~*:""@! SET @@global.ft_boolean_syntax=" +-><()~*:''&|"; SELECT @@global.ft_boolean_syntax; @@global.ft_boolean_syntax +-><()~*:''&| SET @@global.ft_boolean_syntax=' ~/!@#$%^&*()-'; SELECT @@global.ft_boolean_syntax; @@global.ft_boolean_syntax ~/!@#$%^&*()- '#--------------------FN_DYNVARS_033_05-------------------------#' SET @@global.ft_boolean_syntax = '+-> <()~*:""&|'; ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '+-> <()~*:""&|' SET @@global.ft_boolean_syntax = '0'; ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '0' SET @@global.ft_boolean_syntax = '1 -><()~*:11&|'; ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '1 -><()~*:11&|' SET @@global.ft_boolean_syntax = '# -><()~*:11&1'; ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '# -><()~*:11&1' SET @@global.ft_boolean_syntax = '1234567890ABCD'; ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '1234567890ABCD' SET @@global.ft_boolean_syntax = -1; ERROR 42000: Incorrect argument type to variable 'ft_boolean_syntax' SET @@global.ft_boolean_syntax = '+-> <((~*:".&|'; ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '+-> <((~*:".&|' SET @@global.ft_boolean_syntax = ' '; ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of ' ' SET @@global.ft_boolean_syntax = ON; ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of 'ON' SET @@global.ft_boolean_syntax = true; ERROR 42000: Incorrect argument type to variable 'ft_boolean_syntax' SET @@global.ft_boolean_syntax = + -><()~*:""&|; 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 SET @@global.ft_boolean_syntax = ENABLE; ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of 'ENABLE' SET @@global.ft_boolean_syntax = 'IGNORE'; ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of 'IGNORE' '#--------------------FN_DYNVARS_033_06-------------------------#' SELECT @@global.ft_boolean_syntax = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='ft_boolean_syntax') AS res; res 1 '#--------------------FN_DYNVARS_033_07-------------------------#' SELECT @global_start_value; @global_start_value + -><()~*:""&| SET @@global.ft_boolean_syntax = @global_start_value; SET @@global.ft_boolean_syntax = DEFAULT; SELECT @@global.ft_boolean_syntax; @@global.ft_boolean_syntax + -><()~*:""&|