[#MDEV-24634] Assert failure when checking null value result for a row equality using a subquery

[MDEV-24634] Assert failure when checking null value result for a row equality using a subquery Created: 2021-01-20 Updated: 2023-04-27
Status:	Open
Project:	MariaDB Server
Component/s:	Data Manipulation - Subquery, Optimizer
Affects Version/s:	10.2, 10.3, 10.4, 10.5
Fix Version/s:	10.4, 10.5

Type:

Bug

Priority:

Major

Reporter:

Igor Babaev

Assignee:

Oleksandr Byelkin

Resolution:

Unresolved

Votes:

Labels:

None

Description

The following test case brings the server to an assert failure:

create table t1 (a int) engine=myisam;

insert into t1 values (3), (7), (1);

create table t2 (b int) engine=myisam;

insert into t2 values (1), (2), (3), (4);

insert into t2 select * from t2;

insert into t2 select * from t2;

insert into t2 select * from t2;

insert into t2 select * from t2;

insert into t2 select * from t2;

insert into t2 select * from t2;

select * from t1 where ((select min(b), max(b) from t2 where b < 1) = (1, 2)) IS UNKNOWN;

The assert failure occurs in the function Item::update_null_value ().

Generated at Thu Feb 08 09:31:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.