bool ha_partition::can_skip_merging_scans(): Assertion `0' failed

SET optimizer_switch='mrr=on';

SET join_cache_level=5;

CREATE TABLE t1 (a INT);

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

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

INSERT INTO t2 VALUES (1,1),(2,2);

SELECT a FROM t2 WHERE a > 2;

SELECT * FROM t2;

SELECT * FROM t1 LEFT JOIN t2 USING (a);

mariadbd: /test/13.1_dbg/sql/ha_partition.cc:7464: bool ha_partition::can_skip_merging_scans(): Assertion `0' failed.

Core was generated by `/test/MD101126-mariadb-13.2.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --loo'.

Program terminated with signal SIGABRT, Aborted.

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

[Current thread is 1 (LWP 542417)]

(gdb) bt

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

#1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78

#2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89

#3  0x00007dd46664527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26

#4  0x00007dd4666288ff in __GI_abort () at ./stdlib/abort.c:79

#5  0x00007dd46662881b in __assert_fail_base (fmt=0x7dd4667d1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5c05839bbcc9 "0", file=file@entry=0x5c05839df3a2 "/test/13.1_dbg/sql/ha_partition.cc", line=line@entry=7464, function=function@entry=0x5c05839e0529 "bool ha_partition::can_skip_merging_scans()") at ./assert/assert.c:96

#6  0x00007dd46663b517 in __assert_fail (assertion=0x5c05839bbcc9 "0", file=0x5c05839df3a2 "/test/13.1_dbg/sql/ha_partition.cc", line=7464, function=0x5c05839e0529 "bool ha_partition::can_skip_merging_scans()")at ./assert/assert.c:105

#7  0x00005c0582fb18f0 in ha_partition::can_skip_merging_scans (this=0x75d3700838d0) at /test/13.1_dbg/sql/ha_partition.cc:7464

#8  0x00005c0582fb16c8 in ha_partition::multi_range_read_next (this=0x75d3700838d0, range_info=0x75d37008c9c0)at /test/13.1_dbg/sql/ha_partition.cc:6869

#9  0x00005c0582a49823 in JOIN_TAB_SCAN_MRR::next (this=0x75d370022600)at /test/13.1_dbg/sql/sql_join_cache.cc:4069

#10 0x00005c0582a4731e in JOIN_CACHE::join_matching_records (this=0x75d37008c8a0, skip_last=false)at /test/13.1_dbg/sql/sql_join_cache.cc:2368

#11 0x00005c0582a46ef9 in JOIN_CACHE::join_records (this=0x75d37008c8a0, skip_last=false) at /test/13.1_dbg/sql/sql_join_cache.cc:2180

#12 0x00005c05828ce7b7 in sub_select_cache (join=0x75d37001cf60, join_tab=0x75d3700209e8, end_of_records=true)at /test/13.1_dbg/sql/sql_select.cc:25270

#13 0x00005c058288574b in sub_select (join=0x75d37001cf60, join_tab=0x75d370020570, end_of_records=true)at /test/13.1_dbg/sql/sql_select.cc:25460

#14 0x00005c05828a9998 in do_select (join=0x75d37001cf60, procedure=0x0)at /test/13.1_dbg/sql/sql_select.cc:25040

#15 0x00005c05828a8e77 in JOIN::exec_inner (this=0x75d37001cf60)at /test/13.1_dbg/sql/sql_select.cc:5172

#16 0x00005c05828a8193 in JOIN::exec (this=0x75d37001cf60)at /test/13.1_dbg/sql/sql_select.cc:4960

#17 0x00005c058288623b in mysql_select (thd=0x75d370000d60, tables=0x75d37001ae00, fields=@0x75d37001aa18: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x75d37001ad90, last = 0x75d37001dfa0, elements = 2}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2164525824, result=0x75d37001cf30, unit=0x75d3700055a0, select_lex=0x75d37001a760) at /test/13.1_dbg/sql/sql_select.cc:5380

#18 0x00005c0582885d9d in handle_select (thd=0x75d370000d60, lex=0x75d370005210, result=0x75d37001cf30, setup_tables_done_option=0)at /test/13.1_dbg/sql/sql_select.cc:652

#19 0x00005c0582829e5c in execute_sqlcom_select (thd=0x75d370000d60, all_tables=0x75d37001ae00) at /test/13.1_dbg/sql/sql_parse.cc:6273

#20 0x00005c05828200cb in mysql_execute_command (thd=0x75d370000d60, is_called_from_prepared_stmt=false) at /test/13.1_dbg/sql/sql_parse.cc:4044

#21 0x00005c0582818d38 in mysql_parse (thd=0x75d370000d60, rawbuf=0x75d37001a6b0 "SELECT * FROM t1 LEFT JOIN t2 USING (a)", length=39, parser_state=0x7dd44012f9c0)at /test/13.1_dbg/sql/sql_parse.cc:8020

#22 0x00005c05828164ee in dispatch_command (command=COM_QUERY, thd=0x75d370000d60, packet=0x75d37000b6a1 "", packet_length=39, blocking=true) at /test/13.1_dbg/sql/sql_parse.cc:1903

#23 0x00005c05828197ba in do_command (thd=0x75d370000d60, blocking=true)at /test/13.1_dbg/sql/sql_parse.cc:1437

#24 0x00005c05829f69ce in do_handle_one_connection (connect=0x5c05ab4c08c0, put_in_cache=true) at /test/13.1_dbg/sql/sql_connect.cc:1529

#25 0x00005c05829f67b1 in handle_one_connection (arg=0x5c05ab564140)at /test/13.1_dbg/sql/sql_connect.cc:1441

#26 0x00007dd46669cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447

#27 0x00007dd466729ecc in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

    Rel    o/d  Build   Commit                                    UniqueID observed             

CS  10.11  dbg  101126  40e829509c789d7ae404000c81303ffa735f59f1  No bug found                  

CS  10.11  opt  101126  40e829509c789d7ae404000c81303ffa735f59f1  No bug found                  

CS  11.4   dbg  101126  707efb615611d7d56153cee6747d060ab91bf8a3  bit < map->n_bits|SIGABRT|bitmap_is_set|ha_partition::handle_ordered_index_scan|ha_partition::multi_range_read_next|JOIN_TAB_SCAN_MRR::next

CS  11.4   opt  101126  707efb615611d7d56153cee6747d060ab91bf8a3  No bug found                  

CS  11.8   dbg  101126  e1b4f63b099fad09649878e168f110a18253e68a  bit < map->n_bits|SIGABRT|bitmap_is_set|ha_partition::handle_ordered_index_scan|ha_partition::multi_range_read_next|JOIN_TAB_SCAN_MRR::next

CS  11.8   opt  101126  e1b4f63b099fad09649878e168f110a18253e68a  No bug found                  

CS  12.3   dbg  101126  691265a82e526e336e56c32fc8a98a74eea544f7  0|SIGABRT|ha_partition::can_skip_merging_scans|ha_partition::multi_range_read_next|JOIN_TAB_SCAN_MRR::next|JOIN_CACHE::join_matching_records

CS  12.3   opt  101126  691265a82e526e336e56c32fc8a98a74eea544f7  No bug found                  

CS  13.0   dbg  101126  620a4b5624222048fece7fe1789978ae0675cae2  0|SIGABRT|ha_partition::can_skip_merging_scans|ha_partition::multi_range_read_next|JOIN_TAB_SCAN_MRR::next|JOIN_CACHE::join_matching_records

CS  13.0   opt  101126  620a4b5624222048fece7fe1789978ae0675cae2  No bug found                  

CS  13.2   dbg  101126  fb47ec835c4e48c181b5e4402dc3846b65496240  0|SIGABRT|ha_partition::can_skip_merging_scans|ha_partition::multi_range_read_next|JOIN_TAB_SCAN_MRR::next|JOIN_CACHE::join_matching_records

CS  13.2   opt  101126  fb47ec835c4e48c181b5e4402dc3846b65496240  No bug found                  

ES  10.6   dbg  101126  228f96588d91fcec8428b5d7f6c53627ef93b48a  No bug found                  

ES  10.6   opt  101126  228f96588d91fcec8428b5d7f6c53627ef93b48a  No bug found                  

ES  11.4   dbg  101126  d39d6bbe10b7c9401ac02eb82668dbccd04d41ba  bit < map->n_bits|SIGABRT|bitmap_is_set|ha_partition::handle_ordered_index_scan|ha_partition::multi_range_read_next|JOIN_TAB_SCAN_MRR::next

ES  11.4   opt  101126  d39d6bbe10b7c9401ac02eb82668dbccd04d41ba  No bug found                  

ES  11.8   dbg  101126  fb7fd3f6cda7a76e93fb0d4ebf97b1ad1ebfb823  bit < map->n_bits|SIGABRT|bitmap_is_set|ha_partition::handle_ordered_index_scan|ha_partition::multi_range_read_next|JOIN_TAB_SCAN_MRR::next

ES  11.8   opt  101126  fb7fd3f6cda7a76e93fb0d4ebf97b1ad1ebfb823  No bug found                  

ES  12.3   dbg  101126  167b8d5c73897dfb38cc959dafadaeac5068734f  0|SIGABRT|ha_partition::can_skip_merging_scans|ha_partition::multi_range_read_next|JOIN_TAB_SCAN_MRR::next|JOIN_CACHE::join_matching_records

ES  12.3   opt  101126  167b8d5c73897dfb38cc959dafadaeac5068734f  No bug found