diff options
| author | unknown <monty@mysql.com> | 2004-10-23 03:30:27 +0300 |
|---|---|---|
| committer | unknown <monty@mysql.com> | 2004-10-23 03:30:27 +0300 |
| commit | 08c39dd283a8723912f5ce798701af3d25aa2747 (patch) | |
| tree | 1f64399a0e4969a64a4f1500ed9f131f3cc00bf5 /mysql-test/r/key.result | |
| parent | 371301d78675214f5bea1c66cb24796882792de4 (diff) | |
| download | mariadb-git-08c39dd283a8723912f5ce798701af3d25aa2747.tar.gz | |
Fixed wrong range test code for HEAP tables. This caused a crash when doing a range test with a key that didn't have lower or upper bound (Bug #6082)
More test cases
mysql-test/r/heap.result:
Test for bug #6082 (delete with NOT NULL)
mysql-test/r/key.result:
More tests for BUG#6151 - myisam index corruption
mysql-test/r/ps.result:
Test of bug #6047 "Permission problem when executing mysql_stmt_execute with derived table"
mysql-test/t/heap.test:
Test for bug #6082 (delete with NOT NULL)
mysql-test/t/key.test:
More tests for BUG#6151 - myisam index corruption
mysql-test/t/ps.test:
Test of bug #6047 "Permission problem when executing mysql_stmt_execute with derived table"
sql/ha_heap.cc:
Fixed wrong range test code for HEAP tables. This caused a crash when doing a range test with a key that didn't have lower or upper bound
Diffstat (limited to 'mysql-test/r/key.result')
| -rw-r--r-- | mysql-test/r/key.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/key.result b/mysql-test/r/key.result index 89307cf7080..e3b341fcaf8 100644 --- a/mysql-test/r/key.result +++ b/mysql-test/r/key.result @@ -296,4 +296,12 @@ Table Op Msg_type Msg_text test.t1 check status OK select c1 from t1 where c2='\Z\Z\Z\Z'; c1 +truncate table t1; +insert into t1 values(1,"aaaa"),(2,"aaab"),(3,"aaac"),(4,"aaccc"); +delete from t1 where c1=3; +delete from t1 where c1=1; +delete from t1 where c1=4; +check table t1; +Table Op Msg_type Msg_text +test.t1 check status OK drop table t1; |