diff options
| author | Anurag Shekhar <anurag.shekhar@sun.com> | 2009-05-06 13:37:10 +0530 |
|---|---|---|
| committer | Anurag Shekhar <anurag.shekhar@sun.com> | 2009-05-06 13:37:10 +0530 |
| commit | 609a794b15fe44408fa47582e798147d1ffe3463 (patch) | |
| tree | f1f1fdf120a0888c698826d038a5087ebfa0fd5c /mysql-test/r/heap_btree.result | |
| parent | f0791b8b6b02286a7a01b7659050f3bd900a3529 (diff) | |
| download | mariadb-git-609a794b15fe44408fa47582e798147d1ffe3463.tar.gz | |
Bug #39918 memory (heap) engine crashing with b-tree index and DELETE
with seg fault
Multiple-table DELETE from a table joined to itself may cause
server crash. This was originally discovered with MEMORY engine,
but may affect other engines with different symptoms.
The problem was that the server violated SE API by performing
parallel table scan in one handler and removing records in
another (delete on the fly optimization).
mysql-test/r/heap_btree.result:
Updated test result after adding new test for this bug.
mysql-test/t/heap_btree.test:
Updated test result after adding new test for the bug report.
sql/sql_delete.cc:
Updated to check if the files in delete list appears in join list and disable
delete while scanning, if it appears.
Diffstat (limited to 'mysql-test/r/heap_btree.result')
| -rw-r--r-- | mysql-test/r/heap_btree.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/heap_btree.result b/mysql-test/r/heap_btree.result index c20dfbe80d2..65ced2bd24e 100644 --- a/mysql-test/r/heap_btree.result +++ b/mysql-test/r/heap_btree.result @@ -336,4 +336,11 @@ a b NULL NULL NULL 1 drop table t1; +# +# bug#39918 - memory (heap) engine crashing while executing self join with delete +# +CREATE TABLE t1(a INT, KEY USING BTREE (a)) ENGINE=MEMORY; +INSERT INTO t1 VALUES(1),(1); +DELETE a1 FROM t1 AS a1, t1 AS a2 WHERE a1.a=a2.a; +DROP TABLE t1; End of 5.0 tests |