-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.0, 10.1, 10.2, 10.2.8
-
Fix Version/s: 10.0.33
-
Component/s: Data Manipulation - Delete
-
Labels:None
-
Environment:Debian 9.1
mariadb-server-10.2
mariadb-plugin-connect 10.2
MariaDB 10.2.8 got Signal 11 while executing DELETE RETURNING * query.
Test Case
========
CREATE TABLE t1 (id INT);
|
CREATE TABLE t2 (id INT);
|
|
|
INSERT INTO t1 VALUE(1);
|
INSERT INTO t1 VALUE(2);
|
INSERT INTO t1 VALUE(3);
|
|
|
INSERT INTO t2 VALUE(3);
|
INSERT INTO t2 VALUE(4);
|
INSERT INTO t2 VALUE(5);
|
|
DELETE FROM t1 WHERE id NOT IN (SELECT id FROM t2) returning *;
|
I have attached the error log. Would be happy to provide any other info, if required.
- relates to
-
-
- Closed
-