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

Assertion `thd->Item_change_list::is_empty()' failed in mysql_parse upon SELECT from a view reading from a versioned table

    XMLWordPrintable

Details

    Description

      Note: See also MDEV-16042, the test case is very similar, probably the issues are related..

      CREATE OR REPLACE TABLE t1 (a INT) WITH SYSTEM VERSIONING;
      CREATE OR REPLACE VIEW v1 AS SELECT * FROM t1;
      PREPARE stmt FROM "SELECT * FROM t1 WHERE EXP( '20010609211642053929' )";
      --error ER_DATA_OUT_OF_RANGE
      EXECUTE stmt;
      SELECT a FROM v1;
       
      # Cleanup
      DROP VIEW v1;
      DROP TABLE t1;
      

      10.3 99fa7c6c2f9c

      mysqld: /data/src/10.3/sql/sql_parse.cc:8025: void mysql_parse(THD*, char*, uint, Parser_state*, bool, bool): Assertion `thd->Item_change_list::is_empty()' failed.
      180427 13:13:36 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fe4e4ce0ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x0000559672c7f8f3 in mysql_parse (thd=0x7fe4c4000b00, rawbuf=0x7fe4c4124f78 "SELECT a FROM v1", length=16, parser_state=0x7fe4dae715d0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8025
      #9  0x0000559672c6cee9 in dispatch_command (command=COM_QUERY, thd=0x7fe4c4000b00, packet=0x7fe4c4090431 "", packet_length=16, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1846
      #10 0x0000559672c6b928 in do_command (thd=0x7fe4c4000b00) at /data/src/10.3/sql/sql_parse.cc:1391
      #11 0x0000559672dce88d in do_handle_one_connection (connect=0x559675783ea0) at /data/src/10.3/sql/sql_connect.cc:1402
      #12 0x0000559672dce61a in handle_one_connection (arg=0x559675783ea0) at /data/src/10.3/sql/sql_connect.cc:1308
      #13 0x0000559673252f27 in pfs_spawn_thread (arg=0x5596758257b0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      #14 0x00007fe4e69b7494 in start_thread (arg=0x7fe4dae72700) at pthread_create.c:333
      #15 0x00007fe4e4d9d93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              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.