03-GroupBy

Group by always return option

1. CountAlwaysReturnValue option is true (default)

2. Group by on super table with multiple subtables

3. Group by with various aggregate functions

4. Group by with various where/having/order by clauses

5. Group by with nested queries

6. Group by with join queries

7. Group by after altering stable structure

8. Group by on random data columns and tags

9. Group by on random aggregate functions

10. Group by on random where/having/order by clauses

11. Group by on random nested queries

12. Group by on random join queries

path: cases/09-DataQuerying/03-GroupBy/test_query_groupby_alwaysreturn.py

Group by basic

1. Including multiple data types

2. Including data columns and tag columns

3. With ORDER BY clause

4. With Limit offset clause

5. With filtering conditions

6. With various functions

7. With different windows

8. With join clauses

9. With group by now/now+1/1

path: cases/09-DataQuerying/03-GroupBy/test_query_groupby_basic.py

Group by bugs

1. Verify bug TS-3821 (tag value not show with group by query)

2. Verify bug TD-28163 (group by query bugs with null values)

3. Verify bug TS-4382 (group by query bugs with various data types)

path: cases/09-DataQuerying/03-GroupBy/test_query_groupby_bugs.py

Group by always return close

1. CountAlwaysReturnValue option is false

2. Group by with various count(*) queries

3. Group by with various count(column) queries

4. Group by with order by

5. Group by with having

6. Group by with where clause

7. Group by with union/union all

8. Group by with null and not null values

9. Group by on multiple tables

10. Group by with nested queries

11. Validate results against expected output

path: cases/09-DataQuerying/03-GroupBy/test_query_groupby_noreturn.py