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

LP:601156 - RQG: item_subselect.cc:4635: virtual void subselect_partial_match_engine::print(String*, enum_query_type): Assertion `(0)' failed.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      When executing the query below, MariaDB 5.3 asserts as follows:

      mysqld: item_subselect.cc:4635: virtual void subselect_partial_match_engine::print(String*, enum_query_type): Assertion `(0)' failed.

      The assertion seems to be introduced by the following patch:

      https://lists.launchpad.net/maria-developers/msg02447.html

      Backtrace:

      #8 0x00897de8 in __assert_fail () from /lib/libc.so.6
      #9 0x08232040 in subselect_partial_match_engine::print (this=0x99c2da8, str=0xb6e5f33c, query_type=QT_ORDINARY) at item_subselect.cc:4635
      #10 0x08228d59 in Item_subselect::print (this=0x98e23c0, str=0xb6e5f33c, query_type=QT_ORDINARY) at item_subselect.cc:559
      #11 0x0822c8eb in Item_in_subselect::print (this=0x98e23c0, str=0xb6e5f33c, query_type=QT_ORDINARY) at item_subselect.cc:1985
      #12 0x081da127 in Item_func::print_args (this=0x9991ef0, str=0xb6e5f33c, from=0, query_type=QT_ORDINARY) at item_func.cc:418
      #13 0x081da0ad in Item_func::print (this=0x9991ef0, str=0xb6e5f33c, query_type=QT_ORDINARY) at item_func.cc:407
      #14 0x081da127 in Item_func::print_args (this=0x98e24d0, str=0xb6e5f33c, from=0, query_type=QT_ORDINARY) at item_func.cc:418
      #15 0x081da0ad in Item_func::print (this=0x98e24d0, str=0xb6e5f33c, query_type=QT_ORDINARY) at item_func.cc:407
      #16 0x081f0226 in Item_func_not::print (this=0x98e24d0, str=0xb6e5f33c, query_type=QT_ORDINARY) at item_cmpfunc.cc:304
      #17 0x081fb70e in Item_cond::print (this=0x98e2550, str=0xb6e5f33c, query_type=QT_ORDINARY) at item_cmpfunc.cc:4447
      #18 0x0832547c in st_select_lex::print (this=0x98e1168, thd=0x97841a0, str=0xb6e5f33c, query_type=QT_ORDINARY) at sql_select.cc:18816
      #19 0x081a0df8 in st_select_lex_unit::print (this=0x98e1300, str=0xb6e5f33c, query_type=QT_ORDINARY) at sql_lex.cc:2036
      #20 0x08324e55 in TABLE_LIST::print (this=0x99919d8, thd=0x97841a0, eliminated_tables=0, str=0xb6e5f33c, query_type=QT_ORDINARY) at sql_select.cc:18678
      #21 0x08324770 in print_table_array (thd=0x97841a0, eliminated_tables=0, str=0xb6e5f33c, table=0x99e70f8, end=0x99e70fc, query_type=QT_ORDINARY)
      at sql_select.cc:18509
      #22 0x08324b78 in print_join (thd=0x97841a0, eliminated_tables=0, str=0xb6e5f33c, tables=0x9785b5c, query_type=QT_ORDINARY) at sql_select.cc:18603
      #23 0x083253da in st_select_lex::print (this=0x9785a98, thd=0x97841a0, str=0xb6e5f33c, query_type=QT_ORDINARY) at sql_select.cc:18797
      #24 0x081a0df8 in st_select_lex_unit::print (this=0x9785810, str=0xb6e5f33c, query_type=QT_ORDINARY) at sql_lex.cc:2036
      #25 0x08294550 in execute_sqlcom_select (thd=0x97841a0, all_tables=0x99919d8) at sql_parse.cc:5117
      #26 0x0828b069 in mysql_execute_command (thd=0x97841a0) at sql_parse.cc:2318
      #27 0x08296857 in mysql_parse (thd=0x97841a0,
      inBuf=0x98e0c18 "EXPLAIN EXTENDED\nSELECT `col_int_key`\nFROM (\nSELECT SUBQUERY1_t1 .*\nFROM CC SUBQUERY1_t1 STRAIGHT_JOIN C SUBQUERY1_t2 ON SUBQUERY1_t2 .`col_varchar_key` AND SUBQUERY1_t1 .`col_int_nokey` NOT IN "..., length=242, found_semicolon=0xb6e60228) at sql_parse.cc:6079
      #28 0x08288b11 in dispatch_command (command=COM_QUERY, thd=0x97841a0, packet=0x988f571 "", packet_length=245) at sql_parse.cc:1253
      #29 0x08287d4f in do_command (thd=0x97841a0) at sql_parse.cc:891
      #30 0x08284e96 in handle_one_connection (arg=0x97841a0) at sql_connect.cc:1599
      #31 0x00a08919 in start_thread () from /lib/libpthread.so.0
      #32 0x00951e5e in clone () from /lib/libc.so.6

      Attachments

        Activity

          People

            timour Timour Katchaounov (Inactive)
            philipstoev Philip Stoev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.