[MDEV-29085] Assertion `false' failed in BINVAL::CompareValue, comparing varbinary, Connect engine Created: 2022-07-12  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Connect
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9
Fix Version/s: 10.4, 10.5, 10.6

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Anel Husakovic
Resolution: Unresolved Votes: 0
Labels: None


 Description   

create table t1 (i varbinary(20), j varbinary(20))engine=connect;
insert into t1 values (0x11,0x12); 
select 1 from t1 where i=j;

10.3 0e9a255ec87add182f40d4c67

mysqld: /10.3/src/storage/connect/value.h:393: virtual int BINVAL::CompareValue(PVAL): Assertion `false' failed.
220712 11:32:16 [ERROR] mysqld got signal 6 ;
 
Server version: 10.3.36-MariaDB-debug-log
 
connect/value.h:423(DTVAL::GetCharValue())[0x7f92ecd6381c]
connect/value.cpp:549(VALUE::TestValue(VALUE*))[0x7f92ecd54b29]
connect/filter.cpp:1600(FILTERCMP::Eval(_global*))[0x7f92ecc546d3]
connect/filter.cpp:1740(ApplyFilter(_global*, FILTER*))[0x7f92ecc5549a]
connect/connect.cc:442(CntReadNext(_global*, TDB*))[0x7f92ecbf3c08]
connect/ha_connect.cc:4216(ha_connect::rnd_next(unsigned char*))[0x7f92ecbd5a0f]
sql/handler.cc:2858(handler::ha_rnd_next(unsigned char*))[0x55b958686980]
sql/records.cc:485(rr_sequential(READ_RECORD*))[0x55b958a82a45]
sql/records.h:70(READ_RECORD::read_record())[0x55b957d66924]
sql/sql_select.cc:20838(join_init_read_record(st_join_table*))[0x55b958036b7a]
sql/sql_select.cc:19893(sub_select(JOIN*, st_join_table*, bool))[0x55b95802fd91]
sql/sql_select.cc:19434(do_select(JOIN*, Procedure*))[0x55b95802df0c]
sql/sql_select.cc:4151(JOIN::exec_inner())[0x55b957fc0a91]
sql/sql_select.cc:3946(JOIN::exec())[0x55b957fbe40e]
sql/sql_select.cc:4356(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*))[0x55b957fc1f0c]
sql/sql_select.cc:372(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55b957f9846d]
sql/sql_parse.cc:6339(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55b957f091b5]
sql/sql_parse.cc:3870(mysql_execute_command(THD*))[0x55b957ef71f0]
sql/sql_parse.cc:7870(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55b957f12f12]
sql/sql_parse.cc:1855(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55b957ee9def]
sql/sql_parse.cc:1398(do_command(THD*))[0x55b957ee6932]
sql/sql_connect.cc:1403(do_handle_one_connection(CONNECT*))[0x55b9582b9f69]
sql/sql_connect.cc:1309(handle_one_connection)[0x55b9582b9823]
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55b9598e7c8b]
nptl/pthread_create.c:478(start_thread)[0x7f92f50a2609]
addr2line: DWARF error: section .debug_info is larger than its filesize! (0x93ef57 vs 0x530ea0)
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f92f4fc7133]
 
Query (0x62b000000290): select 1 from t1 where i=j

non-debug also crashes, the same way - signal 6


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