Assertion `optimization_state == OPTIMIZATION_DONE' failed in int JOIN::exec()

CREATE TABLE t (f TIMESTAMP) ENGINE=MYISAM;

SELECT f FROM t WHERE f<ALL (SELECT 1 WHERE 0);

Core was generated by `/test/MD121225-mariadb-12.3.0-linux-x86_64-opt/bin/mariadbd --no-defaults --max'.

Program terminated with signal SIGSEGV, Segmentation fault.

#0  Time_and_counter_tracker::incr_loops (this=0xb8)at /test/12.3_opt/sql/sql_analyze_stmt.h:172

[Current thread is 1 (LWP 671600)]

(gdb) bt

#0  Time_and_counter_tracker::incr_loops (this=0xb8)at /test/12.3_opt/sql/sql_analyze_stmt.h:172

#1  JOIN::exec (this=0x71da6001ab28) at /test/12.3_opt/sql/sql_select.cc:4921

#2  0x00005f74a9bd7cb0 in subselect_single_select_engine::exec (this=0x71da60019748) at /test/12.3_opt/sql/item_subselect.cc:4201

#3  0x00005f74a9bcf38c in Item_subselect::exec (this=0x71da6001c9a0)at /test/12.3_opt/sql/item_subselect.cc:813

#4  0x00005f74a9bd0cfc in Item_singlerow_subselect::get_date (this=0x71da6001c9a0, thd=0x71da60000c68, ltime=0x71db58304f00, fuzzydate={m_mode = (date_mode_t::FRAC_TRUNCATE | date_mode_t::NO_ZERO_IN_DATE)}) at /test/12.3_opt/sql/item_subselect.cc:1590

#5  0x00005f74a9a3c06e in Temporal_with_date::make_from_item (this=0x71db58304f00, thd=0x71da60000c68, item=0x71da6001c9a0, fuzzydate=<optimized out>) at /test/12.3_opt/sql/sql_type.cc:1046

#6  Temporal_with_date::Temporal_with_date (this=0x71db58304f00, thd=0x71da60000c68, item=0x71da6001c9a0, fuzzydate=<optimized out>)at /test/12.3_opt/sql/sql_type.h:2229

#7  Datetime::Datetime (this=0x71db58304f00, thd=0x71da60000c68, item=0x71da6001c9a0, fuzzydate=<optimized out>)at /test/12.3_opt/sql/sql_type.h:2515

#8  Type_handler_datetime_common::convert_item_for_comparison (this=<optimized out>, thd=0x71da60000c68, subject=0x71da6001c9a0, counterpart=<optimized out>) at /test/12.3_opt/sql/sql_type.cc:7835

#9  0x00005f74a9b2e6df in Item_func::aggregate_args2_for_comparison_with_conversion (this=this@entry=0x71da6001cb70, thd=thd@entry=0x71da60000c68, th=th@entry=0x71db58304ff8) at /test/12.3_opt/sql/item_cmpfunc.cc:433

#10 0x00005f74a9b2e9f5 in Item_bool_rowready_func2::fix_length_and_dec (this=0x71da6001cb70, thd=0x71da60000c68)at /test/12.3_opt/sql/item_cmpfunc.cc:526

#11 0x00005f74a9b647bb in Item_func::fix_fields (this=0x71da6001cb70, thd=0x71da60000c68, ref=<optimized out>)at /test/12.3_opt/sql/item_func.cc:412

#12 0x00005f74a9bd21b5 in Item_allany_subselect::transform_into_max_min (this=0x71da600194f8, join=<optimized out>)at /test/12.3_opt/sql/item_subselect.cc:2280

#13 0x00005f74a98b5a0b in JOIN::optimize_inner (this=0x71da6001ab28)at /test/12.3_opt/sql/sql_select.cc:2300

#14 0x00005f74a98b5719 in JOIN::optimize (this=0x71da6001ab28)at /test/12.3_opt/sql/sql_select.cc:2025

#15 0x00005f74a9bd7b0a in subselect_single_select_engine::exec (this=0x71da60019748) at /test/12.3_opt/sql/item_subselect.cc:4117

#16 0x00005f74a9bcf760 in Item_subselect::exec (this=0x71da600194f8)at /test/12.3_opt/sql/item_subselect.cc:813

#17 Item_in_subselect::exec (this=0x71da600194f8)at /test/12.3_opt/sql/item_subselect.cc:995

#18 0x00005f74a9bd1ce1 in Item_in_subselect::val_bool (this=0x71da6001ab28)at /test/12.3_opt/sql/item_subselect.cc:2011

