diff options
| author | unknown <lars/lthalmann@mysql.com/dl145h.mysql.com> | 2007-10-01 11:23:44 +0200 |
|---|---|---|
| committer | unknown <lars/lthalmann@mysql.com/dl145h.mysql.com> | 2007-10-01 11:23:44 +0200 |
| commit | ec75be400b78b70f8c68f89cc2a0741f6f1593b6 (patch) | |
| tree | 3a28a9d2838b6a9c8ef0d588e85dad944eef728a /mysql-test/t/delete.test | |
| parent | a46fc5d8371e06bf77010503c90349d871b65950 (diff) | |
| parent | 7a2bb241bd0a80303385ef251ccb422c99c33a0b (diff) | |
| download | mariadb-git-ec75be400b78b70f8c68f89cc2a0741f6f1593b6.tar.gz | |
Merge mysql.com:/nfsdisk1/lars/bkroot/mysql-4.1-rpl
into mysql.com:/nfsdisk1/lars/MERGE/mysql-4.1-merge
Diffstat (limited to 'mysql-test/t/delete.test')
| -rw-r--r-- | mysql-test/t/delete.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/delete.test b/mysql-test/t/delete.test index 301b2cdbb99..fdbb96e0c2f 100644 --- a/mysql-test/t/delete.test +++ b/mysql-test/t/delete.test @@ -184,4 +184,17 @@ delete from t1 where (@a:= f1) order by f1 limit 1; select @a; drop table t1; +# BUG#30385 "Server crash when deleting with order by and limit" +CREATE TABLE t1 ( + `date` date , + `time` time , + `seq` int(10) unsigned NOT NULL auto_increment, + PRIMARY KEY (`seq`), + KEY `seq` (`seq`), + KEY `time` (`time`), + KEY `date` (`date`) +); +DELETE FROM t1 ORDER BY date ASC, time ASC LIMIT 1; +drop table t1; + --echo End of 4.1 tests |