[#MDEV-21091] In Predicate into in subquery is not reflected in optimizer trace

[MDEV-21091] In Predicate into in subquery is not reflected in optimizer trace Created: 2019-11-20 Updated: 2020-09-30 Resolved: 2020-09-30
Status:	Closed
Project:	MariaDB Server
Component/s:	Optimizer
Affects Version/s:	10.4
Fix Version/s:	N/A

Type:

Bug

Priority:

Major

Reporter:

Oleksandr Byelkin

Assignee:

Varun Gupta (Inactive)

Resolution:

Duplicate

Votes:

Labels:

optimizer_trace

Description

create table t1(a int);

insert into t1 values (2),(3);

set @@in_predicate_conversion_threshold= 2;

set optimizer_trace=1;

select * from t1 where a in (1,2);

select * from information_schema.optimizer_trace;

drop table t1;

Comments

Comment by Varun Gupta (Inactive) [ 2020-09-30 ]

This has been fixed by ~~MDEV-23767~~ in 10.5

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