diff options
| author | unknown <ingo@mysql.com> | 2005-11-15 16:07:05 +0100 |
|---|---|---|
| committer | unknown <ingo@mysql.com> | 2005-11-15 16:07:05 +0100 |
| commit | b0a5184d80ecf985a53830184b48e4b11532b3e6 (patch) | |
| tree | 9cc0a95cc0f7b689783f201f550cf8b48702860e /mysql-test | |
| parent | dc44851352f68e240074ecc571216a8c2503ae0b (diff) | |
| parent | 5412ee4f299a4a2d71db1b7e5f3e62132032fb00 (diff) | |
| download | mariadb-git-b0a5184d80ecf985a53830184b48e4b11532b3e6.tar.gz | |
Merge mysql.com:/home/mydev/mysql-4.0-bug14616
into mysql.com:/home/mydev/mysql-4.1-4100
mysql-test/r/myisam.result:
Bug#14616 - Freshly imported table returns error 124 when using LIMIT
Manual merge.
mysql-test/t/myisam.test:
Bug#14616 - Freshly imported table returns error 124 when using LIMIT
Manual merge.
sql/sql_select.cc:
Bug#14616 - Freshly imported table returns error 124 when using LIMIT
Manual merge.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/myisam.result | 10 | ||||
| -rw-r--r-- | mysql-test/t/myisam.test | 12 |
2 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index 55504e8e75b..352cc2fabb9 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -498,6 +498,16 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 system NULL NULL NULL NULL 1 Using temporary 1 SIMPLE t2 index NULL PRIMARY 4 NULL 2 Using index; Distinct drop table t1,t2; +drop table t1; +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; +c1 +a CREATE TABLE t1 (`a` int(11) NOT NULL default '0', `b` int(11) NOT NULL default '0', UNIQUE KEY `a` USING RTREE (`a`,`b`)) ENGINE=MyISAM; Got one of the listed errors create table t1 (a int, b varchar(200), c text not null) checksum=1; diff --git a/mysql-test/t/myisam.test b/mysql-test/t/myisam.test index 8e9862015bc..ce40cae3266 100644 --- a/mysql-test/t/myisam.test +++ b/mysql-test/t/myisam.test @@ -474,6 +474,18 @@ explain select distinct t1.a from t1,t2 order by t2.a; drop table t1,t2; # +# 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; + +# # Test RTREE index # --error 1235, 1289 |