fdb-record-layer icon indicating copy to clipboard operation
fdb-record-layer copied to clipboard

Can not plan scans with complex ordering expressions

Open hatyo opened this issue 9 months ago • 0 comments

If we have a SQL statement like the following:

select a & 1, a & 2 from t order by a & 1, a & 2

The planner is not able to plan it, even if we have a matching value index:

create index idx1 as select a & 1, a & 2 from t1 order by  a & 1, a & 2

hatyo avatar Feb 25 '25 11:02 hatyo