04-OrderBy

Order by basic

1. Order by asc/desc

2. Order by expr abs()

3. Order by with limit

4. Order by multiple columns

5. Order by in sub query

6. Order by _wstart with interval

7. Order by with agg functions:

- count

- max

- min

- first

- last

- sum

8. Order by with ambiguous names

9. Order by same column from different tables

10. Order by priority when column exists in both select list and table

11. Order by on joined tables

12. Memleak for order by

13. Bug TS-4467: join query with order by desc causes crash

14. Projection query with order by desc

15. Order by on select list columns

16. Order by with agg functions and alias

17. Order by with constant 'aaa'

path: cases/09-DataQuerying/04-OrderBy/test_orderby_basic.py

Order by double

1. Create a database and table

2. Insert double values into the table

3. Query the table with order by double values; without the fix for TS-6772, it should be failed

4. Verify the order of the returned results

path: cases/09-DataQuerying/04-OrderBy/test_orderby_double.py

Order by subquery results

1. Sort the results of subqueries

2. Sort time data after applying the to_charfunction

3. Sort with multiple order by clauses

4. Sort before and after subqueries

5. Verify ascending and descending order combinations

6. Verify with limit and offset

path: cases/09-DataQuerying/04-OrderBy/test_orderby_subquery.py