--source include/have_partition.inc

CREATE TABLE t1 (a INT);

INSERT INTO t1 () VALUES (1),(NULL),(2);

CREATE TABLE t2 (b INT, c INT, KEY(b), KEY(c)) PARTITION BY HASH(b);

INSERT INTO t2 VALUES (NULL,4),(NULL,6),(7,8);

SELECT * FROM t1 WHERE a NOT IN (SELECT c FROM t2 WHERE a IN (SELECT c FROM t2) AND b != 9);

# Cleanup

DROP TABLE t1, t2;

mariadbd: /data/src/10.5/sql/handler.h:4357: virtual void handler::disable_pushed_rowid_filter(): Assertion `pushed_rowid_filter != __null && save_pushed_rowid_filter == __null' failed.

220703 15:42:49 [ERROR] mysqld got signal 6 ;

#7  0x00007f9a8f174662 in __GI___assert_fail (assertion=0x55a3fff1aad8 "pushed_rowid_filter != __null && save_pushed_rowid_filter == __null", file=0x55a3fff1a546 "/data/src/10.5/sql/handler.h", line=4357, function=0x55a3fff1aaa0 "virtual void handler::disable_pushed_rowid_filter()") at assert.c:101

No locals.

#8  0x000055a3ff34dd6d in handler::disable_pushed_rowid_filter (this=0x7f9a780609d0) at /data/src/10.5/sql/handler.h:4357

        __PRETTY_FUNCTION__ = "virtual void handler::disable_pushed_rowid_filter()"

#9  0x000055a3ff42a197 in subselect_single_select_engine::exec (this=0x7f9a78019840) at /data/src/10.5/sql/item_subselect.cc:4085

        cond_guard = 0x7f9a78073188

        i = 0

        tab = 0x7f9a78075c60

        changed_tabs = {0x7f9a78224aa8, 0x7f9a78084be8, 0x7f9a89b2ff60, 0x55a3ffc2ac62 <_my_thread_var+20>, 0x7f9a89b2ff60, 0x55a3ffc2ad8e <my_thread_var_dbug+31>, 0x2, 0x7f9a78000b60, 0x7f9a89b2ff80, 0x55a3ffc5797b <code_state+167>, 0x7f9a78000ce0, 0x7f9a78000cb8, 0x7f9a89b2ffb0, 0x55a3ffc5a19c <_db_pargs_+20>, 0x55a400037c49, 0xad00000001, 0x2, 0xa49f3700, 0x55a3ffdbc268, 0x0, 0x7f9a89b2ffe0, 0x10000ffc2ad8e, 0x7f9a89b30000, 0x55a3ffc5ad6d <DoTrace+150>, 0x7f9a89b30000, 0x7f9a78000ce0, 0x7f9a78000ce0, 0x178000cb8, 0x7f9a89b30240, 0xffc59fdf, 0x55a3fff26a90, 0x0, 0x7f9a89b30040, 0x10000ffc2ad8e, 0x7f9a89b30060, 0x55a3ffc5ad6d <DoTrace+150>, 0x7f9a89b30060, 0x7f9a78000ce0, 0x7f9a78000ce0, 0x178000cb8, 0x7f9a89b302a0, 0x55a3ffc59fdf <_db_return_+209>, 0x7f9a780840d0, 0x89b302d0, 0x55a3fff418e8, 0x0, 0x7f9a89b300b0, 0x55a3ffc2ac62 <_my_thread_var+20>, 0x7f9a89b300c0, 0x55a3ffc2ad8e <my_thread_var_dbug+31>, 0x7f9a89b300d0, 0x7f9a78000b60, 0x7f9a89b300e0, 0x55a3ffc5797b <code_state+167>, 0x7f9a78000ce0, 0x7f9a78000cb8, 0x7f9a89b30120, 0x55a3ffc5ae90 <_db_keyword_+52>, 0x55a3fff41650, 0x178006a78, 0x55a3fff41981}

        last_changed_tab = 0x7f9a89b2ff20

        _db_stack_frame_ = {func = 0x55a3fff418e8 "Item_subselect::exec", file = 0x55a3fff41650 "/data/src/10.5/sql/item_subselect.cc", level = 2147483663, line = -1, prev = 0x7f9a89b30150}

        save_where = 0x55a3ffd55578 "order clause"

        save_select = 0x7f9a78015428

#10 0x000055a3ff41cff3 in Item_subselect::exec (this=0x7f9a780195f8) at /data/src/10.5/sql/item_subselect.cc:837

        org_engine = 0x7f9a78019840

        _db_stack_frame_ = {func = 0x55a3fff41a86 "Item_in_subselect::exec", file = 0x55a3fff41650 "/data/src/10.5/sql/item_subselect.cc", level = 2147483662, line = -1, prev = 0x7f9a89b301c0}

        __PRETTY_FUNCTION__ = "virtual bool Item_subselect::exec()"

        res = false

#11 0x000055a3ff41d6b9 in Item_in_subselect::exec (this=0x7f9a780195f8) at /data/src/10.5/sql/item_subselect.cc:1017

        _db_stack_frame_ = {func = 0x55a3fff2afde " Item_in_optimizer::val_int", file = 0x55a3fff2aad0 "/data/src/10.5/sql/item_cmpfunc.cc", level = 2147483661, line = 1017, prev = 0x7f9a89b30270}

        __PRETTY_FUNCTION__ = "virtual bool Item_in_subselect::exec()"

#12 0x000055a3ff42155e in Item_in_subselect::val_bool (this=0x7f9a780195f8) at /data/src/10.5/sql/item_subselect.cc:1947

        __PRETTY_FUNCTION__ = "virtual bool Item_in_subselect::val_bool()"

#13 0x000055a3fee9c7ef in Item::val_bool_result (this=0x7f9a780195f8) at /data/src/10.5/sql/item.h:1575

No locals.

#14 0x000055a3ff383bab in Item_in_optimizer::val_int (this=0x7f9a7806f788) at /data/src/10.5/sql/item_cmpfunc.cc:1638

        item_subs = 0x7f9a780195f8

        all_left_cols_null = true

        ncols = 1

        tmp = 137

        __PRETTY_FUNCTION__ = "virtual longlong Item_in_optimizer::val_int()"

        _db_stack_frame_ = {func = 0x55a3fff26b48 "Item_cache_wrapper::val_bool", file = 0x55a3fff2418c "/data/src/10.5/sql/item.cc", level = 2147483660, line = -1, prev = 0x7f9a89b30330}

#15 0x000055a3fee9c763 in Item::val_int_result (this=0x7f9a7806f788) at /data/src/10.5/sql/item.h:1571

No locals.

#16 0x000055a3ff3722b7 in Item_cache_int::cache_value (this=0x7f9a7807dd08) at /data/src/10.5/sql/item.cc:10045

No locals.

#17 0x000055a3ff37ab5a in Item_cache_wrapper::cache (this=0x7f9a7807dc40) at /data/src/10.5/sql/item.cc:8808

No locals.

#18 0x000055a3ff36f05d in Item_cache_wrapper::val_bool (this=0x7f9a7807dc40) at /data/src/10.5/sql/item.cc:8994

        cached_value = 0x0

        _db_stack_frame_ = {func = 0x55a3ffd58af3 "evaluate_join_record", file = 0x55a3ffd54fc8 "/data/src/10.5/sql/sql_select.cc", level = 2147483659, line = -1, prev = 0x7f9a89b30410}

#19 0x000055a3ff37eacc in Item_func_not::val_int (this=0x7f9a78019880) at /data/src/10.5/sql/item_cmpfunc.cc:202

        __PRETTY_FUNCTION__ = "virtual longlong Item_func_not::val_int()"

        value = false

#20 0x000055a3ff04e82f in evaluate_join_record (join=0x7f9a7801a2c8, join_tab=0x7f9a78070d60, error=0) at /data/src/10.5/sql/sql_select.cc:21029

        shortcut_for_distinct = false

        found_records = 0

        select_cond = 0x7f9a78019880

        select_cond_result = true

        _db_stack_frame_ = {func = 0x55a3ffd58ae8 "sub_select", file = 0x55a3ffd54fc8 "/data/src/10.5/sql/sql_select.cc", level = 2147483658, line = -1, prev = 0x7f9a89b304b0}

#21 0x000055a3ff04e5d8 in sub_select (join=0x7f9a7801a2c8, join_tab=0x7f9a78070d60, end_of_records=false) at /data/src/10.5/sql/sql_select.cc:20970

        _db_stack_frame_ = {func = 0x55a3ffd58908 "do_select", file = 0x55a3ffd54fc8 "/data/src/10.5/sql/sql_select.cc", level = 2147483657, line = -1, prev = 0x7f9a89b30550}

        error = 0

        rc = NESTED_LOOP_OK

        info = 0x7f9a78070e28

        pfs_batch_update = false

        skip_over = false

#22 0x000055a3ff04d859 in do_select (join=0x7f9a7801a2c8, procedure=0x0) at /data/src/10.5/sql/sql_select.cc:20463

        join_tab = 0x7f9a78070d60

        rc = 0

        error = NESTED_LOOP_OK

        _db_stack_frame_ = {func = 0x55a3ffd56101 "JOIN::exec_inner", file = 0x55a3ffd54fc8 "/data/src/10.5/sql/sql_select.cc", level = 2147483656, line = -1, prev = 0x7f9a89b305b0}

        __PRETTY_FUNCTION__ = "int do_select(JOIN*, Procedure*)"

#23 0x000055a3ff020e13 in JOIN::exec_inner (this=0x7f9a7801a2c8) at /data/src/10.5/sql/sql_select.cc:4540

        columns_list = 0x7f9a78015578

        _db_stack_frame_ = {func = 0x55a3ffd561df "mysql_select", file = 0x55a3ffd54fc8 "/data/src/10.5/sql/sql_select.cc", level = 2147483655, line = -1, prev = 0x7f9a89b306f0}

        __PRETTY_FUNCTION__ = "void JOIN::exec_inner()"

        trace_wrapper = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x55a4005b8d08 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}

        trace_exec = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x55a4005b8d08 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}

        trace_steps = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x55a4005b8ce8 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}

#24 0x000055a3ff01ff15 in JOIN::exec (this=0x7f9a7801a2c8) at /data/src/10.5/sql/sql_select.cc:4320

No locals.

#25 0x000055a3ff02176b in mysql_select (thd=0x7f9a78000db8, tables=0x7f9a78015a38, fields=@0x7f9a78015578: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7f9a780159f0, last = 0x7f9a780159f0, elements = 1}, <No data fields>}, conds=0x7f9a78019880, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f9a7801a2a0, unit=0x7f9a78004f60, select_lex=0x7f9a78015428) at /data/src/10.5/sql/sql_select.cc:4797

        err = 0

        free_join = true

        _db_stack_frame_ = {func = 0x55a3ffd550b0 "handle_select", file = 0x55a3ffd54fc8 "/data/src/10.5/sql/sql_select.cc", level = 2147483654, line = -1, prev = 0x7f9a89b307b0}

        join = 0x7f9a7801a2c8

#26 0x000055a3ff011135 in handle_select (thd=0x7f9a78000db8, lex=0x7f9a78004e98, result=0x7f9a7801a2a0, setup_tables_done_option=0) at /data/src/10.5/sql/sql_select.cc:444

        unit = 0x7f9a78004f60

        res = false

        select_lex = 0x7f9a78015428

        _db_stack_frame_ = {func = 0x55a3ffd46998 "mysql_execute_command", file = 0x55a3ffd45d20 "/data/src/10.5/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7f9a89b30e00}

#27 0x000055a3fefd3f48 in execute_sqlcom_select (thd=0x7f9a78000db8, all_tables=0x7f9a78015a38) at /data/src/10.5/sql/sql_parse.cc:6314

        save_protocol = 0x0

        lex = 0x7f9a78004e98

        result = 0x7f9a7801a2a0

        res = false

        __PRETTY_FUNCTION__ = "bool execute_sqlcom_select(THD*, TABLE_LIST*)"

#28 0x000055a3fefcb27f in mysql_execute_command (thd=0x7f9a78000db8) at /data/src/10.5/sql/sql_parse.cc:4005

        privileges_requested = SELECT_ACL

        res = 0

        up_result = 0

        lex = 0x7f9a78004e98

        select_lex = 0x7f9a78015428

        first_table = 0x7f9a78015a38

        all_tables = 0x7f9a78015a38

        unit = 0x7f9a78004f60

        have_table_map_for_update = false

        rpl_filter = 0x0

        _db_stack_frame_ = {func = 0x55a3ffd47cef "mysql_parse", file = 0x55a3ffd45d20 "/data/src/10.5/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7f9a89b31210}

        __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)"

        ots = {ctx = 0x7f9a78004b60, traceable = false}

        trace_command = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x55a4005b8d08 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}

        trace_command_steps = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x55a4005b8ce8 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}

        orig_binlog_format = BINLOG_FORMAT_MIXED

        orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT

#29 0x000055a3fefd8d19 in mysql_parse (thd=0x7f9a78000db8, rawbuf=0x7f9a78015310 "SELECT * FROM t1 WHERE a NOT IN (SELECT c FROM t2 WHERE a IN (SELECT c FROM t2) AND b != 9)", length=91, parser_state=0x7f9a89b313d0, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:8100

        found_semicolon = 0x0

        error = 32666

        lex = 0x7f9a78004e98

        err = false

        _db_stack_frame_ = {func = 0x55a3ffd461b2 "dispatch_command", file = 0x55a3ffd45d20 "/data/src/10.5/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7f9a89b313b0}

        __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*, bool, bool)"

#30 0x000055a3fefc4e52 in dispatch_command (command=COM_QUERY, thd=0x7f9a78000db8, packet=0x7f9a7800b5c9 "", packet_length=91, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1891

        packet_end = 0x7f9a7801536b ""

        parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7f9a78000db8, m_ptr = 0x7f9a7801536c "\004", m_tok_start = 0x7f9a7801536c "\004", m_tok_end = 0x7f9a7801536c "\004", m_end_of_query = 0x7f9a7801536b "", m_tok_start_prev = 0x7f9a7801536b "", m_buf = 0x7f9a78015310 "SELECT * FROM t1 WHERE a NOT IN (SELECT c FROM t2 WHERE a IN (SELECT c FROM t2) AND b != 9)", m_buf_length = 91, m_echo = true, m_echo_saved = 108, m_cpp_buf = 0x7f9a780153c8 "SELECT * FROM t1 WHERE a NOT IN (SELECT c FROM t2 WHERE a IN (SELECT c FROM t2) AND b != 9)", m_cpp_ptr = 0x7f9a78015423 "", m_cpp_tok_start = 0x7f9a78015423 "", m_cpp_tok_start_prev = 0x7f9a78015423 "", m_cpp_tok_end = 0x7f9a78015423 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x7f9a78000ce0 "\242\276\257\305\375\177", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, ignore_space = false, stmt_prepare_mode = false, multi_statements = true, yylineno = 1, m_digest = 0x0, in_comment = NO_COMMENT, in_comment_saved = (DISCARD_COMMENT | unknown: 0x7f98), m_cpp_text_start = 0x7f9a78015421 "9)", m_cpp_text_end = 0x7f9a78015422 ")", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 <repeats 12 times>}}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x7f9a780048f0}

        net = 0x7f9a780010e0

        error = false

        do_end_of_statement = true

        _db_stack_frame_ = {func = 0x55a3ffd45f1d "do_command", file = 0x55a3ffd45d20 "/data/src/10.5/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f9a89b31c80}

        drop_more_results = false

        __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint, bool, bool)"

        __FUNCTION__ = "dispatch_command"

        res = <optimized out>

#31 0x000055a3fefc36ac in do_command (thd=0x7f9a78000db8) at /data/src/10.5/sql/sql_parse.cc:1375

        return_value = false

        packet = 0x7f9a7800b5c8 "\001"

        packet_length = 92

        net = 0x7f9a780010e0

        command = COM_QUERY

        _db_stack_frame_ = {func = 0x55a4001a4760 "?func", file = 0x55a4001a4766 "?file", level = 2147483649, line = -1, prev = 0x0}

        __PRETTY_FUNCTION__ = "bool do_command(THD*)"

        __FUNCTION__ = "do_command"

#32 0x000055a3ff170ab7 in do_handle_one_connection (connect=0x55a4034eda18, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1418

        create_user = true

        thr_create_utime = 3274281802939

        thd = 0x7f9a78000db8

        __PRETTY_FUNCTION__ = "void do_handle_one_connection(CONNECT*, bool)"

#33 0x000055a3ff170779 in handle_one_connection (arg=0x55a4034cd528) at /data/src/10.5/sql/sql_connect.cc:1312

        connect = 0x55a4034cd528

#34 0x000055a3ff6814d6 in pfs_spawn_thread (arg=0x55a4034ed798) at /data/src/10.5/storage/perfschema/pfs.cc:2201

        typed_arg = 0x55a4034ed798

        user_arg = 0x55a4034cd528

        user_start_routine = 0x55a3ff17071e <handle_one_connection(void*)>

        pfs = 0x7f9a8ea72140

        klass = 0x55a402efe900

#35 0x00007f9a8f640ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477

        ret = <optimized out>

        pd = <optimized out>

        unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140301711910656, 3409811630798055073, 140727920075166, 140727920075167, 140301711908416, 311296, -3429764918130858335, -3429760133126904159}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}

        not_first_call = 0

#36 0x00007f9a8f23ddef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

EXPLAIN

{

  "query_block": {

    "select_id": 1,

    "table": {

      "table_name": "t1",

      "access_type": "ALL",

      "rows": 3,

      "filtered": 100,

      "attached_condition": "!<in_optimizer>(t1.a,<exists>(subquery#2))"

    },

    "subqueries": [

      {

        "query_block": {

          "select_id": 2,

          "outer_ref_condition": "t1.a is not null",

          "having_condition": "trigcond(t2.c is null)",

          "table": {

            "table_name": "<subquery3>",

            "access_type": "eq_ref",

            "possible_keys": ["distinct_key"],

            "key": "distinct_key",

            "key_length": "4",

            "used_key_parts": ["c"],

            "ref": ["func"],

            "rows": 1,

            "filtered": 100,

            "materialized": {

              "unique": 1,

              "query_block": {

                "select_id": 3,

                "table": {

                  "table_name": "t2",

                  "partitions": ["p0"],

                  "access_type": "ref",

                  "possible_keys": ["c"],

                  "key": "c",

                  "key_length": "5",

                  "used_key_parts": ["c"],

                  "ref": ["test.t1.a"],

                  "rows": 2,

                  "filtered": 100,

                  "using_index": true

                }

              }

            }

          },

          "full-scan-on-null_key": {

            "table": {

              "table_name": "t2",

              "partitions": ["p0"],

              "access_type": "ref_or_null",

              "possible_keys": ["b", "c"],

              "key": "c",

              "key_length": "5",

              "used_key_parts": ["c"],

              "ref": ["func"],

              "rowid_filter": {

                "range": {

                  "key": "b",

                  "used_key_parts": ["b"]

                },

                "rows": 2,

                "selectivity_pct": 66.66666667

              },

              "rows": 2,

              "filtered": 66.66666412,

              "attached_condition": "t2.b <> 9 and trigcond(<cache>(t1.a) = t2.c or t2.c is null)"

            }

          }

        }

      }

    ]

  }

}