[MDEV-18995] Some bugs in direct join Created: 2019-03-21  Updated: 2019-04-25  Resolved: 2019-04-25

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: None
Fix Version/s: 10.4.5

Type: Bug Priority: Major
Reporter: willhan Assignee: Kentoku Shiba (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

Some bugs in direct join
Table: will1 (zone is primary key)
Table: will2 (account is primary key)
select name will1.zone as zone from will2,will1 where will2.zone=will1.zone and account = 'o110W5yqygj8LeFHXT2FEr-Ft_Zc';
select * from will2
(then crash)

disable this feature

 Comments   
Comment by Kentoku Shiba (Inactive) [ 2019-04-09 ]

willhan
It's already fixed. Additionally, I added const_table support to the direct join feature and condition pushdown feature.
Please check test results of the following commit.
ebf3376

Comment by willhan [ 2019-04-25 ]

It's ok

Comment by Kentoku Shiba (Inactive) [ 2019-04-25 ]

merging

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