diff options
| author | unknown <sergefp@mysql.com> | 2007-09-10 16:26:51 +0400 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2007-09-10 16:26:51 +0400 |
| commit | 732f05a642279a569c6ed2b67fafff05b9de76c3 (patch) | |
| tree | a047b9f282dae4ad808feaba2b70309d45ec7bfa /mysql-test/r/delete.result | |
| parent | 10012b36feb18180892201b4afdd995e9e0f1a0a (diff) | |
| download | mariadb-git-732f05a642279a569c6ed2b67fafff05b9de76c3.tar.gz | |
BUG#30385: Server crash when deleting with ORDER BY and LIMIT
in get_index_for_order(), don't walk over the end of the index key parts
when matching index description and needed ordering.
mysql-test/r/delete.result:
BUG#30385: Testcase
mysql-test/t/delete.test:
BUG#30385: Testcase
Diffstat (limited to 'mysql-test/r/delete.result')
| -rw-r--r-- | mysql-test/r/delete.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/delete.result b/mysql-test/r/delete.result index a5c22e66569..5dd37e6b98d 100644 --- a/mysql-test/r/delete.result +++ b/mysql-test/r/delete.result @@ -193,4 +193,15 @@ select @a; @a 1 drop table t1; +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; End of 4.1 tests |