diff options
| author | unknown <acurtis@pcgem.rdg.cyberkinetica.com> | 2004-08-11 23:24:36 +0100 |
|---|---|---|
| committer | unknown <acurtis@pcgem.rdg.cyberkinetica.com> | 2004-08-11 23:24:36 +0100 |
| commit | 4f08c4b72686a258800d950293e2a9827879707e (patch) | |
| tree | d28bf6e7c5f4619f160a0fc63b05537ff232526f /mysql-test/t/heap.test | |
| parent | 2a64371e649666d54d66193bb52e4d430fe800b8 (diff) | |
| download | mariadb-git-4f08c4b72686a258800d950293e2a9827879707e.tar.gz | |
Bug#4411
Fix for server hang bug
mysql-test/r/heap.result:
Bug#4411
Test for server hang bug
mysql-test/t/heap.test:
Bug#4411
Test for server hang bug
sql/opt_sum.cc:
Bug#4411
Allow code to exit the loop.
BitKeeper/etc/logging_ok:
Logging to logging@openlogging.org accepted
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 b2de58ca083..87518798a36 100644 --- a/mysql-test/t/heap.test +++ b/mysql-test/t/heap.test @@ -147,3 +147,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; |