Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5042

Server crashes when accessing incorrect MERGE table from trigger

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.0.4
        • Fix Version/s: 10.0.5
        • Component/s: None
        • Labels:
          None

          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.

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Bug - A problem which impairs or prevents the functions of the product. MDEV-4879 Merge test cases for new CREATE TEMPORARY TABLE privilege model

                • Major - Major loss of function.
                • Closed

                  Activity

                  Hide
                  Permalink
                  svoj Sergey Vojtovich added a comment -

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

                  Show
                  svoj Sergey Vojtovich added a comment - Fixed in 10.0.5, revision-id: svoj@mariadb.org-20131014083631-lp0xil6k01t59s6q

                    People

                    • Assignee:
                      svoj Sergey Vojtovich
                      Reporter:
                      svoj Sergey Vojtovich
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      1 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: