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

Assertion `!prebuilt->index->is_primary()' failed in row_search_idx_cond_check

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.4(EOL)
    • 10.4.11
    • Optimizer
    • None

    Description

      --source include/have_innodb.inc
      		 
       
      		 
      CREATE TABLE t1 (ch varchar(1),id int,id2 int) ENGINE=InnoDB;
      		 
      INSERT INTO t1 VALUES ('l',3,2),('e',NULL,NULL),('r',7,3),('h',NULL,2),(NULL,4,4),('c',4,NULL),('k',NULL,NULL),('h',NULL,NULL),('b',9,NULL),('f',6,NULL);
      		 
       
      		 
      CREATE TABLE t2 (pk int NOT NULL , col_date_key date , ch2 varchar(1) , id2 int , PRIMARY KEY (pk), KEY (col_date_key), KEY (ch2), KEY (id2)) ENGINE=InnoDB;
      		 
      INSERT INTO t2 VALUES  (1,'2034-04-21','g',9),(2,'2006-09-08','y',1),(3,NULL,'h',2),(4,'1987-03-02','s',2),(5,'2019-07-02','u',NULL),(6,'2012-12-18','z',1),(7,NULL,'w',4),(8,'2005-03-10','o',8),(9,'1987-02-12','d',4);
      		 
       
      		 
      CREATE TABLE t3 ( id int) ENGINE=InnoDB;
      		 
      INSERT INTO t3 VALUES (6);
      		 
       
      		 
      SELECT 1 FROM t3 
      WHERE EXISTS(SELECT 1 FROM t1 WHERE t3.id IN (
      		 
        SELECT bt1.id FROM (t2 JOIN t1 AS bt1 ON bt1.ch = t2.ch2 and bt1.id = t2.pk) WHERE t2.ch2 <= 'g') 
      OR t1.id2 = t1.id);

      10.4 a0230bc76d78202178f43

      		 
       
      		 
      #4  0x00007f9c1f600428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
      		 
      #5  0x00007f9c1f60202a in __GI_abort () at abort.c:89
      		 
      #6  0x00007f9c1f5f8bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x55c9649735a0 "!prebuilt->index->is_primary()", file=file@entry=0x55c9649724d0 "/10.4/storage/innobase/row/row0sel.cc", line=line@entry=3906, function=function@entry=0x55c9649766c0 <row_search_idx_cond_check(unsigned char*, row_prebuilt_t*, unsigned char const*, unsigned long const*)::__PRETTY_FUNCTION__> "ICP_RESULT row_search_idx_cond_check(byte*, row_prebuilt_t*, const rec_t*, const ulint*)") at assert.c:92
      		 
      #7  0x00007f9c1f5f8c82 in __GI___assert_fail (assertion=0x55c9649735a0 "!prebuilt->index->is_primary()", file=0x55c9649724d0 "/10.4/storage/innobase/row/row0sel.cc", line=3906, function=0x55c9649766c0 <row_search_idx_cond_check(unsigned char*, row_prebuilt_t*, unsigned char const*, unsigned long const*)::__PRETTY_FUNCTION__> "ICP_RESULT row_search_idx_cond_check(byte*, row_prebuilt_t*, const rec_t*, const ulint*)") at assert.c:101
      		 
      #8  0x000055c96431101a in row_search_idx_cond_check (mysql_rec=0x7f9bc8068900 "\375\001", prebuilt=0x7f9bc80727f8, rec=0x7f9c13d4007f "\200", offsets=0x7f9c18378f80) at /10.4/storage/innobase/row/row0sel.cc:3906
      		 
      #9  0x000055c964314a24 in row_search_mvcc (buf=0x7f9bc8068900 "\375\001", mode=PAGE_CUR_G, prebuilt=0x7f9bc80727f8, match_mode=0, direction=0) at /10.4/storage/innobase/row/row0sel.cc:5220
      		 
      #10 0x000055c9641707df in ha_innobase::index_read (this=0x7f9bc8069738, buf=0x7f9bc8068900 "\375\001", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /10.4/storage/innobase/handler/ha_innodb.cc:9337
      		 
      #11 0x000055c964171748 in ha_innobase::index_first (this=0x7f9bc8069738, buf=0x7f9bc8068900 "\375\001") at /10.4/storage/innobase/handler/ha_innodb.cc:9710
      		 
      #12 0x000055c964171920 in ha_innobase::rnd_next (this=0x7f9bc8069738, buf=0x7f9bc8068900 "\375\001") at /10.4/storage/innobase/handler/ha_innodb.cc:9803
      		 
      #13 0x000055c963e01d83 in handler::ha_rnd_next (this=0x7f9bc8069738, buf=0x7f9bc8068900 "\375\001") at /10.4/sql/handler.cc:2834
      		 
      #14 0x000055c963f968ec in rr_sequential (info=0x7f9bc81af090) at /10.4/sql/records.cc:477
      		 
      #15 0x000055c963a14c13 in READ_RECORD::read_record (this=0x7f9bc81af090) at /10.4/sql/records.h:69
      		 
      #16 0x000055c963b3b2be in join_init_read_record (tab=0x7f9bc81aefc8) at /10.4/sql/sql_select.cc:21055
      		 
      #17 0x000055c963c80004 in JOIN_TAB_SCAN::open (this=0x7f9bc81b0a50) at /10.4/sql/sql_join_cache.cc:3349
      		 
      #18 0x000055c963c7e44d in JOIN_CACHE::join_matching_records (this=0x7f9bc81b0920, skip_last=false) at /10.4/sql/sql_join_cache.cc:2252
      		 
      #19 0x000055c963c7df7e in JOIN_CACHE::join_records (this=0x7f9bc81b0920, skip_last=false) at /10.4/sql/sql_join_cache.cc:2088
      		 
      #20 0x000055c963b38b71 in sub_select_cache (join=0x7f9bc81a47c0, join_tab=0x7f9bc81aefc8, end_of_records=true) at /10.4/sql/sql_select.cc:19892
      		 
      #21 0x000055c963b38d7c in sub_select (join=0x7f9bc81a47c0, join_tab=0x7f9bc81aec20, end_of_records=true) at /10.4/sql/sql_select.cc:20063
      		 
      #22 0x000055c963b38546 in do_select (join=0x7f9bc81a47c0, procedure=0x0) at /10.4/sql/sql_select.cc:19654
      		 
      #23 0x000055c963b0e7b3 in JOIN::exec_inner (this=0x7f9bc81a47c0) at /10.4/sql/sql_select.cc:4391
      		 
      #24 0x000055c963b0d960 in JOIN::exec (this=0x7f9bc81a47c0) at /10.4/sql/sql_select.cc:4173
      		 
      #25 0x000055c963ee0e71 in subselect_hash_sj_engine::exec (this=0x7f9bc81aa9c8) at /10.4/sql/item_subselect.cc:5483
      		 
      #26 0x000055c963ed246e in Item_subselect::exec (this=0x7f9bc8017d50) at /10.4/sql/item_subselect.cc:745
      		 
      #27 0x000055c963ed2ac0 in Item_in_subselect::exec (this=0x7f9bc8017d50) at /10.4/sql/item_subselect.cc:925
      		 
      #28 0x000055c963ed596a in Item_in_subselect::val_bool (this=0x7f9bc8017d50) at /10.4/sql/item_subselect.cc:1796
      		 
      #29 0x000055c9639a6b41 in Item::val_bool_result (this=0x7f9bc8017d50) at /10.4/sql/item.h:1521
      		 
      #30 0x000055c963e42f08 in Item_in_optimizer::val_int (this=0x7f9bc81a4e70) at /10.4/sql/item_cmpfunc.cc:1628
      		 
      #31 0x000055c9639a6ab5 in Item::val_int_result (this=0x7f9bc81a4e70) at /10.4/sql/item.h:1517
      		 
      #32 0x000055c963e31ead in Item_cache_int::cache_value (this=0x7f9bc81b16b0) at /10.4/sql/item.cc:9712
      		 
      #33 0x000055c963e3a10c in Item_cache_wrapper::cache (this=0x7f9bc81b15f0) at /10.4/sql/item.cc:8531
      		 
      #34 0x000055c963e2f420 in Item_cache_wrapper::val_bool (this=0x7f9bc81b15f0) at /10.4/sql/item.cc:8717
      		 
      #35 0x000055c963e4f0a3 in Item_cond_or::val_int (this=0x7f9bc81a78c8) at /10.4/sql/item_cmpfunc.cc:5300
      		 
      #36 0x000055c963b39386 in evaluate_join_record (join=0x7f9bc81a4070, join_tab=0x7f9bc81a7178, error=0) at /10.4/sql/sql_select.cc:20209
      		 
      #37 0x000055c963b38fb0 in sub_select (join=0x7f9bc81a4070, join_tab=0x7f9bc81a7178, end_of_records=false) at /10.4/sql/sql_select.cc:20114
      		 
      #38 0x000055c963b384e0 in do_select (join=0x7f9bc81a4070, procedure=0x0) at /10.4/sql/sql_select.cc:19652
      		 
      #39 0x000055c963b0e7b3 in JOIN::exec_inner (this=0x7f9bc81a4070) at /10.4/sql/sql_select.cc:4391
      		 
      #40 0x000055c963b0d960 in JOIN::exec (this=0x7f9bc81a4070) at /10.4/sql/sql_select.cc:4173
      		 
      #41 0x000055c963eddd0a in subselect_single_select_engine::exec (this=0x7f9bc8018ed0) at /10.4/sql/item_subselect.cc:3927
      		 
      #42 0x000055c963ed246e in Item_subselect::exec (this=0x7f9bc8018d30) at /10.4/sql/item_subselect.cc:745
      		 
      #43 0x000055c963ed5488 in Item_exists_subselect::val_int (this=0x7f9bc8018d30) at /10.4/sql/item_subselect.cc:1644
      		 
      #44 0x000055c963e42c73 in Item_in_optimizer::val_int (this=0x7f9bc81a5190) at /10.4/sql/item_cmpfunc.cc:1546
      		 
      #45 0x000055c963b0e1e3 in JOIN::exec_inner (this=0x7f9bc81a38f8) at /10.4/sql/sql_select.cc:4287
      		 
      #46 0x000055c963b0d960 in JOIN::exec (this=0x7f9bc81a38f8) at /10.4/sql/sql_select.cc:4173
      		 
      #47 0x000055c963b0f005 in mysql_select (thd=0x7f9bc8000b00, tables=0x7f9bc8013820, wild_num=0, fields=..., conds=0x7f9bc8018d30, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f9bc8019020, unit=0x7f9bc8004a30, select_lex=0x7f9bc80132d8) at /10.4/sql/sql_select.cc:4605
      		 
      #48 0x000055c963aff5ce in handle_select (thd=0x7f9bc8000b00, lex=0x7f9bc8004968, result=0x7f9bc8019020, setup_tables_done_option=0) at /10.4/sql/sql_select.cc:425
      		 
      #49 0x000055c963ac8f0a in execute_sqlcom_select (thd=0x7f9bc8000b00, all_tables=0x7f9bc8013820) at /10.4/sql/sql_parse.cc:6340
      		 
      #50 0x000055c963abed58 in mysql_execute_command (thd=0x7f9bc8000b00) at /10.4/sql/sql_parse.cc:3882
      		 
      #51 0x000055c963accce2 in mysql_parse (thd=0x7f9bc8000b00, rawbuf=0x7f9bc8013108 "SELECT 1 FROM t3\nWHERE EXISTS(SELECT 1 FROM t1 WHERE id IN (\nSELECT bt1.id FROM (t2 JOIN t1 AS bt1 ON bt1.ch = t2.ch2 and bt1.id = t2.pk) WHERE t2.ch2 <= 'g') \nOR t1.id2 = t1.id)", length=178, parser_state=0x7f9c1837c000, is_com_multi=false, is_next_command=false) at /10.4/sql/sql_parse.cc:7892
      		 
      #52 0x000055c963ab8f51 in dispatch_command (command=COM_QUERY, thd=0x7f9bc8000b00, packet=0x7f9bc819dca1 "SELECT 1 FROM t3\nWHERE EXISTS(SELECT 1 FROM t1 WHERE id IN (\nSELECT bt1.id FROM (t2 JOIN t1 AS bt1 ON bt1.ch = t2.ch2 and bt1.id = t2.pk) WHERE t2.ch2 <= 'g') \nOR t1.id2 = t1.id)", packet_length=178, is_com_multi=false, is_next_command=false) at /10.4/sql/sql_parse.cc:1827
      		 
      #53 0x000055c963ab76e3 in do_command (thd=0x7f9bc8000b00) at /10.4/sql/sql_parse.cc:1360
      		 
      #54 0x000055c963c31994 in do_handle_one_connection (connect=0x55c9674bb080) at /10.4/sql/sql_connect.cc:1404
      		 
      #55 0x000055c963c316bd in handle_one_connection (arg=0x55c9674bb080) at /10.4/sql/sql_connect.cc:1306
      		 
      #56 0x000055c96455d015 in pfs_spawn_thread (arg=0x55c967439830) at /10.4/storage/perfschema/pfs.cc:1862
      		 
      #57 0x00007f9c204416ba in start_thread (arg=0x7f9c1837d700) at pthread_create.c:333
      		 
      #58 0x00007f9c1f6d241d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20252 Specific SQL query consistently crashes MariaDB

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20851 optimizer_switch 'mrr=on' causes failing queries

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21040 InnoDB: fulltext search with ` in(...)` crashed on specific combination

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19919 Assertion `!prebuilt->index->is_primary()' failed in row_search_idx_cond_check

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21356 ERROR 1032 Can't find record when running simple, single-table query

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-16188 Use in-memory PK filters built from range index scans

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19361 Assertion `marked_for_read()' failed in Field_long::val_int

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19820 Wrong result with multiple single column index request

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21446 Assertion `!prebuilt->index->is_primary()' failed in row_search_idx_cond_check with rowid_filter upon concurrent access to table

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            alice Alice Sherepa created issue -
            alice Alice Sherepa made changes -
            Field Original Value New Value
            Key MENT-277 MDEV-20056
            Affects Version/s 10.4 [ 22408 ]
            Affects Version/s 10.4 [ 23604 ]
            Project MariaDB Enterprise [ 11500 ] MariaDB Server [ 10000 ]
            alice Alice Sherepa made changes -
            Fix Version/s 10.4 [ 22408 ]
            alice Alice Sherepa made changes -
            Description
            {noformat}
            Version: '10.4.7-MariaDB-debug' socket: '/dt/my.sock' port: 3363 Source distribution
            mysqld: /src/storage/innobase/row/row0sel.cc:3906: ICP_RESULT row_search_idx_cond_check(byte*, row_prebuilt_t*, const rec_t*, const ulint*): Assertion `!prebuilt->index->is_primary()' failed.
            190712 16:06:28 [ERROR] mysqld got signal 6 ;

            linux/raise.c:54(__GI_raise)[0x7f66fb96c428]
            stdlib/abort.c:91(__GI_abort)[0x7f66fb96e02a]
            assert/assert.c:92(__assert_fail_base)[0x7f66fb964bd7]
            /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f66fb964c82]
            row/row0sel.cc:3907(row_search_idx_cond_check(unsigned char*, row_prebuilt_t*, unsigned char const*, unsigned long const*))[0x55f6ae91101a]
            row/row0sel.cc:5220(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long))[0x55f6ae914a24]
            handler/ha_innodb.cc:9337(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x55f6ae7707df]
            handler/ha_innodb.cc:9710(ha_innobase::index_first(unsigned char*))[0x55f6ae771748]
            handler/ha_innodb.cc:9803(ha_innobase::rnd_next(unsigned char*))[0x55f6ae771920]
            sql/handler.cc:2834(handler::ha_rnd_next(unsigned char*))[0x55f6ae401dd5]
            sql/records.cc:477(rr_sequential(READ_RECORD*))[0x55f6ae5968ec]
            sql/records.h:69(READ_RECORD::read_record())[0x55f6ae014c13]
            sql/sql_select.cc:21056(join_init_read_record(st_join_table*))[0x55f6ae13b2be]
            sql/sql_join_cache.cc:3350(JOIN_TAB_SCAN::open())[0x55f6ae280004]
            sql/sql_join_cache.cc:2252(JOIN_CACHE::join_matching_records(bool))[0x55f6ae27e44d]
            sql/sql_join_cache.cc:2088(JOIN_CACHE::join_records(bool))[0x55f6ae27df7e]
            sql/sql_join_cache.cc:2134(JOIN_CACHE::join_records(bool))[0x55f6ae27e115]
            sql/sql_select.cc:19892(sub_select_cache(JOIN*, st_join_table*, bool))[0x55f6ae138b71]
            sql/sql_select.cc:20063(sub_select(JOIN*, st_join_table*, bool))[0x55f6ae138d7c]
            sql/sql_select.cc:19654(do_select(JOIN*, Procedure*))[0x55f6ae138546]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x55f6ae10e7b3]
            sql/sql_select.cc:4174(JOIN::exec())[0x55f6ae10d960]
            sql/item_subselect.cc:5484(subselect_hash_sj_engine::exec())[0x55f6ae4e0e71]
            sql/item_subselect.cc:745(Item_subselect::exec())[0x55f6ae4d246e]
            sql/item_subselect.cc:925(Item_in_subselect::exec())[0x55f6ae4d2ac0]
            sql/item_subselect.cc:1796(Item_in_subselect::val_bool())[0x55f6ae4d596a]
            sql/item.h:1521(Item::val_bool_result())[0x55f6adfa6ab5]
            sql/item_cmpfunc.cc:1628(Item_in_optimizer::val_int())[0x55f6ae431ead]
            sql/item.h:1517(Item::val_int_result())[0x55f6ae43a10c]
            sql/item.cc:9712(Item_cache_int::cache_value())[0x55f6ae42f420]
            sql/item.cc:8532(Item_cache_wrapper::cache())[0x55f6ae44f0a3]
            sql/item.cc:8718(Item_cache_wrapper::val_bool())[0x55f6ae152a09]
            sql/item_cmpfunc.cc:5300(Item_cond_or::val_int())[0x55f6ae2c8f67]
            sql/item_cmpfunc.h:647(Item_func_trig_cond::val_int())[0x55f6adfa69a2]
            sql/sql_type.cc:4423(Type_handler_int_result::Item_val_bool(Item*) const)[0x55f6ae44ef97]
            sql/item.h:1460(Item::val_bool())[0x55f6ae1cd102]
            sql/item_cmpfunc.cc:5282(Item_cond_and::val_int())[0x55f6ae282f9a]
            sql/opt_range.h:1664(SQL_SELECT::skip_record(THD*))[0x55f6ae27e810]
            sql/sql_join_cache.cc:2482(JOIN_CACHE::check_match(unsigned char*))[0x55f6ae27ebc5]
            sql/sql_join_cache.cc:2393(JOIN_CACHE::generate_full_extensions(unsigned char*))[0x55f6ae27e0d9]
            sql/sql_join_cache.cc:2549(JOIN_CACHE::join_null_complements(bool))[0x55f6ae27e115]
            sql/sql_join_cache.cc:2122(JOIN_CACHE::join_records(bool))[0x55f6ae138b71]
            sql/sql_join_cache.cc:2134(JOIN_CACHE::join_records(bool))[0x55f6ae138d7c]
            sql/sql_select.cc:19892(sub_select_cache(JOIN*, st_join_table*, bool))[0x55f6ae138546]
            sql/sql_select.cc:20063(sub_select(JOIN*, st_join_table*, bool))[0x55f6ae10e7b3]
            sql/sql_select.cc:19654(do_select(JOIN*, Procedure*))[0x55f6ae10d960]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x55f6ae4ddd0a]
            sql/sql_select.cc:4174(JOIN::exec())[0x55f6ae4d246e]
            sql/item_subselect.cc:3930(subselect_single_select_engine::exec())[0x55f6ae4d5488]
            sql/item_subselect.cc:745(Item_subselect::exec())[0x55f6adfa6ab5]
            sql/item_subselect.cc:1644(Item_exists_subselect::val_int())[0x55f6ae431ead]
            sql/item.h:1517(Item::val_int_result())[0x55f6ae43a10c]
            sql/item.cc:9712(Item_cache_int::cache_value())[0x55f6ae42ecac]
            sql/item.cc:8532(Item_cache_wrapper::cache())[0x55f6ae442c73]
            sql/item.cc:8586(Item_cache_wrapper::val_int())[0x55f6ae139386]
            sql/item_cmpfunc.cc:1546(Item_in_optimizer::val_int())[0x55f6ae138fb0]
            sql/sql_select.cc:20209(evaluate_join_record(JOIN*, st_join_table*, int))[0x55f6ae1384e0]
            sql/sql_select.cc:20114(sub_select(JOIN*, st_join_table*, bool))[0x55f6ae10e7b3]
            sql/sql_select.cc:19652(do_select(JOIN*, Procedure*))[0x55f6ae10d960]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x55f6ae10f005]
            sql/sql_select.cc:4174(JOIN::exec())[0x55f6ae0ff5ce]
            sql/sql_select.cc:4607(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55f6ae0c8f0a]
            sql/sql_select.cc:425(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55f6ae0bed58]
            sql/sql_parse.cc:6340(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55f6ae0ccce2]
            sql/sql_parse.cc:3882(mysql_execute_command(THD*))[0x55f6ae0b8f51]
            sql/sql_parse.cc:7892(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55f6ae0b76e3]
            sql/sql_parse.cc:1829(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55f6ae231994]
            sql/sql_parse.cc:1360(do_command(THD*))[0x55f6ae2316bd]
            /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f66fc7ad6ba]
            x86_64/clone.S:111(clone)[0x7f66fba3e41d]
            {noformat}             		{code:sql}
            --source include/have_innodb.inc

            CREATE TABLE t1 (ch varchar(1),id int,id2 int) ENGINE=InnoDB;
            INSERT INTO t1 VALUES ('l',3,2),('e',NULL,NULL),('r',7,3),('h',NULL,2),(NULL,4,4),('c',4,NULL),('k',NULL,NULL),('h',NULL,NULL),('b',9,NULL),('f',6,NULL);

            CREATE TABLE t2 (pk int NOT NULL , col_date_key date , ch2 varchar(1) , id2 int , PRIMARY KEY (pk), KEY (col_date_key), KEY (ch2), KEY (id2)) ENGINE=InnoDB;
            INSERT INTO t2 VALUES (1,'2034-04-21','g',9),(2,'2006-09-08','y',1),(3,NULL,'h',2),(4,'1987-03-02','s',2),(5,'2019-07-02','u',NULL),(6,'2012-12-18','z',1),(7,NULL,'w',4),(8,'2005-03-10','o',8),(9,'1987-02-12','d',4);

            CREATE TABLE t3 ( id int) ENGINE=InnoDB;
            INSERT INTO t3 VALUES (6);

            SELECT 1 FROM t3
            WHERE EXISTS(SELECT 1 FROM t1 WHERE t3.id IN (
              SELECT bt1.id FROM (t2 JOIN t1 AS bt1 ON bt1.ch = t2.ch2 and bt1.id = t2.pk) WHERE t2.ch2 <= 'g')
            OR t1.id2 = t1.id);
            {code}
            {noformat:title=10.4 }
            Version: '10.4.7-MariaDB-debug' socket: '/dt/my.sock' port: 3363 Source distribution
            mysqld: /src/storage/innobase/row/row0sel.cc:3906: ICP_RESULT row_search_idx_cond_check(byte*, row_prebuilt_t*, const rec_t*, const ulint*): Assertion `!prebuilt->index->is_primary()' failed.
            190712 16:06:28 [ERROR] mysqld got signal 6 ;

            linux/raise.c:54(__GI_raise)[0x7f66fb96c428]
            stdlib/abort.c:91(__GI_abort)[0x7f66fb96e02a]
            assert/assert.c:92(__assert_fail_base)[0x7f66fb964bd7]
            /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f66fb964c82]
            row/row0sel.cc:3907(row_search_idx_cond_check(unsigned char*, row_prebuilt_t*, unsigned char const*, unsigned long const*))[0x55f6ae91101a]
            row/row0sel.cc:5220(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long))[0x55f6ae914a24]
            handler/ha_innodb.cc:9337(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x55f6ae7707df]
            handler/ha_innodb.cc:9710(ha_innobase::index_first(unsigned char*))[0x55f6ae771748]
            handler/ha_innodb.cc:9803(ha_innobase::rnd_next(unsigned char*))[0x55f6ae771920]
            sql/handler.cc:2834(handler::ha_rnd_next(unsigned char*))[0x55f6ae401dd5]
            sql/records.cc:477(rr_sequential(READ_RECORD*))[0x55f6ae5968ec]
            sql/records.h:69(READ_RECORD::read_record())[0x55f6ae014c13]
            sql/sql_select.cc:21056(join_init_read_record(st_join_table*))[0x55f6ae13b2be]
            sql/sql_join_cache.cc:3350(JOIN_TAB_SCAN::open())[0x55f6ae280004]
            sql/sql_join_cache.cc:2252(JOIN_CACHE::join_matching_records(bool))[0x55f6ae27e44d]
            sql/sql_join_cache.cc:2088(JOIN_CACHE::join_records(bool))[0x55f6ae27df7e]
            sql/sql_join_cache.cc:2134(JOIN_CACHE::join_records(bool))[0x55f6ae27e115]
            sql/sql_select.cc:19892(sub_select_cache(JOIN*, st_join_table*, bool))[0x55f6ae138b71]
            sql/sql_select.cc:20063(sub_select(JOIN*, st_join_table*, bool))[0x55f6ae138d7c]
            sql/sql_select.cc:19654(do_select(JOIN*, Procedure*))[0x55f6ae138546]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x55f6ae10e7b3]
            sql/sql_select.cc:4174(JOIN::exec())[0x55f6ae10d960]
            sql/item_subselect.cc:5484(subselect_hash_sj_engine::exec())[0x55f6ae4e0e71]
            sql/item_subselect.cc:745(Item_subselect::exec())[0x55f6ae4d246e]
            sql/item_subselect.cc:925(Item_in_subselect::exec())[0x55f6ae4d2ac0]
            sql/item_subselect.cc:1796(Item_in_subselect::val_bool())[0x55f6ae4d596a]
            sql/item.h:1521(Item::val_bool_result())[0x55f6adfa6ab5]
            sql/item_cmpfunc.cc:1628(Item_in_optimizer::val_int())[0x55f6ae431ead]
            sql/item.h:1517(Item::val_int_result())[0x55f6ae43a10c]
            sql/item.cc:9712(Item_cache_int::cache_value())[0x55f6ae42f420]
            sql/item.cc:8532(Item_cache_wrapper::cache())[0x55f6ae44f0a3]
            sql/item.cc:8718(Item_cache_wrapper::val_bool())[0x55f6ae152a09]
            sql/item_cmpfunc.cc:5300(Item_cond_or::val_int())[0x55f6ae2c8f67]
            sql/item_cmpfunc.h:647(Item_func_trig_cond::val_int())[0x55f6adfa69a2]
            sql/sql_type.cc:4423(Type_handler_int_result::Item_val_bool(Item*) const)[0x55f6ae44ef97]
            sql/item.h:1460(Item::val_bool())[0x55f6ae1cd102]
            sql/item_cmpfunc.cc:5282(Item_cond_and::val_int())[0x55f6ae282f9a]
            sql/opt_range.h:1664(SQL_SELECT::skip_record(THD*))[0x55f6ae27e810]
            sql/sql_join_cache.cc:2482(JOIN_CACHE::check_match(unsigned char*))[0x55f6ae27ebc5]
            sql/sql_join_cache.cc:2393(JOIN_CACHE::generate_full_extensions(unsigned char*))[0x55f6ae27e0d9]
            sql/sql_join_cache.cc:2549(JOIN_CACHE::join_null_complements(bool))[0x55f6ae27e115]
            sql/sql_join_cache.cc:2122(JOIN_CACHE::join_records(bool))[0x55f6ae138b71]
            sql/sql_join_cache.cc:2134(JOIN_CACHE::join_records(bool))[0x55f6ae138d7c]
            sql/sql_select.cc:19892(sub_select_cache(JOIN*, st_join_table*, bool))[0x55f6ae138546]
            sql/sql_select.cc:20063(sub_select(JOIN*, st_join_table*, bool))[0x55f6ae10e7b3]
            sql/sql_select.cc:19654(do_select(JOIN*, Procedure*))[0x55f6ae10d960]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x55f6ae4ddd0a]
            sql/sql_select.cc:4174(JOIN::exec())[0x55f6ae4d246e]
            sql/item_subselect.cc:3930(subselect_single_select_engine::exec())[0x55f6ae4d5488]
            sql/item_subselect.cc:745(Item_subselect::exec())[0x55f6adfa6ab5]
            sql/item_subselect.cc:1644(Item_exists_subselect::val_int())[0x55f6ae431ead]
            sql/item.h:1517(Item::val_int_result())[0x55f6ae43a10c]
            sql/item.cc:9712(Item_cache_int::cache_value())[0x55f6ae42ecac]
            sql/item.cc:8532(Item_cache_wrapper::cache())[0x55f6ae442c73]
            sql/item.cc:8586(Item_cache_wrapper::val_int())[0x55f6ae139386]
            sql/item_cmpfunc.cc:1546(Item_in_optimizer::val_int())[0x55f6ae138fb0]
            sql/sql_select.cc:20209(evaluate_join_record(JOIN*, st_join_table*, int))[0x55f6ae1384e0]
            sql/sql_select.cc:20114(sub_select(JOIN*, st_join_table*, bool))[0x55f6ae10e7b3]
            sql/sql_select.cc:19652(do_select(JOIN*, Procedure*))[0x55f6ae10d960]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x55f6ae10f005]
            sql/sql_select.cc:4174(JOIN::exec())[0x55f6ae0ff5ce]
            sql/sql_select.cc:4607(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55f6ae0c8f0a]
            sql/sql_select.cc:425(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55f6ae0bed58]
            sql/sql_parse.cc:6340(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55f6ae0ccce2]
            sql/sql_parse.cc:3882(mysql_execute_command(THD*))[0x55f6ae0b8f51]
            sql/sql_parse.cc:7892(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55f6ae0b76e3]
            sql/sql_parse.cc:1829(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55f6ae231994]
            sql/sql_parse.cc:1360(do_command(THD*))[0x55f6ae2316bd]
            /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f66fc7ad6ba]
            x86_64/clone.S:111(clone)[0x7f66fba3e41d]
            {noformat}
            alice Alice Sherepa made changes -
            Description {code:sql}
            --source include/have_innodb.inc

            CREATE TABLE t1 (ch varchar(1),id int,id2 int) ENGINE=InnoDB;
            INSERT INTO t1 VALUES ('l',3,2),('e',NULL,NULL),('r',7,3),('h',NULL,2),(NULL,4,4),('c',4,NULL),('k',NULL,NULL),('h',NULL,NULL),('b',9,NULL),('f',6,NULL);

            CREATE TABLE t2 (pk int NOT NULL , col_date_key date , ch2 varchar(1) , id2 int , PRIMARY KEY (pk), KEY (col_date_key), KEY (ch2), KEY (id2)) ENGINE=InnoDB;
            INSERT INTO t2 VALUES (1,'2034-04-21','g',9),(2,'2006-09-08','y',1),(3,NULL,'h',2),(4,'1987-03-02','s',2),(5,'2019-07-02','u',NULL),(6,'2012-12-18','z',1),(7,NULL,'w',4),(8,'2005-03-10','o',8),(9,'1987-02-12','d',4);

            CREATE TABLE t3 ( id int) ENGINE=InnoDB;
            INSERT INTO t3 VALUES (6);

            SELECT 1 FROM t3
            WHERE EXISTS(SELECT 1 FROM t1 WHERE t3.id IN (
              SELECT bt1.id FROM (t2 JOIN t1 AS bt1 ON bt1.ch = t2.ch2 and bt1.id = t2.pk) WHERE t2.ch2 <= 'g')
            OR t1.id2 = t1.id);
            {code}
            {noformat:title=10.4 }
            Version: '10.4.7-MariaDB-debug' socket: '/dt/my.sock' port: 3363 Source distribution
            mysqld: /src/storage/innobase/row/row0sel.cc:3906: ICP_RESULT row_search_idx_cond_check(byte*, row_prebuilt_t*, const rec_t*, const ulint*): Assertion `!prebuilt->index->is_primary()' failed.
            190712 16:06:28 [ERROR] mysqld got signal 6 ;

            linux/raise.c:54(__GI_raise)[0x7f66fb96c428]
            stdlib/abort.c:91(__GI_abort)[0x7f66fb96e02a]
            assert/assert.c:92(__assert_fail_base)[0x7f66fb964bd7]
            /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f66fb964c82]
            row/row0sel.cc:3907(row_search_idx_cond_check(unsigned char*, row_prebuilt_t*, unsigned char const*, unsigned long const*))[0x55f6ae91101a]
            row/row0sel.cc:5220(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long))[0x55f6ae914a24]
            handler/ha_innodb.cc:9337(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x55f6ae7707df]
            handler/ha_innodb.cc:9710(ha_innobase::index_first(unsigned char*))[0x55f6ae771748]
            handler/ha_innodb.cc:9803(ha_innobase::rnd_next(unsigned char*))[0x55f6ae771920]
            sql/handler.cc:2834(handler::ha_rnd_next(unsigned char*))[0x55f6ae401dd5]
            sql/records.cc:477(rr_sequential(READ_RECORD*))[0x55f6ae5968ec]
            sql/records.h:69(READ_RECORD::read_record())[0x55f6ae014c13]
            sql/sql_select.cc:21056(join_init_read_record(st_join_table*))[0x55f6ae13b2be]
            sql/sql_join_cache.cc:3350(JOIN_TAB_SCAN::open())[0x55f6ae280004]
            sql/sql_join_cache.cc:2252(JOIN_CACHE::join_matching_records(bool))[0x55f6ae27e44d]
            sql/sql_join_cache.cc:2088(JOIN_CACHE::join_records(bool))[0x55f6ae27df7e]
            sql/sql_join_cache.cc:2134(JOIN_CACHE::join_records(bool))[0x55f6ae27e115]
            sql/sql_select.cc:19892(sub_select_cache(JOIN*, st_join_table*, bool))[0x55f6ae138b71]
            sql/sql_select.cc:20063(sub_select(JOIN*, st_join_table*, bool))[0x55f6ae138d7c]
            sql/sql_select.cc:19654(do_select(JOIN*, Procedure*))[0x55f6ae138546]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x55f6ae10e7b3]
            sql/sql_select.cc:4174(JOIN::exec())[0x55f6ae10d960]
            sql/item_subselect.cc:5484(subselect_hash_sj_engine::exec())[0x55f6ae4e0e71]
            sql/item_subselect.cc:745(Item_subselect::exec())[0x55f6ae4d246e]
            sql/item_subselect.cc:925(Item_in_subselect::exec())[0x55f6ae4d2ac0]
            sql/item_subselect.cc:1796(Item_in_subselect::val_bool())[0x55f6ae4d596a]
            sql/item.h:1521(Item::val_bool_result())[0x55f6adfa6ab5]
            sql/item_cmpfunc.cc:1628(Item_in_optimizer::val_int())[0x55f6ae431ead]
            sql/item.h:1517(Item::val_int_result())[0x55f6ae43a10c]
            sql/item.cc:9712(Item_cache_int::cache_value())[0x55f6ae42f420]
            sql/item.cc:8532(Item_cache_wrapper::cache())[0x55f6ae44f0a3]
            sql/item.cc:8718(Item_cache_wrapper::val_bool())[0x55f6ae152a09]
            sql/item_cmpfunc.cc:5300(Item_cond_or::val_int())[0x55f6ae2c8f67]
            sql/item_cmpfunc.h:647(Item_func_trig_cond::val_int())[0x55f6adfa69a2]
            sql/sql_type.cc:4423(Type_handler_int_result::Item_val_bool(Item*) const)[0x55f6ae44ef97]
            sql/item.h:1460(Item::val_bool())[0x55f6ae1cd102]
            sql/item_cmpfunc.cc:5282(Item_cond_and::val_int())[0x55f6ae282f9a]
            sql/opt_range.h:1664(SQL_SELECT::skip_record(THD*))[0x55f6ae27e810]
            sql/sql_join_cache.cc:2482(JOIN_CACHE::check_match(unsigned char*))[0x55f6ae27ebc5]
            sql/sql_join_cache.cc:2393(JOIN_CACHE::generate_full_extensions(unsigned char*))[0x55f6ae27e0d9]
            sql/sql_join_cache.cc:2549(JOIN_CACHE::join_null_complements(bool))[0x55f6ae27e115]
            sql/sql_join_cache.cc:2122(JOIN_CACHE::join_records(bool))[0x55f6ae138b71]
            sql/sql_join_cache.cc:2134(JOIN_CACHE::join_records(bool))[0x55f6ae138d7c]
            sql/sql_select.cc:19892(sub_select_cache(JOIN*, st_join_table*, bool))[0x55f6ae138546]
            sql/sql_select.cc:20063(sub_select(JOIN*, st_join_table*, bool))[0x55f6ae10e7b3]
            sql/sql_select.cc:19654(do_select(JOIN*, Procedure*))[0x55f6ae10d960]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x55f6ae4ddd0a]
            sql/sql_select.cc:4174(JOIN::exec())[0x55f6ae4d246e]
            sql/item_subselect.cc:3930(subselect_single_select_engine::exec())[0x55f6ae4d5488]
            sql/item_subselect.cc:745(Item_subselect::exec())[0x55f6adfa6ab5]
            sql/item_subselect.cc:1644(Item_exists_subselect::val_int())[0x55f6ae431ead]
            sql/item.h:1517(Item::val_int_result())[0x55f6ae43a10c]
            sql/item.cc:9712(Item_cache_int::cache_value())[0x55f6ae42ecac]
            sql/item.cc:8532(Item_cache_wrapper::cache())[0x55f6ae442c73]
            sql/item.cc:8586(Item_cache_wrapper::val_int())[0x55f6ae139386]
            sql/item_cmpfunc.cc:1546(Item_in_optimizer::val_int())[0x55f6ae138fb0]
            sql/sql_select.cc:20209(evaluate_join_record(JOIN*, st_join_table*, int))[0x55f6ae1384e0]
            sql/sql_select.cc:20114(sub_select(JOIN*, st_join_table*, bool))[0x55f6ae10e7b3]
            sql/sql_select.cc:19652(do_select(JOIN*, Procedure*))[0x55f6ae10d960]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x55f6ae10f005]
            sql/sql_select.cc:4174(JOIN::exec())[0x55f6ae0ff5ce]
            sql/sql_select.cc:4607(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55f6ae0c8f0a]
            sql/sql_select.cc:425(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55f6ae0bed58]
            sql/sql_parse.cc:6340(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55f6ae0ccce2]
            sql/sql_parse.cc:3882(mysql_execute_command(THD*))[0x55f6ae0b8f51]
            sql/sql_parse.cc:7892(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55f6ae0b76e3]
            sql/sql_parse.cc:1829(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55f6ae231994]
            sql/sql_parse.cc:1360(do_command(THD*))[0x55f6ae2316bd]
            /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f66fc7ad6ba]
            x86_64/clone.S:111(clone)[0x7f66fba3e41d]
            {noformat}             		{code:sql}
            --source include/have_innodb.inc

            CREATE TABLE t1 (ch varchar(1),id int,id2 int) ENGINE=InnoDB;
            INSERT INTO t1 VALUES ('l',3,2),('e',NULL,NULL),('r',7,3),('h',NULL,2),(NULL,4,4),('c',4,NULL),('k',NULL,NULL),('h',NULL,NULL),('b',9,NULL),('f',6,NULL);

            CREATE TABLE t2 (pk int NOT NULL , col_date_key date , ch2 varchar(1) , id2 int , PRIMARY KEY (pk), KEY (col_date_key), KEY (ch2), KEY (id2)) ENGINE=InnoDB;
            INSERT INTO t2 VALUES (1,'2034-04-21','g',9),(2,'2006-09-08','y',1),(3,NULL,'h',2),(4,'1987-03-02','s',2),(5,'2019-07-02','u',NULL),(6,'2012-12-18','z',1),(7,NULL,'w',4),(8,'2005-03-10','o',8),(9,'1987-02-12','d',4);

            CREATE TABLE t3 ( id int) ENGINE=InnoDB;
            INSERT INTO t3 VALUES (6);

            SELECT 1 FROM t3
            WHERE EXISTS(SELECT 1 FROM t1 WHERE t3.id IN (
              SELECT bt1.id FROM (t2 JOIN t1 AS bt1 ON bt1.ch = t2.ch2 and bt1.id = t2.pk) WHERE t2.ch2 <= 'g')
            OR t1.id2 = t1.id);
            {code}
            {noformat:title=10.4 a0230bc76d78202178f43}
            Version: '10.4.7-MariaDB-debug' socket: '/dt/my.sock' port: 3363 Source distribution
            mysqld: /src/storage/innobase/row/row0sel.cc:3906: ICP_RESULT row_search_idx_cond_check(byte*, row_prebuilt_t*, const rec_t*, const ulint*): Assertion `!prebuilt->index->is_primary()' failed.
            190712 16:06:28 [ERROR] mysqld got signal 6 ;

            linux/raise.c:54(__GI_raise)[0x7f66fb96c428]
            stdlib/abort.c:91(__GI_abort)[0x7f66fb96e02a]
            assert/assert.c:92(__assert_fail_base)[0x7f66fb964bd7]
            /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f66fb964c82]
            row/row0sel.cc:3907(row_search_idx_cond_check(unsigned char*, row_prebuilt_t*, unsigned char const*, unsigned long const*))[0x55f6ae91101a]
            row/row0sel.cc:5220(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long))[0x55f6ae914a24]
            handler/ha_innodb.cc:9337(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x55f6ae7707df]
            handler/ha_innodb.cc:9710(ha_innobase::index_first(unsigned char*))[0x55f6ae771748]
            handler/ha_innodb.cc:9803(ha_innobase::rnd_next(unsigned char*))[0x55f6ae771920]
            sql/handler.cc:2834(handler::ha_rnd_next(unsigned char*))[0x55f6ae401dd5]
            sql/records.cc:477(rr_sequential(READ_RECORD*))[0x55f6ae5968ec]
            sql/records.h:69(READ_RECORD::read_record())[0x55f6ae014c13]
            sql/sql_select.cc:21056(join_init_read_record(st_join_table*))[0x55f6ae13b2be]
            sql/sql_join_cache.cc:3350(JOIN_TAB_SCAN::open())[0x55f6ae280004]
            sql/sql_join_cache.cc:2252(JOIN_CACHE::join_matching_records(bool))[0x55f6ae27e44d]
            sql/sql_join_cache.cc:2088(JOIN_CACHE::join_records(bool))[0x55f6ae27df7e]
            sql/sql_join_cache.cc:2134(JOIN_CACHE::join_records(bool))[0x55f6ae27e115]
            sql/sql_select.cc:19892(sub_select_cache(JOIN*, st_join_table*, bool))[0x55f6ae138b71]
            sql/sql_select.cc:20063(sub_select(JOIN*, st_join_table*, bool))[0x55f6ae138d7c]
            sql/sql_select.cc:19654(do_select(JOIN*, Procedure*))[0x55f6ae138546]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x55f6ae10e7b3]
            sql/sql_select.cc:4174(JOIN::exec())[0x55f6ae10d960]
            sql/item_subselect.cc:5484(subselect_hash_sj_engine::exec())[0x55f6ae4e0e71]
            sql/item_subselect.cc:745(Item_subselect::exec())[0x55f6ae4d246e]
            sql/item_subselect.cc:925(Item_in_subselect::exec())[0x55f6ae4d2ac0]
            sql/item_subselect.cc:1796(Item_in_subselect::val_bool())[0x55f6ae4d596a]
            sql/item.h:1521(Item::val_bool_result())[0x55f6adfa6ab5]
            sql/item_cmpfunc.cc:1628(Item_in_optimizer::val_int())[0x55f6ae431ead]
            sql/item.h:1517(Item::val_int_result())[0x55f6ae43a10c]
            sql/item.cc:9712(Item_cache_int::cache_value())[0x55f6ae42f420]
            sql/item.cc:8532(Item_cache_wrapper::cache())[0x55f6ae44f0a3]
            sql/item.cc:8718(Item_cache_wrapper::val_bool())[0x55f6ae152a09]
            sql/item_cmpfunc.cc:5300(Item_cond_or::val_int())[0x55f6ae2c8f67]
            sql/item_cmpfunc.h:647(Item_func_trig_cond::val_int())[0x55f6adfa69a2]
            sql/sql_type.cc:4423(Type_handler_int_result::Item_val_bool(Item*) const)[0x55f6ae44ef97]
            sql/item.h:1460(Item::val_bool())[0x55f6ae1cd102]
            sql/item_cmpfunc.cc:5282(Item_cond_and::val_int())[0x55f6ae282f9a]
            sql/opt_range.h:1664(SQL_SELECT::skip_record(THD*))[0x55f6ae27e810]
            sql/sql_join_cache.cc:2482(JOIN_CACHE::check_match(unsigned char*))[0x55f6ae27ebc5]
            sql/sql_join_cache.cc:2393(JOIN_CACHE::generate_full_extensions(unsigned char*))[0x55f6ae27e0d9]
            sql/sql_join_cache.cc:2549(JOIN_CACHE::join_null_complements(bool))[0x55f6ae27e115]
            sql/sql_join_cache.cc:2122(JOIN_CACHE::join_records(bool))[0x55f6ae138b71]
            sql/sql_join_cache.cc:2134(JOIN_CACHE::join_records(bool))[0x55f6ae138d7c]
            sql/sql_select.cc:19892(sub_select_cache(JOIN*, st_join_table*, bool))[0x55f6ae138546]
            sql/sql_select.cc:20063(sub_select(JOIN*, st_join_table*, bool))[0x55f6ae10e7b3]
            sql/sql_select.cc:19654(do_select(JOIN*, Procedure*))[0x55f6ae10d960]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x55f6ae4ddd0a]
            sql/sql_select.cc:4174(JOIN::exec())[0x55f6ae4d246e]
            sql/item_subselect.cc:3930(subselect_single_select_engine::exec())[0x55f6ae4d5488]
            sql/item_subselect.cc:745(Item_subselect::exec())[0x55f6adfa6ab5]
            sql/item_subselect.cc:1644(Item_exists_subselect::val_int())[0x55f6ae431ead]
            sql/item.h:1517(Item::val_int_result())[0x55f6ae43a10c]
            sql/item.cc:9712(Item_cache_int::cache_value())[0x55f6ae42ecac]
            sql/item.cc:8532(Item_cache_wrapper::cache())[0x55f6ae442c73]
            sql/item.cc:8586(Item_cache_wrapper::val_int())[0x55f6ae139386]
            sql/item_cmpfunc.cc:1546(Item_in_optimizer::val_int())[0x55f6ae138fb0]
            sql/sql_select.cc:20209(evaluate_join_record(JOIN*, st_join_table*, int))[0x55f6ae1384e0]
            sql/sql_select.cc:20114(sub_select(JOIN*, st_join_table*, bool))[0x55f6ae10e7b3]
            sql/sql_select.cc:19652(do_select(JOIN*, Procedure*))[0x55f6ae10d960]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x55f6ae10f005]
            sql/sql_select.cc:4174(JOIN::exec())[0x55f6ae0ff5ce]
            sql/sql_select.cc:4607(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55f6ae0c8f0a]
            sql/sql_select.cc:425(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55f6ae0bed58]
            sql/sql_parse.cc:6340(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55f6ae0ccce2]
            sql/sql_parse.cc:3882(mysql_execute_command(THD*))[0x55f6ae0b8f51]
            sql/sql_parse.cc:7892(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55f6ae0b76e3]
            sql/sql_parse.cc:1829(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55f6ae231994]
            sql/sql_parse.cc:1360(do_command(THD*))[0x55f6ae2316bd]
            /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f66fc7ad6ba]
            x86_64/clone.S:111(clone)[0x7f66fba3e41d]
            {noformat}
            alice Alice Sherepa made changes -
            Component/s Storage Engine - InnoDB [ 10129 ]
            alice Alice Sherepa made changes -
            Description {code:sql}
            --source include/have_innodb.inc

            CREATE TABLE t1 (ch varchar(1),id int,id2 int) ENGINE=InnoDB;
            INSERT INTO t1 VALUES ('l',3,2),('e',NULL,NULL),('r',7,3),('h',NULL,2),(NULL,4,4),('c',4,NULL),('k',NULL,NULL),('h',NULL,NULL),('b',9,NULL),('f',6,NULL);

            CREATE TABLE t2 (pk int NOT NULL , col_date_key date , ch2 varchar(1) , id2 int , PRIMARY KEY (pk), KEY (col_date_key), KEY (ch2), KEY (id2)) ENGINE=InnoDB;
            INSERT INTO t2 VALUES (1,'2034-04-21','g',9),(2,'2006-09-08','y',1),(3,NULL,'h',2),(4,'1987-03-02','s',2),(5,'2019-07-02','u',NULL),(6,'2012-12-18','z',1),(7,NULL,'w',4),(8,'2005-03-10','o',8),(9,'1987-02-12','d',4);

            CREATE TABLE t3 ( id int) ENGINE=InnoDB;
            INSERT INTO t3 VALUES (6);

            SELECT 1 FROM t3
            WHERE EXISTS(SELECT 1 FROM t1 WHERE t3.id IN (
              SELECT bt1.id FROM (t2 JOIN t1 AS bt1 ON bt1.ch = t2.ch2 and bt1.id = t2.pk) WHERE t2.ch2 <= 'g')
            OR t1.id2 = t1.id);
            {code}
            {noformat:title=10.4 a0230bc76d78202178f43}
            Version: '10.4.7-MariaDB-debug' socket: '/dt/my.sock' port: 3363 Source distribution
            mysqld: /src/storage/innobase/row/row0sel.cc:3906: ICP_RESULT row_search_idx_cond_check(byte*, row_prebuilt_t*, const rec_t*, const ulint*): Assertion `!prebuilt->index->is_primary()' failed.
            190712 16:06:28 [ERROR] mysqld got signal 6 ;

            linux/raise.c:54(__GI_raise)[0x7f66fb96c428]
            stdlib/abort.c:91(__GI_abort)[0x7f66fb96e02a]
            assert/assert.c:92(__assert_fail_base)[0x7f66fb964bd7]
            /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f66fb964c82]
            row/row0sel.cc:3907(row_search_idx_cond_check(unsigned char*, row_prebuilt_t*, unsigned char const*, unsigned long const*))[0x55f6ae91101a]
            row/row0sel.cc:5220(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long))[0x55f6ae914a24]
            handler/ha_innodb.cc:9337(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x55f6ae7707df]
            handler/ha_innodb.cc:9710(ha_innobase::index_first(unsigned char*))[0x55f6ae771748]
            handler/ha_innodb.cc:9803(ha_innobase::rnd_next(unsigned char*))[0x55f6ae771920]
            sql/handler.cc:2834(handler::ha_rnd_next(unsigned char*))[0x55f6ae401dd5]
            sql/records.cc:477(rr_sequential(READ_RECORD*))[0x55f6ae5968ec]
            sql/records.h:69(READ_RECORD::read_record())[0x55f6ae014c13]
            sql/sql_select.cc:21056(join_init_read_record(st_join_table*))[0x55f6ae13b2be]
            sql/sql_join_cache.cc:3350(JOIN_TAB_SCAN::open())[0x55f6ae280004]
            sql/sql_join_cache.cc:2252(JOIN_CACHE::join_matching_records(bool))[0x55f6ae27e44d]
            sql/sql_join_cache.cc:2088(JOIN_CACHE::join_records(bool))[0x55f6ae27df7e]
            sql/sql_join_cache.cc:2134(JOIN_CACHE::join_records(bool))[0x55f6ae27e115]
            sql/sql_select.cc:19892(sub_select_cache(JOIN*, st_join_table*, bool))[0x55f6ae138b71]
            sql/sql_select.cc:20063(sub_select(JOIN*, st_join_table*, bool))[0x55f6ae138d7c]
            sql/sql_select.cc:19654(do_select(JOIN*, Procedure*))[0x55f6ae138546]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x55f6ae10e7b3]
            sql/sql_select.cc:4174(JOIN::exec())[0x55f6ae10d960]
            sql/item_subselect.cc:5484(subselect_hash_sj_engine::exec())[0x55f6ae4e0e71]
            sql/item_subselect.cc:745(Item_subselect::exec())[0x55f6ae4d246e]
            sql/item_subselect.cc:925(Item_in_subselect::exec())[0x55f6ae4d2ac0]
            sql/item_subselect.cc:1796(Item_in_subselect::val_bool())[0x55f6ae4d596a]
            sql/item.h:1521(Item::val_bool_result())[0x55f6adfa6ab5]
            sql/item_cmpfunc.cc:1628(Item_in_optimizer::val_int())[0x55f6ae431ead]
            sql/item.h:1517(Item::val_int_result())[0x55f6ae43a10c]
            sql/item.cc:9712(Item_cache_int::cache_value())[0x55f6ae42f420]
            sql/item.cc:8532(Item_cache_wrapper::cache())[0x55f6ae44f0a3]
            sql/item.cc:8718(Item_cache_wrapper::val_bool())[0x55f6ae152a09]
            sql/item_cmpfunc.cc:5300(Item_cond_or::val_int())[0x55f6ae2c8f67]
            sql/item_cmpfunc.h:647(Item_func_trig_cond::val_int())[0x55f6adfa69a2]
            sql/sql_type.cc:4423(Type_handler_int_result::Item_val_bool(Item*) const)[0x55f6ae44ef97]
            sql/item.h:1460(Item::val_bool())[0x55f6ae1cd102]
            sql/item_cmpfunc.cc:5282(Item_cond_and::val_int())[0x55f6ae282f9a]
            sql/opt_range.h:1664(SQL_SELECT::skip_record(THD*))[0x55f6ae27e810]
            sql/sql_join_cache.cc:2482(JOIN_CACHE::check_match(unsigned char*))[0x55f6ae27ebc5]
            sql/sql_join_cache.cc:2393(JOIN_CACHE::generate_full_extensions(unsigned char*))[0x55f6ae27e0d9]
            sql/sql_join_cache.cc:2549(JOIN_CACHE::join_null_complements(bool))[0x55f6ae27e115]
            sql/sql_join_cache.cc:2122(JOIN_CACHE::join_records(bool))[0x55f6ae138b71]
            sql/sql_join_cache.cc:2134(JOIN_CACHE::join_records(bool))[0x55f6ae138d7c]
            sql/sql_select.cc:19892(sub_select_cache(JOIN*, st_join_table*, bool))[0x55f6ae138546]
            sql/sql_select.cc:20063(sub_select(JOIN*, st_join_table*, bool))[0x55f6ae10e7b3]
            sql/sql_select.cc:19654(do_select(JOIN*, Procedure*))[0x55f6ae10d960]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x55f6ae4ddd0a]
            sql/sql_select.cc:4174(JOIN::exec())[0x55f6ae4d246e]
            sql/item_subselect.cc:3930(subselect_single_select_engine::exec())[0x55f6ae4d5488]
            sql/item_subselect.cc:745(Item_subselect::exec())[0x55f6adfa6ab5]
            sql/item_subselect.cc:1644(Item_exists_subselect::val_int())[0x55f6ae431ead]
            sql/item.h:1517(Item::val_int_result())[0x55f6ae43a10c]
            sql/item.cc:9712(Item_cache_int::cache_value())[0x55f6ae42ecac]
            sql/item.cc:8532(Item_cache_wrapper::cache())[0x55f6ae442c73]
            sql/item.cc:8586(Item_cache_wrapper::val_int())[0x55f6ae139386]
            sql/item_cmpfunc.cc:1546(Item_in_optimizer::val_int())[0x55f6ae138fb0]
            sql/sql_select.cc:20209(evaluate_join_record(JOIN*, st_join_table*, int))[0x55f6ae1384e0]
            sql/sql_select.cc:20114(sub_select(JOIN*, st_join_table*, bool))[0x55f6ae10e7b3]
            sql/sql_select.cc:19652(do_select(JOIN*, Procedure*))[0x55f6ae10d960]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x55f6ae10f005]
            sql/sql_select.cc:4174(JOIN::exec())[0x55f6ae0ff5ce]
            sql/sql_select.cc:4607(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55f6ae0c8f0a]
            sql/sql_select.cc:425(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55f6ae0bed58]
            sql/sql_parse.cc:6340(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55f6ae0ccce2]
            sql/sql_parse.cc:3882(mysql_execute_command(THD*))[0x55f6ae0b8f51]
            sql/sql_parse.cc:7892(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55f6ae0b76e3]
            sql/sql_parse.cc:1829(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55f6ae231994]
            sql/sql_parse.cc:1360(do_command(THD*))[0x55f6ae2316bd]
            /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f66fc7ad6ba]
            x86_64/clone.S:111(clone)[0x7f66fba3e41d]
            {noformat}             		{code:sql}
            --source include/have_innodb.inc

            CREATE TABLE t1 (ch varchar(1),id int,id2 int) ENGINE=InnoDB;
            INSERT INTO t1 VALUES ('l',3,2),('e',NULL,NULL),('r',7,3),('h',NULL,2),(NULL,4,4),('c',4,NULL),('k',NULL,NULL),('h',NULL,NULL),('b',9,NULL),('f',6,NULL);

            CREATE TABLE t2 (pk int NOT NULL , col_date_key date , ch2 varchar(1) , id2 int , PRIMARY KEY (pk), KEY (col_date_key), KEY (ch2), KEY (id2)) ENGINE=InnoDB;
            INSERT INTO t2 VALUES (1,'2034-04-21','g',9),(2,'2006-09-08','y',1),(3,NULL,'h',2),(4,'1987-03-02','s',2),(5,'2019-07-02','u',NULL),(6,'2012-12-18','z',1),(7,NULL,'w',4),(8,'2005-03-10','o',8),(9,'1987-02-12','d',4);

            CREATE TABLE t3 ( id int) ENGINE=InnoDB;
            INSERT INTO t3 VALUES (6);

            SELECT 1 FROM t3
            WHERE EXISTS(SELECT 1 FROM t1 WHERE t3.id IN (
              SELECT bt1.id FROM (t2 JOIN t1 AS bt1 ON bt1.ch = t2.ch2 and bt1.id = t2.pk) WHERE t2.ch2 <= 'g')
            OR t1.id2 = t1.id);
            {code}
            {noformat:title=10.4 a0230bc76d78202178f43}
            mysqld: /src/storage/innobase/row/row0sel.cc:3906: ICP_RESULT row_search_idx_cond_check(byte*, row_prebuilt_t*, const rec_t*, const ulint*): Assertion `!prebuilt->index->is_primary()' failed.
            190712 17:35:29 [ERROR] mysqld got signal 6 ;

            linux/raise.c:54(__GI_raise)[0x7ffa559a3428]
            stdlib/abort.c:91(__GI_abort)[0x7ffa559a502a]
            assert/assert.c:92(__assert_fail_base)[0x7ffa5599bbd7]
            /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7ffa5599bc82]
            row/row0sel.cc:3907(row_search_idx_cond_check(unsigned char*, row_prebuilt_t*, unsigned char const*, unsigned long const*))[0x5608a761301a]
            row/row0sel.cc:5220(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long))[0x5608a7616a24]
            handler/ha_innodb.cc:9337(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x5608a74727df]
            handler/ha_innodb.cc:9710(ha_innobase::index_first(unsigned char*))[0x5608a7473748]
            handler/ha_innodb.cc:9803(ha_innobase::rnd_next(unsigned char*))[0x5608a7473920]
            sql/handler.cc:2834(handler::ha_rnd_next(unsigned char*))[0x5608a7103dd5]
            sql/records.cc:477(rr_sequential(READ_RECORD*))[0x5608a72988ec]
            sql/records.h:69(READ_RECORD::read_record())[0x5608a6d16c13]
            sql/sql_select.cc:21056(join_init_read_record(st_join_table*))[0x5608a6e3d2be]
            sql/sql_join_cache.cc:3350(JOIN_TAB_SCAN::open())[0x5608a6f82004]
            sql/sql_join_cache.cc:2252(JOIN_CACHE::join_matching_records(bool))[0x5608a6f8044d]
            sql/sql_join_cache.cc:2088(JOIN_CACHE::join_records(bool))[0x5608a6f7ff7e]
            sql/sql_select.cc:19892(sub_select_cache(JOIN*, st_join_table*, bool))[0x5608a6e3ab71]
            sql/sql_select.cc:20063(sub_select(JOIN*, st_join_table*, bool))[0x5608a6e3ad7c]
            sql/sql_select.cc:19654(do_select(JOIN*, Procedure*))[0x5608a6e3a546]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x5608a6e107b3]
            sql/sql_select.cc:4174(JOIN::exec())[0x5608a6e0f960]
            sql/item_subselect.cc:5484(subselect_hash_sj_engine::exec())[0x5608a71e2e71]
            sql/item_subselect.cc:745(Item_subselect::exec())[0x5608a71d446e]
            sql/item_subselect.cc:925(Item_in_subselect::exec())[0x5608a71d4ac0]
            sql/item_subselect.cc:1796(Item_in_subselect::val_bool())[0x5608a71d796a]
            sql/item.h:1521(Item::val_bool_result())[0x5608a6ca8ab5]
            sql/item_cmpfunc.cc:1628(Item_in_optimizer::val_int())[0x5608a7133ead]
            sql/item.h:1517(Item::val_int_result())[0x5608a713c10c]
            sql/item.cc:9712(Item_cache_int::cache_value())[0x5608a7131420]
            sql/item.cc:8532(Item_cache_wrapper::cache())[0x5608a71510a3]
            sql/item.cc:8718(Item_cache_wrapper::val_bool())[0x5608a6e3b386]
            sql/item_cmpfunc.cc:5300(Item_cond_or::val_int())[0x5608a6e3afb0]
            sql/sql_select.cc:20209(evaluate_join_record(JOIN*, st_join_table*, int))[0x5608a6e3a4e0]
            sql/sql_select.cc:20114(sub_select(JOIN*, st_join_table*, bool))[0x5608a6e107b3]
            sql/sql_select.cc:19652(do_select(JOIN*, Procedure*))[0x5608a6e0f960]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x5608a71dfd0a]
            sql/sql_select.cc:4174(JOIN::exec())[0x5608a71d446e]
            sql/item_subselect.cc:3930(subselect_single_select_engine::exec())[0x5608a71d7488]
            sql/item_subselect.cc:745(Item_subselect::exec())[0x5608a7144c73]
            sql/item_subselect.cc:1644(Item_exists_subselect::val_int())[0x5608a6e101e3]
            sql/item_cmpfunc.cc:1546(Item_in_optimizer::val_int())[0x5608a6e0f960]
            sql/sql_select.cc:4286(JOIN::exec_inner())[0x5608a6e11005]
            sql/sql_select.cc:4174(JOIN::exec())[0x5608a6e015ce]
            sql/sql_select.cc:4607(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5608a6dcaf0a]
            sql/sql_select.cc:425(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5608a6dc0d58]
            sql/sql_parse.cc:6340(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5608a6dcece2]
            sql/sql_parse.cc:3882(mysql_execute_command(THD*))[0x5608a6dbaf51]
            sql/sql_parse.cc:7892(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5608a6db96e3]
            sql/sql_parse.cc:1829(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5608a6f33994]
            sql/sql_parse.cc:1360(do_command(THD*))[0x5608a6f336bd]
            /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7ffa567e46ba]
            x86_64/clone.S:111(clone)[0x7ffa55a7541d]
            {noformat}
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            Assignee Alice Sherepa [ alice ] Igor Babaev [ igor ]
            alice Alice Sherepa made changes -
            Summary [draft] Assertion `!prebuilt->index->is_primary()' failed in row_search_idx_cond_check Assertion `!prebuilt->index->is_primary()' failed in row_search_idx_cond_check
            alice Alice Sherepa made changes -
            Description {code:sql}
            --source include/have_innodb.inc

            CREATE TABLE t1 (ch varchar(1),id int,id2 int) ENGINE=InnoDB;
            INSERT INTO t1 VALUES ('l',3,2),('e',NULL,NULL),('r',7,3),('h',NULL,2),(NULL,4,4),('c',4,NULL),('k',NULL,NULL),('h',NULL,NULL),('b',9,NULL),('f',6,NULL);

            CREATE TABLE t2 (pk int NOT NULL , col_date_key date , ch2 varchar(1) , id2 int , PRIMARY KEY (pk), KEY (col_date_key), KEY (ch2), KEY (id2)) ENGINE=InnoDB;
            INSERT INTO t2 VALUES (1,'2034-04-21','g',9),(2,'2006-09-08','y',1),(3,NULL,'h',2),(4,'1987-03-02','s',2),(5,'2019-07-02','u',NULL),(6,'2012-12-18','z',1),(7,NULL,'w',4),(8,'2005-03-10','o',8),(9,'1987-02-12','d',4);

            CREATE TABLE t3 ( id int) ENGINE=InnoDB;
            INSERT INTO t3 VALUES (6);

            SELECT 1 FROM t3
            WHERE EXISTS(SELECT 1 FROM t1 WHERE t3.id IN (
              SELECT bt1.id FROM (t2 JOIN t1 AS bt1 ON bt1.ch = t2.ch2 and bt1.id = t2.pk) WHERE t2.ch2 <= 'g')
            OR t1.id2 = t1.id);
            {code}
            {noformat:title=10.4 a0230bc76d78202178f43}
            mysqld: /src/storage/innobase/row/row0sel.cc:3906: ICP_RESULT row_search_idx_cond_check(byte*, row_prebuilt_t*, const rec_t*, const ulint*): Assertion `!prebuilt->index->is_primary()' failed.
            190712 17:35:29 [ERROR] mysqld got signal 6 ;

            linux/raise.c:54(__GI_raise)[0x7ffa559a3428]
            stdlib/abort.c:91(__GI_abort)[0x7ffa559a502a]
            assert/assert.c:92(__assert_fail_base)[0x7ffa5599bbd7]
            /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7ffa5599bc82]
            row/row0sel.cc:3907(row_search_idx_cond_check(unsigned char*, row_prebuilt_t*, unsigned char const*, unsigned long const*))[0x5608a761301a]
            row/row0sel.cc:5220(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long))[0x5608a7616a24]
            handler/ha_innodb.cc:9337(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x5608a74727df]
            handler/ha_innodb.cc:9710(ha_innobase::index_first(unsigned char*))[0x5608a7473748]
            handler/ha_innodb.cc:9803(ha_innobase::rnd_next(unsigned char*))[0x5608a7473920]
            sql/handler.cc:2834(handler::ha_rnd_next(unsigned char*))[0x5608a7103dd5]
            sql/records.cc:477(rr_sequential(READ_RECORD*))[0x5608a72988ec]
            sql/records.h:69(READ_RECORD::read_record())[0x5608a6d16c13]
            sql/sql_select.cc:21056(join_init_read_record(st_join_table*))[0x5608a6e3d2be]
            sql/sql_join_cache.cc:3350(JOIN_TAB_SCAN::open())[0x5608a6f82004]
            sql/sql_join_cache.cc:2252(JOIN_CACHE::join_matching_records(bool))[0x5608a6f8044d]
            sql/sql_join_cache.cc:2088(JOIN_CACHE::join_records(bool))[0x5608a6f7ff7e]
            sql/sql_select.cc:19892(sub_select_cache(JOIN*, st_join_table*, bool))[0x5608a6e3ab71]
            sql/sql_select.cc:20063(sub_select(JOIN*, st_join_table*, bool))[0x5608a6e3ad7c]
            sql/sql_select.cc:19654(do_select(JOIN*, Procedure*))[0x5608a6e3a546]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x5608a6e107b3]
            sql/sql_select.cc:4174(JOIN::exec())[0x5608a6e0f960]
            sql/item_subselect.cc:5484(subselect_hash_sj_engine::exec())[0x5608a71e2e71]
            sql/item_subselect.cc:745(Item_subselect::exec())[0x5608a71d446e]
            sql/item_subselect.cc:925(Item_in_subselect::exec())[0x5608a71d4ac0]
            sql/item_subselect.cc:1796(Item_in_subselect::val_bool())[0x5608a71d796a]
            sql/item.h:1521(Item::val_bool_result())[0x5608a6ca8ab5]
            sql/item_cmpfunc.cc:1628(Item_in_optimizer::val_int())[0x5608a7133ead]
            sql/item.h:1517(Item::val_int_result())[0x5608a713c10c]
            sql/item.cc:9712(Item_cache_int::cache_value())[0x5608a7131420]
            sql/item.cc:8532(Item_cache_wrapper::cache())[0x5608a71510a3]
            sql/item.cc:8718(Item_cache_wrapper::val_bool())[0x5608a6e3b386]
            sql/item_cmpfunc.cc:5300(Item_cond_or::val_int())[0x5608a6e3afb0]
            sql/sql_select.cc:20209(evaluate_join_record(JOIN*, st_join_table*, int))[0x5608a6e3a4e0]
            sql/sql_select.cc:20114(sub_select(JOIN*, st_join_table*, bool))[0x5608a6e107b3]
            sql/sql_select.cc:19652(do_select(JOIN*, Procedure*))[0x5608a6e0f960]
            sql/sql_select.cc:4391(JOIN::exec_inner())[0x5608a71dfd0a]
            sql/sql_select.cc:4174(JOIN::exec())[0x5608a71d446e]
            sql/item_subselect.cc:3930(subselect_single_select_engine::exec())[0x5608a71d7488]
            sql/item_subselect.cc:745(Item_subselect::exec())[0x5608a7144c73]
            sql/item_subselect.cc:1644(Item_exists_subselect::val_int())[0x5608a6e101e3]
            sql/item_cmpfunc.cc:1546(Item_in_optimizer::val_int())[0x5608a6e0f960]
            sql/sql_select.cc:4286(JOIN::exec_inner())[0x5608a6e11005]
            sql/sql_select.cc:4174(JOIN::exec())[0x5608a6e015ce]
            sql/sql_select.cc:4607(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5608a6dcaf0a]
            sql/sql_select.cc:425(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5608a6dc0d58]
            sql/sql_parse.cc:6340(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5608a6dcece2]
            sql/sql_parse.cc:3882(mysql_execute_command(THD*))[0x5608a6dbaf51]
            sql/sql_parse.cc:7892(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5608a6db96e3]
            sql/sql_parse.cc:1829(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5608a6f33994]
            sql/sql_parse.cc:1360(do_command(THD*))[0x5608a6f336bd]
            /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7ffa567e46ba]
            x86_64/clone.S:111(clone)[0x7ffa55a7541d]
            {noformat}             		{code:sql}
            --source include/have_innodb.inc

            CREATE TABLE t1 (ch varchar(1),id int,id2 int) ENGINE=InnoDB;
            INSERT INTO t1 VALUES ('l',3,2),('e',NULL,NULL),('r',7,3),('h',NULL,2),(NULL,4,4),('c',4,NULL),('k',NULL,NULL),('h',NULL,NULL),('b',9,NULL),('f',6,NULL);

            CREATE TABLE t2 (pk int NOT NULL , col_date_key date , ch2 varchar(1) , id2 int , PRIMARY KEY (pk), KEY (col_date_key), KEY (ch2), KEY (id2)) ENGINE=InnoDB;
            INSERT INTO t2 VALUES (1,'2034-04-21','g',9),(2,'2006-09-08','y',1),(3,NULL,'h',2),(4,'1987-03-02','s',2),(5,'2019-07-02','u',NULL),(6,'2012-12-18','z',1),(7,NULL,'w',4),(8,'2005-03-10','o',8),(9,'1987-02-12','d',4);

            CREATE TABLE t3 ( id int) ENGINE=InnoDB;
            INSERT INTO t3 VALUES (6);

            SELECT 1 FROM t3
            WHERE EXISTS(SELECT 1 FROM t1 WHERE t3.id IN (
              SELECT bt1.id FROM (t2 JOIN t1 AS bt1 ON bt1.ch = t2.ch2 and bt1.id = t2.pk) WHERE t2.ch2 <= 'g')
            OR t1.id2 = t1.id);
            {code}
            {noformat:title=10.4 a0230bc76d78202178f43}

            #4 0x00007f9c1f600428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
            #5 0x00007f9c1f60202a in __GI_abort () at abort.c:89
            #6 0x00007f9c1f5f8bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x55c9649735a0 "!prebuilt->index->is_primary()", file=file@entry=0x55c9649724d0 "/10.4/storage/innobase/row/row0sel.cc", line=line@entry=3906, function=function@entry=0x55c9649766c0 <row_search_idx_cond_check(unsigned char*, row_prebuilt_t*, unsigned char const*, unsigned long const*)::__PRETTY_FUNCTION__> "ICP_RESULT row_search_idx_cond_check(byte*, row_prebuilt_t*, const rec_t*, const ulint*)") at assert.c:92
            #7 0x00007f9c1f5f8c82 in __GI___assert_fail (assertion=0x55c9649735a0 "!prebuilt->index->is_primary()", file=0x55c9649724d0 "/10.4/storage/innobase/row/row0sel.cc", line=3906, function=0x55c9649766c0 <row_search_idx_cond_check(unsigned char*, row_prebuilt_t*, unsigned char const*, unsigned long const*)::__PRETTY_FUNCTION__> "ICP_RESULT row_search_idx_cond_check(byte*, row_prebuilt_t*, const rec_t*, const ulint*)") at assert.c:101
            #8 0x000055c96431101a in row_search_idx_cond_check (mysql_rec=0x7f9bc8068900 "\375\001", prebuilt=0x7f9bc80727f8, rec=0x7f9c13d4007f "\200", offsets=0x7f9c18378f80) at /10.4/storage/innobase/row/row0sel.cc:3906
            #9 0x000055c964314a24 in row_search_mvcc (buf=0x7f9bc8068900 "\375\001", mode=PAGE_CUR_G, prebuilt=0x7f9bc80727f8, match_mode=0, direction=0) at /10.4/storage/innobase/row/row0sel.cc:5220
            #10 0x000055c9641707df in ha_innobase::index_read (this=0x7f9bc8069738, buf=0x7f9bc8068900 "\375\001", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /10.4/storage/innobase/handler/ha_innodb.cc:9337
            #11 0x000055c964171748 in ha_innobase::index_first (this=0x7f9bc8069738, buf=0x7f9bc8068900 "\375\001") at /10.4/storage/innobase/handler/ha_innodb.cc:9710
            #12 0x000055c964171920 in ha_innobase::rnd_next (this=0x7f9bc8069738, buf=0x7f9bc8068900 "\375\001") at /10.4/storage/innobase/handler/ha_innodb.cc:9803
            #13 0x000055c963e01d83 in handler::ha_rnd_next (this=0x7f9bc8069738, buf=0x7f9bc8068900 "\375\001") at /10.4/sql/handler.cc:2834
            #14 0x000055c963f968ec in rr_sequential (info=0x7f9bc81af090) at /10.4/sql/records.cc:477
            #15 0x000055c963a14c13 in READ_RECORD::read_record (this=0x7f9bc81af090) at /10.4/sql/records.h:69
            #16 0x000055c963b3b2be in join_init_read_record (tab=0x7f9bc81aefc8) at /10.4/sql/sql_select.cc:21055
            #17 0x000055c963c80004 in JOIN_TAB_SCAN::open (this=0x7f9bc81b0a50) at /10.4/sql/sql_join_cache.cc:3349
            #18 0x000055c963c7e44d in JOIN_CACHE::join_matching_records (this=0x7f9bc81b0920, skip_last=false) at /10.4/sql/sql_join_cache.cc:2252
            #19 0x000055c963c7df7e in JOIN_CACHE::join_records (this=0x7f9bc81b0920, skip_last=false) at /10.4/sql/sql_join_cache.cc:2088
            #20 0x000055c963b38b71 in sub_select_cache (join=0x7f9bc81a47c0, join_tab=0x7f9bc81aefc8, end_of_records=true) at /10.4/sql/sql_select.cc:19892
            #21 0x000055c963b38d7c in sub_select (join=0x7f9bc81a47c0, join_tab=0x7f9bc81aec20, end_of_records=true) at /10.4/sql/sql_select.cc:20063
            #22 0x000055c963b38546 in do_select (join=0x7f9bc81a47c0, procedure=0x0) at /10.4/sql/sql_select.cc:19654
            #23 0x000055c963b0e7b3 in JOIN::exec_inner (this=0x7f9bc81a47c0) at /10.4/sql/sql_select.cc:4391
            #24 0x000055c963b0d960 in JOIN::exec (this=0x7f9bc81a47c0) at /10.4/sql/sql_select.cc:4173
            #25 0x000055c963ee0e71 in subselect_hash_sj_engine::exec (this=0x7f9bc81aa9c8) at /10.4/sql/item_subselect.cc:5483
            #26 0x000055c963ed246e in Item_subselect::exec (this=0x7f9bc8017d50) at /10.4/sql/item_subselect.cc:745
            #27 0x000055c963ed2ac0 in Item_in_subselect::exec (this=0x7f9bc8017d50) at /10.4/sql/item_subselect.cc:925
            #28 0x000055c963ed596a in Item_in_subselect::val_bool (this=0x7f9bc8017d50) at /10.4/sql/item_subselect.cc:1796
            #29 0x000055c9639a6b41 in Item::val_bool_result (this=0x7f9bc8017d50) at /10.4/sql/item.h:1521
            #30 0x000055c963e42f08 in Item_in_optimizer::val_int (this=0x7f9bc81a4e70) at /10.4/sql/item_cmpfunc.cc:1628
            #31 0x000055c9639a6ab5 in Item::val_int_result (this=0x7f9bc81a4e70) at /10.4/sql/item.h:1517
            #32 0x000055c963e31ead in Item_cache_int::cache_value (this=0x7f9bc81b16b0) at /10.4/sql/item.cc:9712
            #33 0x000055c963e3a10c in Item_cache_wrapper::cache (this=0x7f9bc81b15f0) at /10.4/sql/item.cc:8531
            #34 0x000055c963e2f420 in Item_cache_wrapper::val_bool (this=0x7f9bc81b15f0) at /10.4/sql/item.cc:8717
            #35 0x000055c963e4f0a3 in Item_cond_or::val_int (this=0x7f9bc81a78c8) at /10.4/sql/item_cmpfunc.cc:5300
            #36 0x000055c963b39386 in evaluate_join_record (join=0x7f9bc81a4070, join_tab=0x7f9bc81a7178, error=0) at /10.4/sql/sql_select.cc:20209
            #37 0x000055c963b38fb0 in sub_select (join=0x7f9bc81a4070, join_tab=0x7f9bc81a7178, end_of_records=false) at /10.4/sql/sql_select.cc:20114
            #38 0x000055c963b384e0 in do_select (join=0x7f9bc81a4070, procedure=0x0) at /10.4/sql/sql_select.cc:19652
            #39 0x000055c963b0e7b3 in JOIN::exec_inner (this=0x7f9bc81a4070) at /10.4/sql/sql_select.cc:4391
            #40 0x000055c963b0d960 in JOIN::exec (this=0x7f9bc81a4070) at /10.4/sql/sql_select.cc:4173
            #41 0x000055c963eddd0a in subselect_single_select_engine::exec (this=0x7f9bc8018ed0) at /10.4/sql/item_subselect.cc:3927
            #42 0x000055c963ed246e in Item_subselect::exec (this=0x7f9bc8018d30) at /10.4/sql/item_subselect.cc:745
            #43 0x000055c963ed5488 in Item_exists_subselect::val_int (this=0x7f9bc8018d30) at /10.4/sql/item_subselect.cc:1644
            #44 0x000055c963e42c73 in Item_in_optimizer::val_int (this=0x7f9bc81a5190) at /10.4/sql/item_cmpfunc.cc:1546
            #45 0x000055c963b0e1e3 in JOIN::exec_inner (this=0x7f9bc81a38f8) at /10.4/sql/sql_select.cc:4287
            #46 0x000055c963b0d960 in JOIN::exec (this=0x7f9bc81a38f8) at /10.4/sql/sql_select.cc:4173
            #47 0x000055c963b0f005 in mysql_select (thd=0x7f9bc8000b00, tables=0x7f9bc8013820, wild_num=0, fields=..., conds=0x7f9bc8018d30, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f9bc8019020, unit=0x7f9bc8004a30, select_lex=0x7f9bc80132d8) at /10.4/sql/sql_select.cc:4605
            #48 0x000055c963aff5ce in handle_select (thd=0x7f9bc8000b00, lex=0x7f9bc8004968, result=0x7f9bc8019020, setup_tables_done_option=0) at /10.4/sql/sql_select.cc:425
            #49 0x000055c963ac8f0a in execute_sqlcom_select (thd=0x7f9bc8000b00, all_tables=0x7f9bc8013820) at /10.4/sql/sql_parse.cc:6340
            #50 0x000055c963abed58 in mysql_execute_command (thd=0x7f9bc8000b00) at /10.4/sql/sql_parse.cc:3882
            #51 0x000055c963accce2 in mysql_parse (thd=0x7f9bc8000b00, rawbuf=0x7f9bc8013108 "SELECT 1 FROM t3\nWHERE EXISTS(SELECT 1 FROM t1 WHERE id IN (\nSELECT bt1.id FROM (t2 JOIN t1 AS bt1 ON bt1.ch = t2.ch2 and bt1.id = t2.pk) WHERE t2.ch2 <= 'g') \nOR t1.id2 = t1.id)", length=178, parser_state=0x7f9c1837c000, is_com_multi=false, is_next_command=false) at /10.4/sql/sql_parse.cc:7892
            #52 0x000055c963ab8f51 in dispatch_command (command=COM_QUERY, thd=0x7f9bc8000b00, packet=0x7f9bc819dca1 "SELECT 1 FROM t3\nWHERE EXISTS(SELECT 1 FROM t1 WHERE id IN (\nSELECT bt1.id FROM (t2 JOIN t1 AS bt1 ON bt1.ch = t2.ch2 and bt1.id = t2.pk) WHERE t2.ch2 <= 'g') \nOR t1.id2 = t1.id)", packet_length=178, is_com_multi=false, is_next_command=false) at /10.4/sql/sql_parse.cc:1827
            #53 0x000055c963ab76e3 in do_command (thd=0x7f9bc8000b00) at /10.4/sql/sql_parse.cc:1360
            #54 0x000055c963c31994 in do_handle_one_connection (connect=0x55c9674bb080) at /10.4/sql/sql_connect.cc:1404
            #55 0x000055c963c316bd in handle_one_connection (arg=0x55c9674bb080) at /10.4/sql/sql_connect.cc:1306
            #56 0x000055c96455d015 in pfs_spawn_thread (arg=0x55c967439830) at /10.4/storage/perfschema/pfs.cc:1862
            #57 0x00007f9c204416ba in start_thread (arg=0x7f9c1837d700) at pthread_create.c:333
            #58 0x00007f9c1f6d241d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

            {noformat}
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            Assignee Igor Babaev [ igor ] Marko Mäkelä [ marko ]
            alice Alice Sherepa made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            Component/s Optimizer [ 10200 ]
            Assignee Marko Mäkelä [ marko ] Igor Babaev [ igor ]
            alice Alice Sherepa made changes -
            igor Igor Babaev (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            igor Igor Babaev (Inactive) made changes -
            Component/s Storage Engine - InnoDB [ 10129 ]
            Fix Version/s 10.4.11 [ 24013 ]
            Fix Version/s 10.4 [ 22408 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            igor Igor Babaev (Inactive) made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            nikitamalyavin Nikita Malyavin made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 98209 ] MariaDB v4 [ 156472 ]

            People

              igor Igor Babaev (Inactive)
              alice Alice Sherepa
              Votes:
              1 Vote for this issue
              Watchers:
              5 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.