[MDEV-3432] LP:727183 - WL#90 does not trigger with non-comma joins Created: 2011-03-01  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: Philip Stoev (Inactive) Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug727183.xml    

 Description   

WL#90 optimizations only trigger for comma joins. They do not trigger for any other join type, and they do not trigger if ON or USING clause is used.

Queries provided by spetrunia:

(15:37:04) spetrunia: MariaDB [test]> explain select * from one_k_key X, ten Y where X.a in (select max(a) from ten);
(15:37:06) spetrunia: this works
(15:37:12) spetrunia: MariaDB [test]> explain select * from one_k_key X join ten Y on X.a < Y.a where X.a in (select max(a) from ten);
(15:37:19) spetrunia: this doesn't

 Comments   
Comment by Sergei Petrunia [ 2011-06-10 ]

Re: WL#90 does not trigger with non-comma joins
This has been already fixed. I've now pushed a testcase to 5.3-main.

Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ]

Launchpad bug id: 727183

Generated at Thu Feb 08 06:48:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.