diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/t/innodb_adaptive_hash_index_basic.test')
| -rw-r--r-- | mysql-test/suite/sys_vars/t/innodb_adaptive_hash_index_basic.test | 9 |
1 files changed, 4 insertions, 5 deletions
diff --git a/mysql-test/suite/sys_vars/t/innodb_adaptive_hash_index_basic.test b/mysql-test/suite/sys_vars/t/innodb_adaptive_hash_index_basic.test index 5171c0e1621..88e239574d2 100644 --- a/mysql-test/suite/sys_vars/t/innodb_adaptive_hash_index_basic.test +++ b/mysql-test/suite/sys_vars/t/innodb_adaptive_hash_index_basic.test @@ -6,20 +6,20 @@ --source include/have_innodb.inc SET @start_global_value = @@global.innodb_adaptive_hash_index; -SELECT @start_global_value; # # exists as global only # --echo Valid values are 'ON' and 'OFF' select @@global.innodb_adaptive_hash_index in (0, 1); -select @@global.innodb_adaptive_hash_index; --error ER_INCORRECT_GLOBAL_LOCAL_VAR select @@session.innodb_adaptive_hash_index; +--replace_column 2 # show global variables like 'innodb_adaptive_hash_index'; +--replace_column 2 # show session variables like 'innodb_adaptive_hash_index'; -select * from information_schema.global_variables where variable_name='innodb_adaptive_hash_index'; -select * from information_schema.session_variables where variable_name='innodb_adaptive_hash_index'; +select variable_name from information_schema.global_variables where variable_name='innodb_adaptive_hash_index'; +select variable_name from information_schema.session_variables where variable_name='innodb_adaptive_hash_index'; # # show that it's writable @@ -67,4 +67,3 @@ set global innodb_adaptive_hash_index='AUTO'; # SET @@global.innodb_adaptive_hash_index = @start_global_value; -SELECT @@global.innodb_adaptive_hash_index; |