[MDEV-21094] outer to inner joins is not reflected in optimizer trace Created: 2019-11-20  Updated: 2021-03-19

Status: Open
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 10.4
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Oleksandr Byelkin Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 0
Labels: optimizer_trace


 Description    

create table t1 (a int primary key, b int);
 
insert into t1 values (1,1),(2,2),(3,3);
 
 
 
create table t2 (a int primary key, b int);
 
insert into t2 values (1,1),(2,2),(3,3),(4,4);
 
 
 
 
 
set optimizer_trace=1;
 
SELECT * FROM t1 LEFT JOIN t2 ON t2.a=t1.a WHERE t2.b < 5;
 
select * from information_schema.optimizer_trace;
 
explain extended
 
SELECT * FROM t1 LEFT JOIN t2 ON t2.a=t1.a WHERE t2.b < 5;
 
 
 
drop table t1,t2;


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