-
Notifications
You must be signed in to change notification settings - Fork 109
[QA] Test ORDER BY/LIMIT combinations #3922
Copy link
Copy link
Closed
Labels
QATesting and quality assuranceTesting and quality assuranceSQL compilerRelated to the SQL compilerRelated to the SQL compiler
Description
Exercise a query of the following form:
SELECT field FROM table ORDER BY field1 [DESC|ASC] [NULLS FIRST|NULLS LAST] LIMIT NWe vary
- number of identical elements in collection
- DESC/ASC
- NULLS FIRST/NULLS LAST/UNSPECIFIED
- LIMIT VALUE (1, 2, 3)
We should compare with MySQL, since our default comparison for NULL is smaller than other values.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
QATesting and quality assuranceTesting and quality assuranceSQL compilerRelated to the SQL compilerRelated to the SQL compiler