diff options
| author | serg@serg.mylan <> | 2004-08-18 19:57:55 +0200 |
|---|---|---|
| committer | serg@serg.mylan <> | 2004-08-18 19:57:55 +0200 |
| commit | e1237cbc53355382e032f0e88f906d67edd1f597 (patch) | |
| tree | 8ac7985dc9b6caddd1c2402ef8606e4a4cd85ada /mysql-test/t/heap.test | |
| parent | 7c69afaf15eda7d51b2254e71c7078aaab3aa0f3 (diff) | |
| parent | 8ce92878a2c32785a5af86e9ffa27b4904d01694 (diff) | |
| download | mariadb-git-e1237cbc53355382e032f0e88f906d67edd1f597.tar.gz | |
manually merged
Diffstat (limited to 'mysql-test/t/heap.test')
| -rw-r--r-- | mysql-test/t/heap.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/heap.test b/mysql-test/t/heap.test index d867d5f4323..56442dfd6fd 100644 --- a/mysql-test/t/heap.test +++ b/mysql-test/t/heap.test @@ -150,3 +150,17 @@ INSERT into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11); DELETE from t1 where a < 100; SELECT * from t1; DROP TABLE t1; + +# +# Bug#4411 Server hangs when trying to SELECT MAX(id) from an empty HEAP table +# +CREATE TABLE `job_titles` ( + `job_title_id` int(6) unsigned NOT NULL default '0', + `job_title` char(18) NOT NULL default '', + PRIMARY KEY (`job_title_id`), + UNIQUE KEY `job_title_id` (`job_title_id`,`job_title`) +) TYPE=HEAP; + +SELECT MAX(job_title_id) FROM job_titles; + +DROP TABLE job_titles; |