diff options
| author | unknown <ingo@mysql.com> | 2005-11-07 12:16:49 +0100 |
|---|---|---|
| committer | unknown <ingo@mysql.com> | 2005-11-07 12:16:49 +0100 |
| commit | 5412ee4f299a4a2d71db1b7e5f3e62132032fb00 (patch) | |
| tree | a2a5cb9b8ca900cb6ef4eb4e876f7497fbf3bcba /mysql-test/t/myisam.test | |
| parent | fb4c949f57b281a232ea581e26b8c48be6c1d873 (diff) | |
| download | mariadb-git-5412ee4f299a4a2d71db1b7e5f3e62132032fb00.tar.gz | |
Bug#14616 - Freshly imported table returns error 124 when using LIMIT
Initialized usable_keys from table->keys_in_use instead of ~0
in test_if_skip_sort_order(). It was possible that a disabled
index was used for sorting.
mysql-test/r/myisam.result:
Bug#14616 - Freshly imported table returns error 124 when using LIMIT
The test result.
mysql-test/t/myisam.test:
Bug#14616 - Freshly imported table returns error 124 when using LIMIT
The test case.
Diffstat (limited to 'mysql-test/t/myisam.test')
| -rw-r--r-- | mysql-test/t/myisam.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/myisam.test b/mysql-test/t/myisam.test index 57b64e30bac..a502002d30e 100644 --- a/mysql-test/t/myisam.test +++ b/mysql-test/t/myisam.test @@ -446,3 +446,15 @@ explain select count(*) from t1 where a is null; select count(*) from t1 where a is null; drop table t1; +# +# Bug#14616 - Freshly imported table returns error 124 when using LIMIT +# +create table t1 ( + c1 varchar(32), + key (c1) +) engine=myisam; +alter table t1 disable keys; +insert into t1 values ('a'), ('b'); +select c1 from t1 order by c1 limit 1; +drop table t1; + |