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

Assertion `entry->pos_in_table_list->table == entry' failed upon DELETE from non-updateable view

    XMLWordPrintable

Details

    Description

      CREATE TABLE t1 (a INT);
      CREATE VIEW v1 AS SELECT * FROM t1;
      CREATE VIEW v2 AS SELECT * FROM (WITH cte AS (SELECT COUNT(*) FROM v1) SELECT * FROM cte) sq;
      --error ER_NON_UPDATABLE_TABLE
      DELETE FROM v2;
       
      DROP VIEW v2;
      DROP VIEW v1;
      DROP TABLE t1;
      

      11.4 e176066a9e02cf2bdedf9e79fb150029dde430f6

      mariadbd: /data/bld/11.4-asan/sql/sql_select.cc:23496: void free_tmp_table(THD*, TABLE*): Assertion `entry->pos_in_table_list->table == entry' failed.
      250411  0:16:30 [ERROR] /share8t/bld/11.4-asan/sql/mariadbd got signal 6 ;
       
      #9  0x00007f9f28e53eb2 in __GI___assert_fail (assertion=0x558a12cb80c0 "entry->pos_in_table_list->table == entry", file=0x558a12ca9780 "/data/bld/11.4-asan/sql/sql_select.cc", line=23496, function=0x558a12cb8120 "void free_tmp_table(THD*, TABLE*)") at ./assert/assert.c:101
      #10 0x0000558a10aedce5 in free_tmp_table (thd=0x62c0000b0218, entry=0x62d000514438) at /data/bld/11.4-asan/sql/sql_select.cc:23496
      #11 0x0000558a107867eb in close_thread_tables (thd=0x62c0000b0218) at /data/bld/11.4-asan/sql/sql_base.cc:917
      #12 0x0000558a10785d74 in close_thread_tables_for_query (thd=0x62c0000b0218) at /data/bld/11.4-asan/sql/sql_base.cc:815
      #13 0x0000558a1095abdb in mysql_execute_command (thd=0x62c0000b0218, is_called_from_prepared_stmt=false) at /data/bld/11.4-asan/sql/sql_parse.cc:5968
      #14 0x0000558a109675b8 in mysql_parse (thd=0x62c0000b0218, rawbuf=0x62d0002d0438 "DELETE FROM v2", length=14, parser_state=0x7f9f1953fa90) at /data/bld/11.4-asan/sql/sql_parse.cc:7907
      #15 0x0000558a1093e61c in dispatch_command (command=COM_QUERY, thd=0x62c0000b0218, packet=0x629000253219 "DELETE FROM v2", packet_length=14, blocking=true) at /data/bld/11.4-asan/sql/sql_parse.cc:1904
      #16 0x0000558a1093b354 in do_command (thd=0x62c0000b0218, blocking=true) at /data/bld/11.4-asan/sql/sql_parse.cc:1417
      #17 0x0000558a10e20689 in do_handle_one_connection (connect=0x608000003b38, put_in_cache=true) at /data/bld/11.4-asan/sql/sql_connect.cc:1408
      #18 0x0000558a10e201e8 in handle_one_connection (arg=0x608000003ab8) at /data/bld/11.4-asan/sql/sql_connect.cc:1320
      #19 0x0000558a11aa281a in pfs_spawn_thread (arg=0x617000005b98) at /data/bld/11.4-asan/storage/perfschema/pfs.cc:2201
      #20 0x00007f9f28ea81c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #21 0x00007f9f28f2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      On a non-debug build DELETE ends with ER_NON_UPDATABLE_TABLE, as it apparently should.

      The failure is reproducible on 11.4 starting at least from the creation of 11.4 branch, but isn't reproducible on 10.11.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:

              Git Integration

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