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

Assertion `0' failed in Protocol::end_statement() on UNION ALL

    XMLWordPrintable

Details

    • 10.1.12

    Description

      CREATE TABLE t1 (f1 INT);
      CREATE TABLE t2 (f2 INT);
      INSERT INTO t1 VALUES (1),(2);
       
      ( SELECT 1 FROM t1 WHERE f1 NOT IN ( SELECT f2 FROM t2 ) LIMIT 0 )
      UNION ALL
      ( SELECT 1 FROM t1 WHERE f1 NOT IN ( SELECT f2 FROM t2 ) )
      ;

      Stack trace from 10.1 commit 7b14ba63f22e6c98c1982dae8847035ad1b8e155

      mysqld: /src/10.1/sql/protocol.cc:523: void Protocol::end_statement(): Assertion `0' failed.
      160129 13:37:25 [ERROR] mysqld got signal 6 ;
       
      #6  0x00007fb70bebe126 in __assert_fail_base () from /lib64/libc.so.6
      #7  0x00007fb70bebe1d2 in __assert_fail () from /lib64/libc.so.6
      #8  0x0000559da958109e in Protocol::end_statement (this=0x7fb707dc9ec0) at /src/10.1/sql/protocol.cc:523
      #9  0x0000559da9635a35 in dispatch_command (command=COM_QUERY, thd=0x7fb707dc9930, packet=0x7fb706fc92b1 "", packet_length=136) at /src/10.1/sql/sql_parse.cc:1941
      #10 0x0000559da96331a6 in do_command (thd=0x7fb707dc9930) at /src/10.1/sql/sql_parse.cc:1109
      #11 0x0000559da9768798 in do_handle_one_connection (thd_arg=0x7fb707dc9930) at /src/10.1/sql/sql_connect.cc:1349
      #12 0x0000559da97684fc in handle_one_connection (arg=0x7fb707dc9930) at /src/10.1/sql/sql_connect.cc:1261
      #13 0x0000559da9e6ebf2 in pfs_spawn_thread (arg=0x7fb7069b0e70) at /src/10.1/storage/perfschema/pfs.cc:1860
      #14 0x00007fb70de070a4 in start_thread () from /lib64/libpthread.so.0
      #15 0x00007fb70bf7504d in clone () from /lib64/libc.so.6

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.