Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SELECT doesnt not use index for OR clause not on the main level #6521

Closed
vantonov1 opened this issue Aug 4, 2016 · 3 comments
Closed

SELECT doesnt not use index for OR clause not on the main level #6521

vantonov1 opened this issue Aug 4, 2016 · 3 comments
Assignees
Milestone

Comments

@vantonov1
Copy link

v 2.2.3

SELECT ... WHERE f2=y or f3=z is OK

SELECT ... WHERE f1=x and (f2=y or f3=z) will not use index for f2 and f3 - why?

@luigidellaquila
Copy link
Member

Hi @vantonov1

It's a known limitation, we are working on it for next versions

Thanks

Luigi

@lvca
Copy link
Member

lvca commented Aug 5, 2017

@luigidellaquila is this already supported in 3.0?

@lvca lvca added this to the 3.0 milestone Aug 5, 2017
@luigidellaquila
Copy link
Member

Yes, it's already supported since v 3.0 M1

Closing, thanks

Luigi

@luigidellaquila luigidellaquila modified the milestones: 3.0, 3.0.0-RC1 Dec 18, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Development

No branches or pull requests

3 participants