#19 0x00005f74a9b31e97 in Item_in_optimizer::val_bool (this=0x71da6001b1a8)at /test/12.3_opt/sql/item_cmpfunc.cc:1781

#20 0x00005f74a9b2e0ac in Item_func_not_all::val_bool (this=0x71da60019788)at /test/12.3_opt/sql/item_cmpfunc.cc:218

#21 0x00005f74a98e03cf in Item::eval_const_cond (this=0x71da60019788)at /test/12.3_opt/sql/item.h:1730

#22 Item::remove_eq_conds (this=0x71da60019788, thd=<optimized out>, cond_value=0x71da6001a5f0, top_level_arg=<optimized out>)at /test/12.3_opt/sql/sql_select.cc:21273

#23 0x00005f74a98bbb68 in make_join_statistics (join=join@entry=0x71da6001a260, tables_list=@0x71da600179b0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x71da6001aa18, last = 0x71da6001aa18, elements = 1}, <No data fields>}, keyuse_array=keyuse_array@entry=0x71da6001a5b8)at /test/12.3_opt/sql/sql_select.cc:6123

#24 0x00005f74a98b6c10 in JOIN::optimize_inner (this=this@entry=0x71da6001a260)at /test/12.3_opt/sql/sql_select.cc:2772

#25 0x00005f74a98af625 in JOIN::optimize (this=0x71da6001a260)at /test/12.3_opt/sql/sql_select.cc:2025

#26 mysql_select (thd=thd@entry=0x71da60000c68, tables=<optimized out>, fields=@0x71da60017a50: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x71da60017da0, last = 0x71da60017da0, elements = 1}, <No data fields>}, conds=<optimized out>, og_num=<optimized out>, order=<optimized out>, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x71da6001a238, unit=0x71da600050b0, select_lex=0x71da60017798)at /test/12.3_opt/sql/sql_select.cc:5436

#27 0x00005f74a98af279 in handle_select (thd=thd@entry=0x71da60000c68, lex=lex@entry=0x71da60004fd0, result=result@entry=0x71da6001a238, setup_tables_done_option=setup_tables_done_option@entry=0)at /test/12.3_opt/sql/sql_select.cc:636

#28 0x00005f74a987cbb7 in execute_sqlcom_select (thd=thd@entry=0x71da60000c68, all_tables=0x71da60017df0) at /test/12.3_opt/sql/sql_parse.cc:6172

#29 0x00005f74a987b6bc in mysql_execute_command (thd=thd@entry=0x71da60000c68, is_called_from_prepared_stmt=false) at /test/12.3_opt/sql/sql_parse.cc:3951

#30 0x00005f74a9873a61 in mysql_parse (thd=thd@entry=0x71da60000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x71db583064e0)at /test/12.3_opt/sql/sql_parse.cc:7895

#31 0x00005f74a9871f7c in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x71da60000c68, packet=packet@entry=0x71da60008a39 "SELECT f FROM t WHERE f<ALL (SELECT 1 WHERE 0)", packet_length=packet_length@entry=46, blocking=true)at /test/12.3_opt/sql/sql_parse.cc:1878

#32 0x00005f74a9873e71 in do_command (thd=thd@entry=0x71da60000c68, blocking=true) at /test/12.3_opt/sql/sql_parse.cc:1417

#33 0x00005f74a999f21d in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5f74b6b01dd8, put_in_cache=true)at /test/12.3_opt/sql/sql_connect.cc:1503

#34 0x00005f74a999efdf in handle_one_connection (arg=arg@entry=0x5f74b6b01dd8)at /test/12.3_opt/sql/sql_connect.cc:1415

#35 0x00005f74a9d58179 in pfs_spawn_thread (arg=0x5f74b6b2c998)at /test/12.3_opt/storage/perfschema/pfs.cc:2198

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

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

