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

Assertion `table' failed in mysql_delete on attempt to delete history from view

    XMLWordPrintable

Details

    Description

      Slightly modified reincarnation of MDEV-14684

      CREATE OR REPLACE TABLE t (i INT);
      CREATE OR REPLACE VIEW v AS SELECT * FROM t;
      LOCK TABLE v WRITE;
      DELETE HISTORY FROM v BEFORE system_time NOW(6);
       
      # Cleanup
      DROP VIEW v;
      DROP TABLE t;
      

      bb-10.3-release 7bed4877cb

      mysqld: /data/src/bb-10.3-release/sql/sql_delete.cc:312: bool mysql_delete(THD*, TABLE_LIST*, COND*, SQL_I_List<st_order>*, ha_rows, ulonglong, select_result*): Assertion `table' failed.
      180224  0:41:00 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fb76fdcdee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x000055e32a936ee8 in mysql_delete (thd=0x7fb758000b00, table_list=0x7fb758014da0, conds=0x0, order_list=0x7fb758005280, limit=18446744073709551615, options=0, result=0x0) at /data/src/bb-10.3-release/sql/sql_delete.cc:312
      #9  0x000055e32a4a0e2f in mysql_execute_command (thd=0x7fb758000b00) at /data/src/bb-10.3-release/sql/sql_parse.cc:4902
      #10 0x000055e32a4aa926 in mysql_parse (thd=0x7fb758000b00, rawbuf=0x7fb758014c98 "DELETE HISTORY FROM v BEFORE system_time NOW(6)", length=47, parser_state=0x7fb76a03c5d0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-release/sql/sql_parse.cc:7980
      #11 0x000055e32a4980d5 in dispatch_command (command=COM_QUERY, thd=0x7fb758000b00, packet=0x7fb75808fac1 "DELETE HISTORY FROM v BEFORE system_time NOW(6)", packet_length=47, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-release/sql/sql_parse.cc:1825
      #12 0x000055e32a496b14 in do_command (thd=0x7fb758000b00) at /data/src/bb-10.3-release/sql/sql_parse.cc:1370
      #13 0x000055e32a5fb2bf in do_handle_one_connection (connect=0x55e32e2f2be0) at /data/src/bb-10.3-release/sql/sql_connect.cc:1402
      #14 0x000055e32a5fb04c in handle_one_connection (arg=0x55e32e2f2be0) at /data/src/bb-10.3-release/sql/sql_connect.cc:1308
      #15 0x000055e32aa9cf1f in pfs_spawn_thread (arg=0x55e32e306480) at /data/src/bb-10.3-release/storage/perfschema/pfs.cc:1862
      #16 0x00007fb771aa4494 in start_thread (arg=0x7fb76a03d700) at pthread_create.c:333
      #17 0x00007fb76fe8a93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Not reproducible (yet) on main 10.3 2732fcc608.
      No visible effect on a non-debug build.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.