Assertion `!check_interleaving_with_nj(s)' failed in bool get_costs_for_tables(JOIN *, table_map, uint, double, Json_writer_object *, JOIN_TAB **, SORT_POSITION **, table_map *, bool)

--source include/have_innodb.inc

CREATE TABLE t (id INT,val INT) ENGINE=INNODB;

SET sql_select_limit=3;

SET optimizer_search_depth=1;

SET optimizer_join_limit_pref_ratio=1;

SELECT * FROM t AS ta LEFT JOIN (SELECT * FROM t AS tb1 JOIN t AS tb2 USING (id,val)) AS tb ON tb.id>ta.id ORDER BY ta.val;

mariadbd: /test/11.8_dbg/sql/sql_select.cc:11481: bool get_costs_for_tables(JOIN *, table_map, uint, double, Json_writer_object *, JOIN_TAB **, SORT_POSITION **, table_map *, bool): Assertion `!check_interleaving_with_nj(s)' failed.

Core was generated by `/test/MD220425-mariadb-11.8.1-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.

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 (Thread 0xf0f0c1ff6c0 (LWP 4011298))]

(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  0x00000f0f1244527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26

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

#5  0x00000f0f1242881b in __assert_fail_base (fmt=0xf0f125d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x651b17814870 "!check_interleaving_with_nj(s)", file=file@entry=0x651b17810169 "/test/11.8_dbg/sql/sql_select.cc", line=line@entry=11481, function=function@entry=0x651b1781488f "bool get_costs_for_tables(JOIN *, table_map, uint, double, Json_writer_object *, JOIN_TAB **, SORT_POSITION **, table_map *, bool)") at ./assert/assert.c:96

#6  0x00000f0f1243b517 in __assert_fail (assertion=0x651b17814870 "!check_interleaving_with_nj(s)", file=0x651b17810169 "/test/11.8_dbg/sql/sql_select.cc", line=11481, function=0x651b1781488f "bool get_costs_for_tables(JOIN *, table_map, uint, double, Json_writer_object *, JOIN_TAB **, SORT_POSITION **, table_map *, bool)") at ./assert/assert.c:105

#7  0x0000651b16896358 in get_costs_for_tables (join=0xf0eac01f3e8, remaining_tables=7, idx=0, record_count=1, trace_one_table=0xf0f0c1faf38, pos=0xf0eac085cd0, store_position=0xf0f0c1fae38, allowed_tables=0xf0f0c1fae08, stop_on_eq_ref=false)at /test/11.8_dbg/sql/sql_select.cc:11481

#8  0x0000651b16894b8d in best_extension_by_limited_search (join=0xf0eac01f3e8, remaining_tables=7, idx=0, record_count=1, read_time=0, search_depth=1, use_cond_selectivity=4, processed_eq_ref_tables=0xf0f0c1faff8)at /test/11.8_dbg/sql/sql_select.cc:12060

#9  0x0000651b1686d471 in greedy_search (join=0xf0eac01f3e8, remaining_tables=7, search_depth=1, use_cond_selectivity=4)at /test/11.8_dbg/sql/sql_select.cc:10716

#10 0x0000651b1686bed4 in choose_plan (join=0xf0eac01f3e8, join_tables=7, emb_sjm_nest=0x0) at /test/11.8_dbg/sql/sql_select.cc:10225

#11 0x0000651b1684c843 in make_join_statistics (join=0xf0eac01f3e8, tables_list=@0xf0eac01a0d8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0xf0eac0212f0, last = 0xf0eac0202b0, elements = 3}, <No data fields>}, keyuse_array=0xf0eac01f748) at /test/11.8_dbg/sql/sql_select.cc:6343

#12 0x0000651b16846327 in JOIN::optimize_inner (this=0xf0eac01f3e8)at /test/11.8_dbg/sql/sql_select.cc:2711

#13 0x0000651b16841698 in JOIN::optimize (this=0xf0eac01f3e8)at /test/11.8_dbg/sql/sql_select.cc:1994

#14 0x0000651b16839629 in mysql_select (thd=0xf0eac000d58, tables=0xf0eac01a520, fields=@0xf0eac01a178: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0xf0eac01a4b8, last = 0xf0eac021580, elements = 2}, <No data fields>}, conds=0x0, og_num=2, order=0xf0eac01f048, group=0x0, having=0x0, proc_param=0x0, select_options=2164525824, result=0xf0eac01f3c0, unit=0xf0eac005080, select_lex=0xf0eac019ec0)at /test/11.8_dbg/sql/sql_select.cc:5361

#15 0x0000651b16839165 in handle_select (thd=0xf0eac000d58, lex=0xf0eac004fa0, result=0xf0eac01f3c0, setup_tables_done_option=0)at /test/11.8_dbg/sql/sql_select.cc:633

#16 0x0000651b167e0f61 in execute_sqlcom_select (thd=0xf0eac000d58, all_tables=0xf0eac01a520) at /test/11.8_dbg/sql/sql_parse.cc:6191

#17 0x0000651b167d5e40 in mysql_execute_command (thd=0xf0eac000d58, is_called_from_prepared_stmt=false) at /test/11.8_dbg/sql/sql_parse.cc:3979

#18 0x0000651b167cdf64 in mysql_parse (thd=0xf0eac000d58, rawbuf=0xf0eac019d20 "SELECT t1a.* FROM t1  AS t1a LEFT OUTER JOIN (SELECT * FROM t1  AS t1b1 INNER JOIN t1 AS t1b2 USING (id, val)) AS t1b ON t1b.id > t1a.id ORDER BY t1a.val, t1a.id", length=161, parser_state=0xf0f0c1fda20)at /test/11.8_dbg/sql/sql_parse.cc:7915

#19 0x0000651b167cb334 in dispatch_command (command=COM_QUERY, thd=0xf0eac000d58, packet=0xf0eac00b099 "SELECT t1a.* FROM t1  AS t1a LEFT OUTER JOIN (SELECT * FROM t1  AS t1b1 INNER JOIN t1 AS t1b2 USING (id, val)) AS t1b ON t1b.id > t1a.id ORDER BY t1a.val, t1a.id", packet_length=161, blocking=true)at /test/11.8_dbg/sql/sql_parse.cc:1902

#20 0x0000651b167ceb13 in do_command (thd=0xf0eac000d58, blocking=true)at /test/11.8_dbg/sql/sql_parse.cc:1415

#21 0x0000651b169b8359 in do_handle_one_connection (connect=0x651b4613bf98, put_in_cache=true) at /test/11.8_dbg/sql/sql_connect.cc:1415

#22 0x0000651b169b80fe in handle_one_connection (arg=0x651b461551a8)at /test/11.8_dbg/sql/sql_connect.cc:1327

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

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

    Rel    o/d  Build   Commit                                    UniqueID observed             

CS  10.5   dbg  210425  952ffb55f93bf6a6c5d1c9617e5a2a56207ee674  No bug found                  

CS  10.5   opt  210425  952ffb55f93bf6a6c5d1c9617e5a2a56207ee674  No bug found                  

CS  10.6   dbg  220425  a135551569d8901fbdb7859bd209fa4894d88471  join->best_read < 1.7976931348623157e+308|SIGABRT|greedy_search|choose_plan|make_join_statistics|JOIN::optimize_inner                 

CS  10.6   opt  220425  a135551569d8901fbdb7859bd209fa4894d88471  No bug found                  

CS  10.11  dbg  210425  7d9660ed93c6bcf56a6dafd0872b27ac1709778a  !check_interleaving_with_nj(s)|SIGABRT|get_costs_for_tables|best_extension_by_limited_search|greedy_search|choose_plan

CS  10.11  opt  210425  7d9660ed93c6bcf56a6dafd0872b27ac1709778a  No bug found                  

CS  11.4   dbg  220425  820114bd2515759224f925528c8201e6155334fb  !check_interleaving_with_nj(s)|SIGABRT|get_costs_for_tables|best_extension_by_limited_search|greedy_search|choose_plan

CS  11.4   opt  220425  820114bd2515759224f925528c8201e6155334fb  No bug found                  

CS  11.8   dbg  220425  805e7ca3adef50e17889ea17a1b86da6c3fb8580  !check_interleaving_with_nj(s)|SIGABRT|get_costs_for_tables|best_extension_by_limited_search|greedy_search|choose_plan

CS  11.8   opt  220425  805e7ca3adef50e17889ea17a1b86da6c3fb8580  No bug found                  

CS  12.0   dbg  220425  ddfebd48f58678ff31427f7f7d971981e2d098ec  !check_interleaving_with_nj(s)|SIGABRT|get_costs_for_tables|best_extension_by_limited_search|greedy_search|choose_plan

CS  12.0   opt  220425  ddfebd48f58678ff31427f7f7d971981e2d098ec  No bug found                  

ES  10.5   dbg  170325  e99e19fae843c6ab174d0793e82b76bf6d980147  No bug found                  

ES  10.5   opt  170325  e99e19fae843c6ab174d0793e82b76bf6d980147  No bug found                  

ES  10.6   dbg  170325  ee1d68c27bc578f7750b898d7c65acfec33dc30b  join->best_read < 1.7976931348623157e+308|SIGABRT|greedy_search|choose_plan|make_join_statistics|JOIN::optimize_inner

ES  10.6   opt  170325  ee1d68c27bc578f7750b898d7c65acfec33dc30b  No bug found                  

ES  11.4   dbg  170325  c623275dc5fb705004d716e4c32386cf89649b9d  !check_interleaving_with_nj(s)|SIGABRT|get_costs_for_tables|best_extension_by_limited_search|greedy_search|choose_plan

ES  11.4   opt  170325  c623275dc5fb705004d716e4c32386cf89649b9d  No bug found                  

ES         dbg  160124  38aeb92abf07752f87a77362b408ad43af7d0965  No bug found