# 2011-11-15 - Added # --source include/have_innodb.inc SET @start_global_value = @@global.innodb_ft_user_stopword_table; SELECT @start_global_value; # # exists as session as well # select @@session.innodb_ft_user_stopword_table; show global variables like 'innodb_ft_user_stopword_table'; show session variables like 'innodb_ft_user_stopword_table'; select * from information_schema.global_variables where variable_name='innodb_ft_user_stopword_table'; select * from information_schema.session_variables where variable_name='innodb_ft_user_stopword_table'; --error ER_WRONG_VALUE_FOR_VAR set session innodb_ft_user_stopword_table='Salmon'; --error ER_WRONG_VALUE_FOR_VAR set @@session.innodb_ft_user_stopword_table='Salmon'; # # incorrect types # --error ER_WRONG_TYPE_FOR_VAR set global innodb_ft_user_stopword_table=1.1; --error ER_WRONG_TYPE_FOR_VAR set global innodb_ft_user_stopword_table=1e1; --error ER_WRONG_VALUE_FOR_VAR set global innodb_ft_user_stopword_table='Salmon';