[MDEV-32866] Debug assertion failure in Item_subselect::val_bool() Created: 2023-11-23  Updated: 2023-12-12

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3

Type: Bug Priority: Major
Reporter: Oleg Smirnov Assignee: Oleg Smirnov
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-22375 Assertion `(engine->uncacheable() & ~... Stalled
relates to MDEV-29070 SIGSEGV in my_decimal::operator= and ... Closed

 Description   

Test case:

CREATE TABLE t1(a INT);
 
INSERT INTO t1(a) VALUES (1);
 
 
 
SELECT a FROM t1 WHERE (SELECT a,a) IN (SELECT a,a);
 
SELECT a FROM t1 WHERE (SELECT a,a) IN (SELECT 1,1);
 
SELECT a FROM t1 WHERE (SELECT a,a UNION SELECT 1,a FROM t1 ) IN (SELECT 1,1);
 
SELECT a FROM t1 WHERE (SELECT a,a UNION SELECT 1,a FROM t1 ) IN (SELECT a,a);



 Comments   
Comment by Oleg Smirnov [ 2023-11-24 ]

This issue was discovered while working on MDEV-29070.

Comment by Alice Sherepa [ 2023-12-12 ]

MDEV-22375 seems to be the same problem

mysqld: /10.4/src/sql/item_subselect.cc:1883: virtual bool Item_in_subselect::val_bool(): Assertion `(engine->uncacheable() & ~8) || ! engine->is_executed() || with_recursive_reference' failed.
 
231212 15:17:22 [ERROR] mysqld got signal 6 ;
 
 
 
Server version: 10.4.33-MariaDB-debug-log source revision: 9f5078a1d79031c4a781d378af18df9c8c9d2321
 
 
 
/lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f1c7b10ffd6]
 
sql/item_subselect.cc:1885(Item_in_subselect::val_bool())[0x55fb10f13f10]
 
sql/item.h:1562(Item::val_bool_result())[0x55fb10246962]
 
sql/item_cmpfunc.cc:1673(Item_in_optimizer::val_int())[0x55fb10daa74e]
 
sql/sql_select.cc:4520(JOIN::exec_inner())[0x55fb105e509a]
 
sql/sql_select.cc:4408(JOIN::exec())[0x55fb105e37a6]
 
sql/sql_select.cc:4848(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55fb105e7982]
 
sql/sql_select.cc:442(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55fb105b81f8]
 
sql/sql_parse.cc:6523(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55fb1051f1fd]
 
sql/sql_parse.cc:3980(mysql_execute_command(THD*))[0x55fb1050c81d]
 
sql/sql_parse.cc:8062(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55fb10528779]
 
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55fb104fe925]
 
sql/sql_parse.cc:1378(do_command(THD*))[0x55fb104fb450]
 
sql/sql_connect.cc:1419(do_handle_one_connection(CONNECT*))[0x55fb109104c6]
 
sql/sql_connect.cc:1324(handle_one_connection)[0x55fb1090fd6a]
 
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55fb115ade4c]
 
nptl/pthread_create.c:478(start_thread)[0x7f1c7b62a609]
 
 
 
Query (0x62b0000a1290): SELECT a FROM t1 WHERE (SELECT a,a) IN (SELECT a,a)

Generated at Thu Feb 08 10:34:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.