1SET @start_global_value = @@global.innodb_ft_enable_stopword; 2SELECT @start_global_value; 3@start_global_value 41 5Valid values are 'ON' and 'OFF' 6select @@global.innodb_ft_enable_stopword in (0, 1); 7@@global.innodb_ft_enable_stopword in (0, 1) 81 9select @@global.innodb_ft_enable_stopword; 10@@global.innodb_ft_enable_stopword 111 12select @@session.innodb_ft_enable_stopword in (0, 1); 13@@session.innodb_ft_enable_stopword in (0, 1) 141 15select @@session.innodb_ft_enable_stopword; 16@@session.innodb_ft_enable_stopword 171 18show global variables like 'innodb_ft_enable_stopword'; 19Variable_name Value 20innodb_ft_enable_stopword ON 21show session variables like 'innodb_ft_enable_stopword'; 22Variable_name Value 23innodb_ft_enable_stopword ON 24select * from information_schema.global_variables where variable_name='innodb_ft_enable_stopword'; 25VARIABLE_NAME VARIABLE_VALUE 26INNODB_FT_ENABLE_STOPWORD ON 27select * from information_schema.session_variables where variable_name='innodb_ft_enable_stopword'; 28VARIABLE_NAME VARIABLE_VALUE 29INNODB_FT_ENABLE_STOPWORD ON 30set global innodb_ft_enable_stopword='OFF'; 31set session innodb_ft_enable_stopword='OFF'; 32select @@global.innodb_ft_enable_stopword; 33@@global.innodb_ft_enable_stopword 340 35select @@session.innodb_ft_enable_stopword; 36@@session.innodb_ft_enable_stopword 370 38select * from information_schema.global_variables where variable_name='innodb_ft_enable_stopword'; 39VARIABLE_NAME VARIABLE_VALUE 40INNODB_FT_ENABLE_STOPWORD OFF 41select * from information_schema.session_variables where variable_name='innodb_ft_enable_stopword'; 42VARIABLE_NAME VARIABLE_VALUE 43INNODB_FT_ENABLE_STOPWORD OFF 44set @@global.innodb_ft_enable_stopword=1; 45set @@session.innodb_ft_enable_stopword=1; 46select @@global.innodb_ft_enable_stopword; 47@@global.innodb_ft_enable_stopword 481 49select @@session.innodb_ft_enable_stopword; 50@@session.innodb_ft_enable_stopword 511 52select * from information_schema.global_variables where variable_name='innodb_ft_enable_stopword'; 53VARIABLE_NAME VARIABLE_VALUE 54INNODB_FT_ENABLE_STOPWORD ON 55select * from information_schema.session_variables where variable_name='innodb_ft_enable_stopword'; 56VARIABLE_NAME VARIABLE_VALUE 57INNODB_FT_ENABLE_STOPWORD ON 58set global innodb_ft_enable_stopword=0; 59set session innodb_ft_enable_stopword=0; 60select @@global.innodb_ft_enable_stopword; 61@@global.innodb_ft_enable_stopword 620 63select @@session.innodb_ft_enable_stopword; 64@@session.innodb_ft_enable_stopword 650 66select * from information_schema.global_variables where variable_name='innodb_ft_enable_stopword'; 67VARIABLE_NAME VARIABLE_VALUE 68INNODB_FT_ENABLE_STOPWORD OFF 69select * from information_schema.session_variables where variable_name='innodb_ft_enable_stopword'; 70VARIABLE_NAME VARIABLE_VALUE 71INNODB_FT_ENABLE_STOPWORD OFF 72set @@global.innodb_ft_enable_stopword='ON'; 73set @@session.innodb_ft_enable_stopword='ON'; 74select @@global.innodb_ft_enable_stopword; 75@@global.innodb_ft_enable_stopword 761 77select @@session.innodb_ft_enable_stopword; 78@@session.innodb_ft_enable_stopword 791 80select * from information_schema.global_variables where variable_name='innodb_ft_enable_stopword'; 81VARIABLE_NAME VARIABLE_VALUE 82INNODB_FT_ENABLE_STOPWORD ON 83select * from information_schema.session_variables where variable_name='innodb_ft_enable_stopword'; 84VARIABLE_NAME VARIABLE_VALUE 85INNODB_FT_ENABLE_STOPWORD ON 86set global innodb_ft_enable_stopword=1.1; 87ERROR 42000: Incorrect argument type to variable 'innodb_ft_enable_stopword' 88set session innodb_ft_enable_stopword=1.1; 89ERROR 42000: Incorrect argument type to variable 'innodb_ft_enable_stopword' 90set global innodb_ft_enable_stopword=1e1; 91ERROR 42000: Incorrect argument type to variable 'innodb_ft_enable_stopword' 92set session innodb_ft_enable_stopword=1e1; 93ERROR 42000: Incorrect argument type to variable 'innodb_ft_enable_stopword' 94set global innodb_ft_enable_stopword=2; 95ERROR 42000: Variable 'innodb_ft_enable_stopword' can't be set to the value of '2' 96set session innodb_ft_enable_stopword=2; 97ERROR 42000: Variable 'innodb_ft_enable_stopword' can't be set to the value of '2' 98set global innodb_ft_enable_stopword='AUTO'; 99ERROR 42000: Variable 'innodb_ft_enable_stopword' can't be set to the value of 'AUTO' 100set session innodb_ft_enable_stopword='AUTO'; 101ERROR 42000: Variable 'innodb_ft_enable_stopword' can't be set to the value of 'AUTO' 102NOTE: The following should fail with ER_WRONG_VALUE_FOR_VAR (BUG#50643) 103set global innodb_ft_enable_stopword=-3; 104set session innodb_ft_enable_stopword=-7; 105select @@global.innodb_ft_enable_stopword; 106@@global.innodb_ft_enable_stopword 1071 108select @@session.innodb_ft_enable_stopword; 109@@session.innodb_ft_enable_stopword 1101 111select * from information_schema.global_variables where variable_name='innodb_ft_enable_stopword'; 112VARIABLE_NAME VARIABLE_VALUE 113INNODB_FT_ENABLE_STOPWORD ON 114select * from information_schema.session_variables where variable_name='innodb_ft_enable_stopword'; 115VARIABLE_NAME VARIABLE_VALUE 116INNODB_FT_ENABLE_STOPWORD ON 117SET @@global.innodb_ft_enable_stopword = @start_global_value; 118SELECT @@global.innodb_ft_enable_stopword; 119@@global.innodb_ft_enable_stopword 1201 121