[MDEV-5042] Server crashes when accessing incorrect MERGE table from trigger Created: 2013-09-20  Updated: 2013-10-14  Resolved: 2013-10-14

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.4
Fix Version/s: 10.0.5

Type: Bug Priority: Major
Reporter: Sergey Vojtovich Assignee: Sergey Vojtovich
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-4879 Merge test cases for new CREATE TEMPO... Closed

 Description   

CREATE TABLE t1(a INT);
CREATE TABLE m1(a INT) ENGINE = MERGE UNION (q1, q2);

CREATE TRIGGER trg1 BEFORE DELETE ON t1
FOR EACH ROW
INSERT INTO m1 VALUES (1);

--error ER_WRONG_MRG_TABLE
DELETE FROM t1;

Found while merging MDEV-4879 - Merge test cases for new CREATE TEMPORARY TABLE privilege model. When this bug is fixed, uncomment appropriate lines in merge.test.

The most likely reason is that revision dmitry.lenev@oracle.com-20110722123110-g3bzpbh90dje1ryk wasn't properly merged. This revision is targeted for mysql-5.5, mysql-5.6 has different fix.

 Comments   
Comment by Sergey Vojtovich [ 2013-10-14 ]

Fixed in 10.0.5, revision-id: svoj@mariadb.org-20131014083631-lp0xil6k01t59s6q

Generated at Thu Feb 08 07:01:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.