Skip to content

[QA] Test ORDER BY/LIMIT combinations #3922

@mihaibudiu

Description

@mihaibudiu

Exercise a query of the following form:

SELECT field FROM table ORDER BY field1 [DESC|ASC] [NULLS FIRST|NULLS LAST] LIMIT N

We 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.

Metadata

Metadata

Labels

QATesting and quality assuranceSQL compilerRelated to the SQL compiler

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions