SQL compiler does not accept many legal SQL OVER statements #457
Description
- missing ORDER BY
- missing window
- sorted on nullable types
- sorted on decimal columns
- sorted on UUID
- sorted on BINARY
- sorted on types that cannot be converted to integers (string, fp)
- order is descending
- FIRST_VALUE, LAST_VALUE with custom RANGEs
- ROWS
- sorted on multiple columns
- NULLs first
- [SQL] Support RANK, ROW_NUMBER, DENSE_RANK even if not in a TopK pattern #3934
- EXCLUDE