diff options
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/handler.result | 12 | ||||
| -rw-r--r-- | mysql-test/r/variables.result | 4 |
2 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/handler.result b/mysql-test/r/handler.result index b25150919d6..fddad8dba51 100644 --- a/mysql-test/r/handler.result +++ b/mysql-test/r/handler.result @@ -193,3 +193,15 @@ Ok handler t close; use test; drop table t1; +create table t1 ( a int, b int, INDEX a (a) ); +insert into t1 values (1,2), (2,1); +handler t1 open; +handler t1 read a=(1) where b=2; +a b +1 2 +handler t1 read a=(1) where b=3; +a b +handler t1 read a=(1) where b=1; +a b +handler t1 close; +drop table t1; diff --git a/mysql-test/r/variables.result b/mysql-test/r/variables.result index 290b1fa41cf..fae2a74aa6d 100644 --- a/mysql-test/r/variables.result +++ b/mysql-test/r/variables.result @@ -386,6 +386,10 @@ select 1; 1 select @@session.key_buffer_size; ERROR HY000: Variable 'key_buffer_size' is a GLOBAL variable +set global myisam_max_sort_file_size=4294967296; +show global variables like 'myisam_max_sort_file_size'; +Variable_name Value +myisam_max_sort_file_size 4294967296 set ft_boolean_syntax = @@init_connect; ERROR HY000: Variable 'ft_boolean_syntax' is a GLOBAL variable and should be set with SET GLOBAL set global ft_boolean_syntax = @@init_connect; |