04-Set

Operator union basic

1. Union of projection queries

2. Union of queries containing window and aggregate functions

3. Union of system table queries

4. Union of queries from databases with different precision levels

5. Union of same/diff limit

6. Union of three select clause

7. Union of order by

path: cases/10-Operators/04-Set/test_union_basic.py

Operator union order by

1. Create 1 database 1 stable 2 subtables

2. Insert data into 2 subtables 1 rows each

3. Use union operator to combine the result from 2 subtables

4. Use order by pseudo columns tbname, _wstart in union query

5. Use number column in order by clause in union query

6. Check error when order by column is not in select columns in union query

path: cases/10-Operators/04-Set/test_union_bugs.py

Operator union

1. Create 1 database 1 stable 3 subtables

2. Insert data into 3 subtables 1 rows each

3. Use union operator to combine the result from 3 subtables

4. Use order by pseudo columns tbname, _wstart in union query

path: cases/10-Operators/04-Set/test_union_bugs.py

Operator union order by functions

1. Create 1 database 1 stable 3 subtables

2. Insert data into 3 subtables 1 rows each

3. Use union operator to combine the result from 3 subtables

4. Use normal functions abs(), ltrim(), lower() in order by clause in union query

path: cases/10-Operators/04-Set/test_union_bugs.py

union with const condition

test for 'where 1=0' condition in UNION

path: cases/10-Operators/04-Set/test_union_bugs.py

Operator union bugs

1. JIRA TD-5630: Support UNION ALL operation for time-series data query

2. JIRA TD-33137: Fix UNION ALL query bugs

3. Add test case for nodes match node in UNION ALL query

path: cases/10-Operators/04-Set/test_union_bugs.py