diff options
| author | acurtis@pcgem.rdg.cyberkinetica.com <> | 2004-08-11 23:24:36 +0100 |
|---|---|---|
| committer | acurtis@pcgem.rdg.cyberkinetica.com <> | 2004-08-11 23:24:36 +0100 |
| commit | bc78a46ac4747bf430807f1969c207e13118404e (patch) | |
| tree | d28bf6e7c5f4619f160a0fc63b05537ff232526f /mysql-test/r/heap.result | |
| parent | 2d5fbe0aecd567d9458408caf7502648b4622707 (diff) | |
| download | mariadb-git-bc78a46ac4747bf430807f1969c207e13118404e.tar.gz | |
Bug#4411
Fix for server hang bug
Diffstat (limited to 'mysql-test/r/heap.result')
| -rw-r--r-- | mysql-test/r/heap.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/heap.result b/mysql-test/r/heap.result index bdf7dc225f3..11958f0a619 100644 --- a/mysql-test/r/heap.result +++ b/mysql-test/r/heap.result @@ -217,3 +217,13 @@ DELETE from t1 where a < 100; SELECT * from t1; a DROP TABLE t1; +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; +MAX(job_title_id) +NULL +DROP TABLE job_titles; |