mariadbd: /test/12.3_dbg/sql/sql_select.cc:4914: int JOIN::exec(): Assertion `optimization_state == OPTIMIZATION_DONE' failed.

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

Program terminated with signal SIGABRT, Aborted.

Download failed: Invalid argument.  Continuing without source file ./nptl/./nptl/pthread_kill.c.

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

[Current thread is 1 (LWP 671586)]

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

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

#5  0x000077439862881b in __assert_fail_base (fmt=0x7743987d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x584d9c5f3fe2 "optimization_state == OPTIMIZATION_DONE", file=file@entry=0x584d9c5f3556 "/test/12.3_dbg/sql/sql_select.cc", line=line@entry=4914, function=function@entry=0x584d9c5f400a "int JOIN::exec()")at ./assert/assert.c:96

#6  0x000077439863b517 in __assert_fail (assertion=0x584d9c5f3fe2 "optimization_state == OPTIMIZATION_DONE", file=0x584d9c5f3556 "/test/12.3_dbg/sql/sql_select.cc", line=4914, function=0x584d9c5f400a "int JOIN::exec()") at ./assert/assert.c:105

#7  0x0000584d9b5a3b37 in JOIN::exec (this=0x77428c01d338)at /test/12.3_dbg/sql/sql_select.cc:4914

#8  0x0000584d9baa7a8c in subselect_single_select_engine::exec (this=0x77428c01bf48) at /test/12.3_dbg/sql/item_subselect.cc:4201

#9  0x0000584d9ba9805d in Item_subselect::exec (this=0x77428c01f1f0)at /test/12.3_dbg/sql/item_subselect.cc:813

#10 0x0000584d9ba9ad08 in Item_singlerow_subselect::get_date (this=0x77428c01f1f0, thd=0x77428c000d58, ltime=0x77439412b4c8, fuzzydate={m_mode = (date_mode_t::FRAC_TRUNCATE | date_mode_t::NO_ZERO_IN_DATE)}) at /test/12.3_dbg/sql/item_subselect.cc:1590

#11 0x0000584d9b7ea4b6 in Temporal_with_date::make_from_item (this=0x77439412b4c8, thd=0x77428c000d58, item=0x77428c01f1f0, fuzzydate={m_mode = (date_mode_t::FRAC_TRUNCATE | date_mode_t::NO_ZERO_IN_DATE)}) at /test/12.3_dbg/sql/sql_type.cc:1046

#12 0x0000584d9b36ee71 in Temporal_with_date::Temporal_with_date (this=0x77439412b4c8, thd=0x77428c000d58, item=0x77428c01f1f0, fuzzydate={m_mode = (date_mode_t::FRAC_TRUNCATE | date_mode_t::NO_ZERO_IN_DATE)}) at /test/12.3_dbg/sql/sql_type.h:2229

#13 0x0000584d9b36eb45 in Datetime::Datetime (this=0x77439412b4c8, thd=0x77428c000d58, item=0x77428c01f1f0, fuzzydate={m_mode = (date_mode_t::FRAC_TRUNCATE | date_mode_t::NO_ZERO_IN_DATE)}) at /test/12.3_dbg/sql/sql_type.h:2515

#14 0x0000584d9b800b17 in Type_handler_datetime_common::convert_item_for_comparison (this=0x584d9d29d820 <type_handler_datetime>, thd=0x77428c000d58, subject=0x77428c01f1f0, counterpart=0x77428c01db60)at /test/12.3_dbg/sql/sql_type.cc:7835

#15 0x0000584d9b9aec7c in Item_func::aggregate_args2_for_comparison_with_conversion (this=0x77428c01f3c0, thd=0x77428c000d58, th=0x77439412b628)at /test/12.3_dbg/sql/item_cmpfunc.cc:433

#16 0x0000584d9b9af165 in Item_bool_rowready_func2::fix_length_and_dec (this=0x77428c01f3c0, thd=0x77428c000d58)at /test/12.3_dbg/sql/item_cmpfunc.cc:526

#17 0x0000584d9b9f8dba in Item_func::fix_fields (this=0x77428c01f3c0, thd=0x77428c000d58, ref=0x77439412b9b0)at /test/12.3_dbg/sql/item_func.cc:412

#18 0x0000584d9ba9dd54 in Item_allany_subselect::transform_into_max_min (this=0x77428c01bcf8, join=0x77428c01d338)at /test/12.3_dbg/sql/item_subselect.cc:2280

#19 0x0000584d9b76c053 in JOIN::transform_max_min_subquery (this=0x77428c01d338) at /test/12.3_dbg/sql/opt_subselect.cc:1003

#20 0x0000584d9b586d32 in JOIN::optimize_inner (this=0x77428c01d338)at /test/12.3_dbg/sql/sql_select.cc:2300

#21 0x0000584d9b5867ed in JOIN::optimize (this=0x77428c01d338)at /test/12.3_dbg/sql/sql_select.cc:2025

#22 0x0000584d9baa75f9 in subselect_single_select_engine::exec (this=0x77428c01bf48) at /test/12.3_dbg/sql/item_subselect.cc:4117

#23 0x0000584d9ba9805d in Item_subselect::exec (this=0x77428c01bcf8)at /test/12.3_dbg/sql/item_subselect.cc:813

#24 0x0000584d9ba98729 in Item_in_subselect::exec (this=0x77428c01bcf8)at /test/12.3_dbg/sql/item_subselect.cc:995

#25 0x0000584d9ba9caf4 in Item_in_subselect::val_bool (this=0x77428c01bcf8)at /test/12.3_dbg/sql/item_subselect.cc:2011

#26 0x0000584d9b36c639 in Item::val_bool_result (this=0x77428c01bcf8)at /test/12.3_dbg/sql/item.h:1821

#27 0x0000584d9b9b3bf6 in Item_in_optimizer::val_bool (this=0x77428c01d9c0)at /test/12.3_dbg/sql/item_cmpfunc.cc:1781

#28 0x0000584d9b9ae098 in Item_func_not_all::val_bool (this=0x77428c01bf88)at /test/12.3_dbg/sql/item_cmpfunc.cc:218

#29 0x0000584d9b5e6fc4 in Item::eval_const_cond (this=0x77428c01bf88)at /test/12.3_dbg/sql/item.h:1730

#30 0x0000584d9b5c0cce in Item::remove_eq_conds (this=0x77428c01bf88, thd=0x77428c000d58, cond_value=0x77428c01cdf8, top_level_arg=true)at /test/12.3_dbg/sql/sql_select.cc:21273

#31 0x0000584d9b5904c5 in make_join_statistics (join=0x77428c01ca60, tables_list=@0x77428c01a1b0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x77428c01d228, last = 0x77428c01d228, elements = 1}, <No data fields>}, keyuse_array=0x77428c01cdc0) at /test/12.3_dbg/sql/sql_select.cc:6123

#32 0x0000584d9b588f1b in JOIN::optimize_inner (this=0x77428c01ca60)at /test/12.3_dbg/sql/sql_select.cc:2772

#33 0x0000584d9b5867ed in JOIN::optimize (this=0x77428c01ca60)at /test/12.3_dbg/sql/sql_select.cc:2025

#34 0x0000584d9b57e449 in mysql_select (thd=0x77428c000d58, tables=0x77428c01a5f0, fields=@0x77428c01a250: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x77428c01a5a0, last = 0x77428c01a5a0, elements = 1}, <No data fields>}, conds=0x77428c01bf88, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2164525824, result=0x77428c01ca38, unit=0x77428c005178, select_lex=0x77428c019f98)at /test/12.3_dbg/sql/sql_select.cc:5436

#35 0x0000584d9b57df85 in handle_select (thd=0x77428c000d58, lex=0x77428c005098, result=0x77428c01ca38, setup_tables_done_option=0)at /test/12.3_dbg/sql/sql_select.cc:636

#36 0x0000584d9b525691 in execute_sqlcom_select (thd=0x77428c000d58, all_tables=0x77428c01a5f0) at /test/12.3_dbg/sql/sql_parse.cc:6172

#37 0x0000584d9b51a3cc in mysql_execute_command (thd=0x77428c000d58, is_called_from_prepared_stmt=false) at /test/12.3_dbg/sql/sql_parse.cc:3951

#38 0x0000584d9b512654 in mysql_parse (thd=0x77428c000d58, rawbuf=0x77428c019ee0 "SELECT f FROM t WHERE f<ALL (SELECT 1 WHERE 0)", length=46, parser_state=0x77439412eac0)at /test/12.3_dbg/sql/sql_parse.cc:7895

#39 0x0000584d9b50fa28 in dispatch_command (command=COM_QUERY, thd=0x77428c000d58, packet=0x77428c00b239 "SELECT f FROM t WHERE f<ALL (SELECT 1 WHERE 0)", packet_length=46, blocking=true) at /test/12.3_dbg/sql/sql_parse.cc:1878

#40 0x0000584d9b513203 in do_command (thd=0x77428c000d58, blocking=true)at /test/12.3_dbg/sql/sql_parse.cc:1417

#41 0x0000584d9b701449 in do_handle_one_connection (connect=0x584db84bf9d8, put_in_cache=true) at /test/12.3_dbg/sql/sql_connect.cc:1503

#42 0x0000584d9b7011ee in handle_one_connection (arg=0x584db848d3e8)at /test/12.3_dbg/sql/sql_connect.cc:1415

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

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

    Rel    o/d  Build   Commit                                    UniqueID observed             

CS  10.6   dbg  171225  478802a8edb45886b0f105280ed613414f6a580c  No bug found                  

CS  10.6   opt  171225  478802a8edb45886b0f105280ed613414f6a580c  No bug found                  

CS  10.11  dbg  101225  ae01081bd0a2769ff3574ecc8d7f643607f6ae0c  No bug found                  

CS  10.11  dbg  121225  4ee491f1b2eb356e9dc40f388f79b62cfeb13609  No bug found                  

CS  10.11  opt  101225  ae01081bd0a2769ff3574ecc8d7f643607f6ae0c  No bug found                  

CS  10.11  opt  121225  4ee491f1b2eb356e9dc40f388f79b62cfeb13609  No bug found                  

CS  11.4   dbg  121225  4cff562f3f89d4df03e09233d835d0451bc37cc4  optimization_state == OPTIMIZATION_DONE|SIGABRT|JOIN::exec|subselect_single_select_engine::exec|Item_subselect::exec|Item_singlerow_subselect::get_date

CS  11.4   opt  121225  4cff562f3f89d4df03e09233d835d0451bc37cc4  SIGSEGV|Time_and_counter_tracker::incr_loops|JOIN::exec|subselect_single_select_engine::exec|Item_subselect::exec

CS  11.8   dbg  121225  a7528a6190807281d3224e4e67a9b76083a202a6  optimization_state == OPTIMIZATION_DONE|SIGABRT|JOIN::exec|subselect_single_select_engine::exec|Item_subselect::exec|Item_singlerow_subselect::get_date

CS  11.8   opt  121225  a7528a6190807281d3224e4e67a9b76083a202a6  SIGSEGV|Time_and_counter_tracker::incr_loops|JOIN::exec|subselect_single_select_engine::exec|Item_subselect::exec

CS  12.1   dbg  121225  70117463f032d59f8e328335e19b59157d34cf07  optimization_state == OPTIMIZATION_DONE|SIGABRT|JOIN::exec|subselect_single_select_engine::exec|Item_subselect::exec|Item_singlerow_subselect::get_date

CS  12.1   opt  121225  70117463f032d59f8e328335e19b59157d34cf07  SIGSEGV|Time_and_counter_tracker::incr_loops|JOIN::exec|subselect_single_select_engine::exec|Item_subselect::exec

CS  12.2   dbg  121225  997d0c4dfc551ea54faa1e9b7d56f3a0ff2ca849  optimization_state == OPTIMIZATION_DONE|SIGABRT|JOIN::exec|subselect_single_select_engine::exec|Item_subselect::exec|Item_singlerow_subselect::get_date

CS  12.2   opt  121225  997d0c4dfc551ea54faa1e9b7d56f3a0ff2ca849  SIGSEGV|Time_and_counter_tracker::incr_loops|JOIN::exec|subselect_single_select_engine::exec|Item_subselect::exec

CS  12.3   dbg  121225  5879c85f505d3a11d4b8f479f2437416d8a1d724  optimization_state == OPTIMIZATION_DONE|SIGABRT|JOIN::exec|subselect_single_select_engine::exec|Item_subselect::exec|Item_singlerow_subselect::get_date

CS  12.3   opt  121225  5879c85f505d3a11d4b8f479f2437416d8a1d724  SIGSEGV|Time_and_counter_tracker::incr_loops|JOIN::exec|subselect_single_select_engine::exec|Item_subselect::exec

ES  10.6   dbg  151225  bc33b05c6a65de27dbe811a30bc37c207d60ee8e  No bug found

ES  10.6   opt  151225  bc33b05c6a65de27dbe811a30bc37c207d60ee8e  No bug found

ES  11.4   dbg  151225  714f2134597e00f4ff107886cf3a55eff48e4510  optimization_state == OPTIMIZATION_DONE|SIGABRT|JOIN::exec|subselect_single_select_engine::exec|Item_subselect::exec|Item_singlerow_subselect::get_date

ES  11.4   opt  151225  714f2134597e00f4ff107886cf3a55eff48e4510  SIGSEGV|Time_and_counter_tracker::incr_loops|JOIN::exec|subselect_single_select_engine::exec|Item_subselect::exec

ES  11.8   dbg  151225  4008de1a5b06105a64821db7b851328f1b27d99e  optimization_state == OPTIMIZATION_DONE|SIGABRT|JOIN::exec|subselect_single_select_engine::exec|Item_subselect::exec|Item_singlerow_subselect::get_date

ES  11.8   opt  151225  4008de1a5b06105a64821db7b851328f1b27d99e  SIGSEGV|Time_and_counter_tracker::incr_loops|JOIN::exec|subselect_single_select_engine::exec|Item_subselect::exec