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

Assertion `count_partial_match_columns == field_count' failed in subselect_hash_sj_engine::exec

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
    • 10.4(EOL)
    • None
    • None

    Description

      CREATE TABLE t1 ( f1 double(21,4), f2 int(1) NOT NULL);
      INSERT INTO t1 VALUES (20121123.0000,0),(20121123.0000,0);
       
      CREATE TABLE t2 (d1 date);
      INSERT INTO t2 VALUES (NULL),('1900-01-01');
       
      SELECT * FROM t1 WHERE (f1,f2) NOT IN (SELECT TRUNCATE(d1, 4), 'a' <=> NULL FROM t2);
      

      5.5 4932ec871f6e8270fd

      #3  <signal handler called>
      #4  0x00007fa01cea9428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
      #5  0x00007fa01ceab02a in __GI_abort () at abort.c:89
      #6  0x00007fa01cea1bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0xe28b78 "count_partial_match_columns == field_count", file=file@entry=0xe27d28 "/5.5/sql/item_subselect.cc", line=line@entry=4937, function=function@entry=0xe2a300 <subselect_hash_sj_engine::exec()::__PRETTY_FUNCTION__> "virtual int subselect_hash_sj_engine::exec()") at assert.c:92
      #7  0x00007fa01cea1c82 in __GI___assert_fail (assertion=0xe28b78 "count_partial_match_columns == field_count", file=0xe27d28 "/5.5/sql/item_subselect.cc", line=4937, function=0xe2a300 <subselect_hash_sj_engine::exec()::__PRETTY_FUNCTION__> "virtual int subselect_hash_sj_engine::exec()") at assert.c:101
      #8  0x000000000087f0fb in subselect_hash_sj_engine::exec (this=0x7fa017d40ed0) at /5.5/sql/item_subselect.cc:4937
      #9  0x0000000000873bd9 in Item_subselect::exec (this=0x7fa017d49c48) at /5.5/sql/item_subselect.cc:664
      #10 0x00000000008741db in Item_in_subselect::exec (this=0x7fa017d49c48) at /5.5/sql/item_subselect.cc:839
      #11 0x0000000000876a45 in Item_in_subselect::val_bool (this=0x7fa017d49c48) at /5.5/sql/item_subselect.cc:1680
      #12 0x000000000056bf4d in Item::val_bool_result (this=0x7fa017d49c48) at /5.5/sql/item.h:992
      #13 0x000000000080fc1e in Item_in_optimizer::val_int (this=0x7fa017d81738) at /5.5/sql/item_cmpfunc.cc:1826
      #14 0x000000000056bec1 in Item::val_int_result (this=0x7fa017d81738) at /5.5/sql/item.h:988
      #15 0x0000000000800d6f in Item_cache_int::cache_value (this=0x7fa017d43bf0) at /5.5/sql/item.cc:8853
      #16 0x00000000008083c6 in Item_cache_wrapper::cache (this=0x7fa017d43b30) at /5.5/sql/item.cc:7659
      #17 0x00000000007fded8 in Item_cache_wrapper::val_bool (this=0x7fa017d43b30) at /5.5/sql/item.cc:7823
      #18 0x000000000080b5a5 in Item_func_not::val_int (this=0x7fa017d49ef0) at /5.5/sql/item_cmpfunc.cc:347
      #19 0x000000000066da5c in evaluate_join_record (join=0x7fa017d80670, join_tab=0x7fa017d987a0, error=0) at /5.5/sql/sql_select.cc:17281
      #20 0x000000000066d67b in sub_select (join=0x7fa017d80670, join_tab=0x7fa017d987a0, end_of_records=false) at /5.5/sql/sql_select.cc:17186
      #21 0x000000000066cea4 in do_select (join=0x7fa017d80670, fields=0x7fa0197e9b88, table=0x0, procedure=0x0) at /5.5/sql/sql_select.cc:16848
      #22 0x0000000000647f8a in JOIN::exec (this=0x7fa017d80670) at /5.5/sql/sql_select.cc:2914
      #23 0x000000000064886f in mysql_select (thd=0x7fa0197e6060, rref_pointer_array=0x7fa0197e9d10, tables=0x7fa017d482e8, wild_num=1, fields=..., conds=0x7fa017d49ef0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fa017d80650, unit=0x7fa0197e9388, select_lex=0x7fa0197e9a70) at /5.5/sql/sql_select.cc:3135
      #24 0x000000000063e74b in handle_select (thd=0x7fa0197e6060, lex=0x7fa0197e92d8, result=0x7fa017d80650, setup_tables_done_option=0) at /5.5/sql/sql_select.cc:324
      #25 0x000000000061448c in execute_sqlcom_select (thd=0x7fa0197e6060, all_tables=0x7fa017d482e8) at /5.5/sql/sql_parse.cc:4684
      #26 0x000000000060cf46 in mysql_execute_command (thd=0x7fa0197e6060) at /5.5/sql/sql_parse.cc:2222
      #27 0x00000000006173a6 in mysql_parse (thd=0x7fa0197e6060, rawbuf=0x7fa017d48078 "SELECT * FROM t1 WHERE (f1,f2) NOT IN (SELECT TRUNCATE(d1, 4), 'a' <=> NULL FROM t2)", length=84, parser_state=0x7fa01e724660) at /5.5/sql/sql_parse.cc:5929
      #28 0x000000000060a2ee in dispatch_command (command=COM_QUERY, thd=0x7fa0197e6060, packet=0x7fa018af4061 "", packet_length=84) at /5.5/sql/sql_parse.cc:1067
      #29 0x0000000000609453 in do_command (thd=0x7fa0197e6060) at /5.5/sql/sql_parse.cc:793
      #30 0x0000000000720f7e in do_handle_one_connection (thd_arg=0x7fa0197e6060) at /5.5/sql/sql_connect.cc:1268
      #31 0x0000000000720ce7 in handle_one_connection (arg=0x7fa0197e6060) at /5.5/sql/sql_connect.cc:1184
      #32 0x0000000000cc3f5d in pfs_spawn_thread (arg=0x7fa018a9c300) at /5.5/storage/perfschema/pfs.cc:1015
      #33 0x00007fa01dad46ba in start_thread (arg=0x7fa01e725700) at pthread_create.c:333
      #34 0x00007fa01cf7b41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.