SQL compiler does not accept many legal SQL OVER statements #457
Description
mihaibudiu
Issue body actions
- missing ORDER BY
- missing window
- sorted on nullable types
- sorted on decimal columns
- sorted on unsigned columns [SQL] Support window queries sorting over unsigned types, UUID #5890
- sorted on BOOL [SQL] Support for range aggregates sorting on intervals, booleans #6310
- sorted on UUID [SQL] Support window queries sorting over unsigned types, UUID #5890
- sorted on short INTERVALs [SQL] Support for range aggregates sorting on intervals, booleans #6310
- sorted on long INTERVALs [SQL] Support for range aggregates sorting on intervals, booleans #6310
- sorted on BINARY
- shorter than 128 bits
- longer than 128 bits
- sorted on types that cannot be converted to integers
- VARCHAR
- VARBINARY
- DOUBLE
- REAL
- order is descending
- FIRST_VALUE, LAST_VALUE with custom RANGEs
- ROWS
- sorted on multiple columns
- NULLS FIRST [SQL] Support window queries sorting over unsigned types, UUID #5890
- NULLS LAST [SQL] Support window queries sorting over unsigned types, UUID #5890
- RANK, DENSE_RANK, ROW_NUMBER [SQL] Support RANK, ROW_NUMBER, DENSE_RANK even if not in a TopK pattern #3934
- EXCLUDE
Reactions are currently unavailable