influxdata / influxdata/influxdb

Push down filters do not push down variables referring to literals

Open
#14,072 7 comments 0 reactions 0 assignees View on GitHub
team/query
Dominant language
Rust
Stars
31.7k
Forks
3.7k
Avg merge
13h 37m
Merged PRs (30d)
8

Description

__Steps to reproduce:__

Reproduction steps are given in this issue: influxdata/flux#1206.

Basically, assign a variable to a string literal and use that string literal in a filter that should be pushed down to storage.

__Expected behavior:__
The literal gets pushed down to storage for more efficient behavior by using the constant value in the variable.

__Actual behavior:__
The literal does not get pushed down because the planner does not recognize that it is equivalent to a string literal.

Contributor guide

Open the contributing guide

Research direction

Start with the reproduction described in influxdata/flux#1206, then trace the planner's filter pushdown path into storage. Done means a filter using a variable assigned to a string literal is recognized as equivalent to the literal and pushed down for execution.

Written by the indexing model from the issue text.

Assessment

Tech stack
rust
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.