Skip to content

With window frame present and frame type = RANGE, order by must be present with 1 column #529

@jimexist

Description

@jimexist

Describe the bug

With window frame present and frame type = RANGE, order by must be present with 1 column.

To Reproduce
Steps to reproduce the behavior:

Expected behavior

We should check for this boundary case

Additional context

  1. https://www.postgresql.org/docs/current/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS
  2. https://www.sqlite.org/windowfunctions.html#frame_type

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions