Skip to content

Cosmos/FullTextSearch: ORDER BY RANK requires OFFSET/LIMIT to be constants, which clashes with EF parameterizing those #35867

@maumar

Description

@maumar

When using ORDER BY RANK with FullTextScore or RRF functions, and also applying Skip/Take we get error:

Invalid OFFSET/LIMIT spec for Hybrid Search query. Expected a number literal in order to distribute query correctly.

What EF generates by default is a parameter for Skip/Take. This happens in funcletizer, which is in Core and also way to early for us to know if we are dealing with full text search ordering.

Metadata

Metadata

Assignees

Type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions