Skip to content

Disallow order by within ordered-set aggregate functions argument lists #18281

@Jefffrey

Description

@Jefffrey

Is your feature request related to a problem or challenge?

These should not be allowed by SQL planner:

select quantile_cont(col0, 0.75 order by col0) from values (1, 3), (2, 2), (3, 1) t(col0, col1);
select quantile_cont(0.75 order by col0) from values (1, 3), (2, 2), (3, 1) t(col0, col1);
  • Bottom one fails, but only because it can't find matching function; ideally we should fail earlier as syntax error

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

See #17805 (comment)

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions