Edit File: innodb_ft_enable_stopword_basic.result
SET @start_global_value = @@global.innodb_ft_enable_stopword; SELECT @start_global_value; @start_global_value 1 Valid values are 'ON' and 'OFF' select @@global.innodb_ft_enable_stopword in (0, 1); @@global.innodb_ft_enable_stopword in (0, 1) 1 select @@global.innodb_ft_enable_stopword; @@global.innodb_ft_enable_stopword 1 select @@session.innodb_ft_enable_stopword in (0, 1); @@session.innodb_ft_enable_stopword in (0, 1) 1 select @@session.innodb_ft_enable_stopword; @@session.innodb_ft_enable_stopword 1 show global variables like 'innodb_ft_enable_stopword'; Variable_name Value innodb_ft_enable_stopword ON show session variables like 'innodb_ft_enable_stopword'; Variable_name Value innodb_ft_enable_stopword ON select * from information_schema.global_variables where variable_name='innodb_ft_enable_stopword'; VARIABLE_NAME VARIABLE_VALUE INNODB_FT_ENABLE_STOPWORD ON select * from information_schema.session_variables where variable_name='innodb_ft_enable_stopword'; VARIABLE_NAME VARIABLE_VALUE INNODB_FT_ENABLE_STOPWORD ON set global innodb_ft_enable_stopword='OFF'; set session innodb_ft_enable_stopword='OFF'; select @@global.innodb_ft_enable_stopword; @@global.innodb_ft_enable_stopword 0 select @@session.innodb_ft_enable_stopword; @@session.innodb_ft_enable_stopword 0 select * from information_schema.global_variables where variable_name='innodb_ft_enable_stopword'; VARIABLE_NAME VARIABLE_VALUE INNODB_FT_ENABLE_STOPWORD OFF select * from information_schema.session_variables where variable_name='innodb_ft_enable_stopword'; VARIABLE_NAME VARIABLE_VALUE INNODB_FT_ENABLE_STOPWORD OFF set @@global.innodb_ft_enable_stopword=1; set @@session.innodb_ft_enable_stopword=1; select @@global.innodb_ft_enable_stopword; @@global.innodb_ft_enable_stopword 1 select @@session.innodb_ft_enable_stopword; @@session.innodb_ft_enable_stopword 1 select * from information_schema.global_variables where variable_name='innodb_ft_enable_stopword'; VARIABLE_NAME VARIABLE_VALUE INNODB_FT_ENABLE_STOPWORD ON select * from information_schema.session_variables where variable_name='innodb_ft_enable_stopword'; VARIABLE_NAME VARIABLE_VALUE INNODB_FT_ENABLE_STOPWORD ON set global innodb_ft_enable_stopword=0; set session innodb_ft_enable_stopword=0; select @@global.innodb_ft_enable_stopword; @@global.innodb_ft_enable_stopword 0 select @@session.innodb_ft_enable_stopword; @@session.innodb_ft_enable_stopword 0 select * from information_schema.global_variables where variable_name='innodb_ft_enable_stopword'; VARIABLE_NAME VARIABLE_VALUE INNODB_FT_ENABLE_STOPWORD OFF select * from information_schema.session_variables where variable_name='innodb_ft_enable_stopword'; VARIABLE_NAME VARIABLE_VALUE INNODB_FT_ENABLE_STOPWORD OFF set @@global.innodb_ft_enable_stopword='ON'; set @@session.innodb_ft_enable_stopword='ON'; select @@global.innodb_ft_enable_stopword; @@global.innodb_ft_enable_stopword 1 select @@session.innodb_ft_enable_stopword; @@session.innodb_ft_enable_stopword 1 select * from information_schema.global_variables where variable_name='innodb_ft_enable_stopword'; VARIABLE_NAME VARIABLE_VALUE INNODB_FT_ENABLE_STOPWORD ON select * from information_schema.session_variables where variable_name='innodb_ft_enable_stopword'; VARIABLE_NAME VARIABLE_VALUE INNODB_FT_ENABLE_STOPWORD ON set global innodb_ft_enable_stopword=1.1; ERROR 42000: Incorrect argument type to variable 'innodb_ft_enable_stopword' set session innodb_ft_enable_stopword=1.1; ERROR 42000: Incorrect argument type to variable 'innodb_ft_enable_stopword' set global innodb_ft_enable_stopword=1e1; ERROR 42000: Incorrect argument type to variable 'innodb_ft_enable_stopword' set session innodb_ft_enable_stopword=1e1; ERROR 42000: Incorrect argument type to variable 'innodb_ft_enable_stopword' set global innodb_ft_enable_stopword=2; ERROR 42000: Variable 'innodb_ft_enable_stopword' can't be set to the value of '2' set session innodb_ft_enable_stopword=2; ERROR 42000: Variable 'innodb_ft_enable_stopword' can't be set to the value of '2' set global innodb_ft_enable_stopword='AUTO'; ERROR 42000: Variable 'innodb_ft_enable_stopword' can't be set to the value of 'AUTO' set session innodb_ft_enable_stopword='AUTO'; ERROR 42000: Variable 'innodb_ft_enable_stopword' can't be set to the value of 'AUTO' NOTE: The following should fail with ER_WRONG_VALUE_FOR_VAR (BUG#50643) set global innodb_ft_enable_stopword=-3; set session innodb_ft_enable_stopword=-7; select @@global.innodb_ft_enable_stopword; @@global.innodb_ft_enable_stopword 1 select @@session.innodb_ft_enable_stopword; @@session.innodb_ft_enable_stopword 1 select * from information_schema.global_variables where variable_name='innodb_ft_enable_stopword'; VARIABLE_NAME VARIABLE_VALUE INNODB_FT_ENABLE_STOPWORD ON select * from information_schema.session_variables where variable_name='innodb_ft_enable_stopword'; VARIABLE_NAME VARIABLE_VALUE INNODB_FT_ENABLE_STOPWORD ON SET @@global.innodb_ft_enable_stopword = @start_global_value; SELECT @@global.innodb_ft_enable_stopword; @@global.innodb_ft_enable_stopword 1