01-Select

Select basic

1. Projection queries

2. Aggregation queries

3. Scalar functions

4. Combining GROUP BY, ORDER BY, Limit, and WHERE clauses

path: cases/09-DataQuerying/01-Select/test_query_select_basic.py

Select bugs

1. Verify jira TS-5946

2. Verify jira TD-30686

3. Verify jira TS-5105

4. Verify jira TS-5143

5. Verify jira TS-5239

6. Verify jira TD-31684

7. Verify jira TS-5984

8. Verify jira TS-6058

9. Verify jira TS-5761

10. Verify jira TS-7058

11. Verify jira TS-5761 scalemode

12. Verify jira TS-5712

13. Verify jira TS-4348

14. Verify jira TS-4233

15. Verify jira TS-3405

16. Verify jira TD-32548

17. Verify jira TD-28068

path: cases/09-DataQuerying/01-Select/test_query_select_bugs.py

Select exact test

1. Insert data with taosBenchmark 1 stable 6 child tables

2. Insert each child table 10w rows with step 30s, total 60w rows

3. Insert each child with 5w rows disorder with step 60s

4. Flush database

5. Check correctness: csum/tail/top/bottom/statecount/stateduration/histogram/first/last/sample/spread/percent

6. Check correctness: count/sum/min/max/avg/stddev/leastsquares/derivative/irate/diff/twa/mavg/

7. Window query with various condition combinations

8. Check function behavior with null input: abs/unique/concat_ws/timetruncate/timediff/to_timestamp

9. Check substr from 0 start

10. Check cast behavior

11. Check iso8601 behavior

12. Check null behavior

path: cases/09-DataQuerying/01-Select/test_query_select_exact.py

Select function null

1. Create table with various data types and insert data including nulls.

2. Execute various functions with parameter null or columns value null.

- abs

- floor

- ceil

- round

- sin

- cos

- tan

- asin

- acos

- atan

- log

- pow

3. Verify result as expected.

path: cases/09-DataQuerying/01-Select/test_query_select_funtion_null.py

Select null

1. Create a super table with various data types including int, double, varchar, and timestamp.

2. Create multiple sub-tables using the super table with different tag values.

3. Insert data into the sub-tables, leaving some fields as null.

4. Execute various SELECT queries to test the handling of null values, including:

- COUNT on columns with null values.

- MAX and MIN functions on columns with null values.

- Queries with LIMIT and OFFSET.

5. Validate the results of each query to ensure correct handling of null values.

6. Query using Chinese characters in column and table names to verify UTF-8 support.

7. Clean up by dropping the created database and tables.

path: cases/09-DataQuerying/01-Select/test_query_select_null.py