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

LP:1007647 - Assertion `vcol_table == 0 || vcol_table == table' failed in fill_record(THD*, List<Item>&, List<Item>&, bool)

Details

    Description

      See also bug #1007622 (similar test case, might be the same problem)

      Version: '5.3.8-MariaDB-debug-log'
      mysqld: sql_base.cc:8694: bool fill_record(THD*, List<Item>&, List<Item>&, bool): Assertion `vcol_table == 0 || vcol_table == table' failed.

      #8 0xb74fa014 in __assert_fail () from /lib/libc.so.6
      #9 0x0833fded in fill_record (thd=0x93ee740, fields=..., values=...,
      ignore_errors=false) at sql_base.cc:8694
      #10 0x0833ff38 in fill_record_n_invoke_before_triggers (thd=0x93ee740, fields=...,
      values=..., ignore_errors=false, triggers=0x0, event=TRG_EVENT_INSERT)
      at sql_base.cc:8745
      #11 0x0838b6be in mysql_insert (thd=0x93ee740, table_list=0x948d778, fields=...,
      values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR,
      ignore=false) at sql_insert.cc:808
      #12 0x082e66b6 in mysql_execute_command (thd=0x93ee740) at sql_parse.cc:3233
      #13 0x082eef92 in mysql_parse (thd=0x93ee740,
      rawbuf=0x948d6b8 "INSERT INTO v2 (f1, f2) VALUES (1, 2)", length=37,
      found_semicolon=0xae973234) at sql_parse.cc:6153
      #14 0x082e1955 in dispatch_command (command=COM_QUERY, thd=0x93ee740,
      packet=0x9446331 "INSERT INTO v2 (f1, f2) VALUES (1, 2)", packet_length=37)
      at sql_parse.cc:1228
      #15 0x082e0dff in do_command (thd=0x93ee740) at sql_parse.cc:923
      #16 0x082ddcf5 in handle_one_connection (arg=0x93ee740) at sql_connect.cc:1218
      #17 0xb7788b25 in start_thread () from /lib/libpthread.so.0

      bzr version-info
      revision-id: <email address hidden>
      date: 2012-06-01 14:56:47 +0200
      revno: 3536

      Also reproducible on maria-5.5 revno 3425.
      Could not reproduce on maria-5.2, mysql-5.5, mysql-trunk.
      Reproducible with default optimizer_switch as well as with all OFF values.
      Reproducible with MyISAM, Aria, InnoDB.

      Test case:

      CREATE TABLE t1 (f1 INT, f2 INT);
      CREATE ALGORITHM=MERGE VIEW v1 AS SELECT a1.f1, a2.f2 FROM t1 AS a1, t1 AS a2;
      CREATE ALGORITHM=MERGE VIEW v2 AS SELECT * FROM v1;
      INSERT INTO v2 (f1, f2) VALUES (1, 2);

      1. End of test case
      1. End of test case

      Attachments

        Activity

          Re: Assertion `vcol_table == 0 || vcol_table == table' failed in fill_record(THD*, List<Item>&, List<Item>&, bool)
          Since the test case for this bug is very similar to lp:1007622, and it also exposes the same difference in behavior as lp:1007622, I assign it to Sanja.

          timour Timour Katchaounov (Inactive) added a comment - Re: Assertion `vcol_table == 0 || vcol_table == table' failed in fill_record(THD*, List<Item>&, List<Item>&, bool) Since the test case for this bug is very similar to lp:1007622, and it also exposes the same difference in behavior as lp:1007622, I assign it to Sanja.

          Re: Assertion `vcol_table == 0 || vcol_table == table' failed in fill_record(THD*, List<Item>&, List<Item>&, bool)
          Still reproducible on 5.3 revno 3552, although lp:1007622 is fixed there – so I assume it's not the same bug, after all.

          elenst Elena Stepanova added a comment - Re: Assertion `vcol_table == 0 || vcol_table == table' failed in fill_record(THD*, List<Item>&, List<Item>&, bool) Still reproducible on 5.3 revno 3552, although lp:1007622 is fixed there – so I assume it's not the same bug, after all.

          Launchpad bug id: 1007647

          ratzpo Rasmus Johansson (Inactive) added a comment - Launchpad bug id: 1007647

          The query is inserting into two different tables (actually the underlying table is the same but from different parts of join so it is different tables).

          sanja Oleksandr Byelkin added a comment - The query is inserting into two different tables (actually the underlying table is the same but from different parts of join so it is different tables).

          The problem is incorrectly detected merged view in tem_direct_view_ref::used_tables().

          sanja Oleksandr Byelkin added a comment - The problem is incorrectly detected merged view in tem_direct_view_ref::used_tables().

          Committed.

          sanja Oleksandr Byelkin added a comment - Committed.

          pushed

          sanja Oleksandr Byelkin added a comment - pushed

          tested on buildbot.

          sanja Oleksandr Byelkin added a comment - tested on buildbot.

          People

            sanja Oleksandr Byelkin
            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.