Skip to content

The duplicate slot maybe produce by planner when select constant stmt #4900

Closed

Description

@EmmyMiao87

Describe the bug
The duplicate slot maybe produce by planner when select constant stmt

select 1 from test where k1=1
A slot will be added in tuple when tuple's materialized slots is empty.

select 1, k1 from test where k1=1

But k1 is duplicated with the column k1 in where clause.
This will cause the predicate to be incorrectly pushed down to the storage engine when the query is executed.

Activity

  1. added
    kind/fixCategorizes issue or PR as related to a bug.
    area/plannerIssues or PRs related to the query planner
    on Nov 13, 2020
  2. added a commit that references this issue on Nov 13, 2020
    312af5d
  3. added a commit that references this issue on Nov 17, 2020
    dcca3bb
  4. added a commit that references this issue on Nov 14, 2022
    2855506
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    area/plannerIssues or PRs related to the query plannerkind/fixCategorizes issue or PR as related to a bug.

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions