Skip to content

Filtered index match error #3785

@hatyo

Description

@hatyo

Steps to reproduce:

create table products(
        id integer,
        name string,
        price double,
        category string,
        stock integer,
        primary key(id)
    )
create index idx_filtered_multi as select category, price, stock from products where price > 15 and stock > 60 order by category, 
select category, price, stock from products where price > 15 and stock > 60 order by category, price

I believe the match candidate is created incorrectly such that price is created twice, once as a Placeholder, and another time as PredicateWithValueAndRanges.

Metadata

Metadata

Assignees

Labels

bugSomething isn't workingplannerRelated to the query planner

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions