Details
Description
--source include/have_innodb.inc
|
CREATE TABLE t (c INT) ENGINE=InnoDB; |
SELECT STRAIGHT_JOIN * FROM t WHERE -c GROUP BY c HAVING c IN (TRUE); |
Leads to:
CS 12.1.2 033471a367b4c60b7262e64f43f46b02e95b9d74 (Debug, Clang 18.1.3-1) Build 08/08/2025 |
mariadbd: /test/12.1_dbg/sql/item_func.h:988: virtual longlong Item_func_hybrid_field_type::val_int(): Assertion `!is_cond()' failed.
|
CS 12.1.2 033471a367b4c60b7262e64f43f46b02e95b9d74 (Debug, Clang 18.1.3-1) Build 08/08/2025 |
Core was generated by `/test/MD080825-mariadb-12.1.2-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 1123737)]
|
(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 0x0000724055a4526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x0000724055a288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x0000724055a2881b in __assert_fail_base (fmt=0x724055bd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x63f90fe7be12 "!is_cond()", file=file@entry=0x63f90fd728b4 "/test/12.1_dbg/sql/item_func.h", line=line@entry=988, function=function@entry=0x63f90fdf03fa "virtual longlong Item_func_hybrid_field_type::val_int()") at ./assert/assert.c:94
|
#6 0x0000724055a3b507 in __assert_fail (assertion=0x63f90fe7be12 "!is_cond()", file=0x63f90fd728b4 "/test/12.1_dbg/sql/item_func.h", line=988, function=0x63f90fdf03fa "virtual longlong Item_func_hybrid_field_type::val_int()") at ./assert/assert.c:103
|
#7 0x000063f91060c1db in Item_func_hybrid_field_type::val_int (this=0x723f4801ae30) at /test/12.1_dbg/sql/item_func.h:988
|
#8 0x000063f91052ee39 in Item::val_int_result (this=0x723f4801ae30)at /test/12.1_dbg/sql/item.h:1810
|
#9 0x000063f9105f6614 in Item_cache_int::cache_value (this=0x723f4801fac0)at /test/12.1_dbg/sql/item.cc:10889
|
#10 0x000063f9105ffc4e in Item_cache::has_value (this=0x723f4801fac0)at /test/12.1_dbg/sql/item.h:7773
|
#11 0x000063f9105f67d9 in Item_cache_int::val_int (this=0x723f4801fac0)at /test/12.1_dbg/sql/item.cc:10924
|
#12 0x000063f910d3cad3 in Type_handler_int_result::Item_val_bool (this=0x63f911bddec8 <type_handler_slonglong>, item=0x723f4801fac0)at /test/12.1_dbg/sql/sql_type.cc:5259
|
#13 0x000063f91060044d in Item::val_bool (this=0x723f4801fac0)at /test/12.1_dbg/sql/item.h:1699
|
#14 0x000063f910a8c307 in make_join_select (join=0x723f4801be40, select=0x723f4801f650, cond=0x723f4801d118)at /test/12.1_dbg/sql/sql_select.cc:14365
|
#15 0x000063f910a7fa8a in JOIN::optimize_stage2 (this=0x723f4801be40)at /test/12.1_dbg/sql/sql_select.cc:3036
|
#16 0x000063f910a83a9e in JOIN::optimize_inner (this=0x723f4801be40)at /test/12.1_dbg/sql/sql_select.cc:2769
|
#17 0x000063f910a7ebf8 in JOIN::optimize (this=0x723f4801be40)at /test/12.1_dbg/sql/sql_select.cc:2023
|
#18 0x000063f910a76849 in mysql_select (thd=0x723f48000d58, tables=0x723f4801a5b8, fields=@0x723f4801a220: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x723f4801a568, last = 0x723f4801a568, elements = 1}, <No data fields>}, conds=0x723f4801ae30, og_num=1, order=0x0, group=0x723f4801b030, having=0x723f4801b228, proc_param=0x0, select_options=2164525826, result=0x723f4801be18, unit=0x723f48005158, select_lex=0x723f48019f68)at /test/12.1_dbg/sql/sql_select.cc:5388
|
#19 0x000063f910a76385 in handle_select (thd=0x723f48000d58, lex=0x723f48005078, result=0x723f4801be18, setup_tables_done_option=0)at /test/12.1_dbg/sql/sql_select.cc:634
|
#20 0x000063f910a1a4d1 in execute_sqlcom_select (thd=0x723f48000d58, all_tables=0x723f4801a5b8) at /test/12.1_dbg/sql/sql_parse.cc:6167
|
#21 0x000063f910a0f25e in mysql_execute_command (thd=0x723f48000d58, is_called_from_prepared_stmt=false) at /test/12.1_dbg/sql/sql_parse.cc:3950
|
#22 0x000063f910a07524 in mysql_parse (thd=0x723f48000d58, rawbuf=0x723f48019e80 "SELECT STRAIGHT_JOIN * FROM t WHERE -c GROUP BY c HAVING c IN (TRUE)", length=68, parser_state=0x72404fffda10)at /test/12.1_dbg/sql/sql_parse.cc:7883
|
#23 0x000063f910a048f8 in dispatch_command (command=COM_QUERY, thd=0x723f48000d58, packet=0x723f4800b1f9 "SELECT STRAIGHT_JOIN * FROM t WHERE -c GROUP BY c HAVING c IN (TRUE)", packet_length=68, blocking=true)at /test/12.1_dbg/sql/sql_parse.cc:1878
|
#24 0x000063f910a080d3 in do_command (thd=0x723f48000d58, blocking=true)at /test/12.1_dbg/sql/sql_parse.cc:1417
|
#25 0x000063f910c27139 in do_handle_one_connection (connect=0x63f91374dcc8, put_in_cache=true) at /test/12.1_dbg/sql/sql_connect.cc:1414
|
#26 0x000063f910c26ede in handle_one_connection (arg=0x63f913663388)at /test/12.1_dbg/sql/sql_connect.cc:1326
|
#27 0x0000724055a9ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#28 0x0000724055b29c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
Bug Detection Matrix |
Rel o/d Build Commit UniqueID observed
|
CS 10.6 dbg 080825 13f337ce1f295f4aac75db681e00c71f2bf8acaf !is_cond()|SIGABRT|Item_func_hybrid_field_type::val_int|Item::val_int_result|Item_cache_int::cache_value|Item_cache::has_value
|
CS 10.6 opt 080825 13f337ce1f295f4aac75db681e00c71f2bf8acaf No bug found
|
CS 10.11 dbg 080825 c45a34b2fb10e4e8f768e7e5fe846e9592eb6ea8 !is_cond()|SIGABRT|Item_func_hybrid_field_type::val_int|Item::val_int_result|Item_cache_int::cache_value|Item_cache::has_value
|
CS 10.11 opt 080825 c45a34b2fb10e4e8f768e7e5fe846e9592eb6ea8 No bug found
|
CS 11.4 dbg 080825 03b31c0bd99390c1984f19a19f22dd6e77b7692e !is_cond()|SIGABRT|Item_func_hybrid_field_type::val_int|Item::val_int_result|Item_cache_int::cache_value|Item_cache::has_value
|
CS 11.4 opt 080825 03b31c0bd99390c1984f19a19f22dd6e77b7692e No bug found
|
CS 11.8 dbg 080825 1a446ccc48528e88a3cd6cd1d1ec9e7492d342ca !is_cond()|SIGABRT|Item_func_hybrid_field_type::val_int|Item::val_int_result|Item_cache_int::cache_value|Item_cache::has_value
|
CS 11.8 opt 080825 1a446ccc48528e88a3cd6cd1d1ec9e7492d342ca No bug found
|
CS 12.1 dbg 080825 033471a367b4c60b7262e64f43f46b02e95b9d74 !is_cond()|SIGABRT|Item_func_hybrid_field_type::val_int|Item::val_int_result|Item_cache_int::cache_value|Item_cache::has_value
|
CS 12.1 opt 080825 033471a367b4c60b7262e64f43f46b02e95b9d74 No bug found
|
CS 12.2 dbg 080825 e02f4d7e311e214ea62ff2e59599849e229f4165 !is_cond()|SIGABRT|Item_func_hybrid_field_type::val_int|Item::val_int_result|Item_cache_int::cache_value|Item_cache::has_value
|
CS 12.2 opt 080825 e02f4d7e311e214ea62ff2e59599849e229f4165 No bug found
|
ES 10.5 dbg 080825 70586522eacf09d04d49962072e14325a75d8155 No bug found
|
ES 10.5 opt 080825 70586522eacf09d04d49962072e14325a75d8155 No bug found
|
ES 10.6 dbg 080825 9b794f34b48fb7eee490b6da44edc0f33a947447 !is_cond()|SIGABRT|Item_func_hybrid_field_type::val_int|Item::val_int_result|Item_cache_int::cache_value|Item_cache::has_value
|
ES 10.6 opt 080825 9b794f34b48fb7eee490b6da44edc0f33a947447 No bug found
|
ES 11.4 dbg 080825 a1c03ccd54b582e75506687ee19b273ca897f261 !is_cond()|SIGABRT|Item_func_hybrid_field_type::val_int|Item::val_int_result|Item_cache_int::cache_value|Item_cache::has_value
|
ES 11.4 opt 080825 a1c03ccd54b582e75506687ee19b273ca897f261 No bug found
|
ES 11.8 dbg 080825 4cdf75ab6ba37d4e7e208690785e880ed3176f2f !is_cond()|SIGABRT|Item_func_hybrid_field_type::val_int|Item::val_int_result|Item_cache_int::cache_value|Item_cache::has_value
|
ES 11.8 opt 080825 4cdf75ab6ba37d4e7e208690785e880ed3176f2f No bug found
|
MS 5.5 dbg 070123 bac287c315b1792e7ae33f91add6a60292f9bae8 No bug found
|
MS 5.5 opt 070123 bac287c315b1792e7ae33f91add6a60292f9bae8 No bug found
|
MS 5.6 dbg 070123 dab95781a1244104d6b87020ac2fc4d190ba2946 No bug found
|
MS 5.6 opt 070123 dab95781a1244104d6b87020ac2fc4d190ba2946 No bug found
|
MS 5.7 dbg 070525 f7680e98b6bbe3500399fbad465d08a6b75d7a5c No bug found
|
MS 5.7 opt 070525 f7680e98b6bbe3500399fbad465d08a6b75d7a5c No bug found
|
MS 8.0 dbg 060224 49ef33f7edadef3ae04665e73d1babd40179a4f1 No bug found
|
MS 8.0 opt 060224 49ef33f7edadef3ae04665e73d1babd40179a4f1 No bug found
|
MS 9.1 dbg 211024 61a3a1d8ef15512396b4c2af46e922a19bf2b174 No bug found
|
MS 9.1 opt 211024 61a3a1d8ef15512396b4c2af46e922a19bf2b174 No bug found
|
No UBSAN/ASAN issues observed.
Attachments
Issue Links
- relates to
-
MDEV-35288 Assertion `!is_cond()' failed in virtual longlong Item_bool_func::val_int()
-
- Stalled
-