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

mysqld got signal 11 on delete returning

    Details

    • 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
    • Labels:
      None
    • Environment:
      Debian 9.1
      mariadb-server-10.2
       mariadb-plugin-connect 10.2

      Description

      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.

        Attachments

        1. error.log
          3 kB
        2. my.cnf
          6 kB

          Issue Links

            Activity

              People

              • Assignee:
                igor Igor Babaev
                Reporter:
                mohit_chandel23@yahoo.com Mohit Chandel
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: