Loading...

XML

Word

Printable

Details

Type: Bug
Resolution: Fixed
Priority: Critical
Fix Version/s: 4.5.0
Affects Version/s: 4.5.0
Component/s: query
Labels:
None

Triage:
Untriaged
Is this a Regression?:
Unknown

Description

For IN and OR queries, we currently generate DistinctScans for multiple spans.

For efficiency, merge overlapping spans and remove DistinctScan for non-overlapping spans.

Attachments

Gerrit Reviews

- Issue Only
- Show All Reviews
- Show Open Reviews
- Show All Issues
- Show Open Issues

For Gerrit Dashboard: MB-19085
#	Subject	Branch	Project	Status	CR	V
63005,2	MB-19085. Allow AND to generate cross-products, and set Exact on constrained spans.	master	query	Status: MERGED	+2	+1
63007,2	MB-19085. Set Exact to FALSE for ANDs with parameters.	master	query	Status: MERGED	+2	+1
63036,4	MB-19085. Sarg IN and WITHIN predicates directly, and eliminate DistinctScan for IN and WITHIN predicates.	master	query	Status: MERGED	+2	+1
63090,3	MB-19085. Generate more precise spans when IN and OR predicates exceed maximum fanout.	master	query	Status: MERGED	+2	+1
63344,2	MB-19085. Improve DNF heuristic to handle more complex OR predicates up to explicit limit.	master	query	Status: MERGED	+2	+1
63415,2	MB-19085. Fix variable corruption bug in applyDNF(). Also fix SargableFor() for OR predicates with composite indexes.	master	query	Status: MERGED	+2	+1
63452,3	MB-19389 MB-19085. Prevent explosion in planner by de-duping child terms in AND and OR, de-duping spans in sarg_and, and removing empty spans in sarg_and.	master	query	Status: MERGED	+2	+1

Activity

People

Assignee:: Gerald Sangudi (Inactive)

Reporter:: Gerald Sangudi (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 05/Apr/16 3:36 PM

Updated:: 30/Apr/16 12:07 PM

Resolved:: 27/Apr/16 11:12 PM

Gerrit Reviews

There are no open Gerrit changes

Show There are 7 closed Gerrit changes

Hide There are 7 closed Gerrit changes

MB-19085. Allow AND to generate cross-products, and set Exact on constrained spans.: Gerrit Review:

MB-19085. Set Exact to FALSE for ANDs with parameters.: Gerrit Review:

MB-19085. Sarg IN and WITHIN predicates directly, and eliminate DistinctScan for IN and WITHIN predicates.: Gerrit Review:

MB-19085. Generate more precise spans when IN and OR predicates exceed maximum fanout.: Gerrit Review:

MB-19085. Improve DNF heuristic to handle more complex OR predicates up to explicit limit.: Gerrit Review:

MB-19085. Fix variable corruption bug in applyDNF(). Also fix SargableFor() for OR predicates with composite indexes.: Gerrit Review:

MB-19389 MB-19085. Prevent explosion in planner by de-duping child terms in AND and OR, de-duping spans in sarg_and, and removing empty spans in sarg_and.: Gerrit Review:

PagerDuty