08-SubQuery

IN sub query test case

1. Prepare data.

2. Execute various queries with different kind of IN sub queries.

3. Validate the results against expected result files.

path: cases/09-DataQuerying/08-SubQuery/test_in_subq1.py

IN sub query test case

1. Prepare data.

2. Execute various queries with different kind of IN sub queries.

3. Validate the results against expected result files.

path: cases/09-DataQuerying/08-SubQuery/test_in_subq2.py

in sub query test case

1. Prepare data.

2. Explain execute various nested queries with different kind of in sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_in_subq3a1.py

in sub query test case

1. Prepare data.

2. Explain analyze execute various nested queries with different kind of in sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_in_subq3a2.py

in sub query test case

1. Prepare data.

2. Explain execute various nested queries with different kind of in sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_in_subq3b1.py

in sub query test case

1. Prepare data.

2. Explain analyze execute various nested queries with different kind of in sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_in_subq3b2.py

in sub query test case

1. Prepare data.

2. Explain execute various nested queries with different kind of in sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_in_subq3c1.py

in sub query test case

1. Prepare data.

2. Explain analyze execute various nested queries with different kind of in sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_in_subq3c2.py

in sub query test case

1. Prepare data.

2. Explain execute various nested queries with different kind of in sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_in_subq3d1.py

in sub query test case

1. Prepare data.

2. Explain analyze execute various nested queries with different kind of in sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_in_subq3d2.py

Subquery func total

1. Create database and many super/child tables

2. Insert data with random rows

3. Generate select clause list

4. Generate where clause list

5. Generate order by clause list

6. Generate limit clause list

7. Selected different sql clauses to form nested query

8. Replace function with different math function

- UNIQUE/MODE/SAMPLE

- CSUM/STATECOUNT/STATEDURATION/HISTOGRAM

- TIMEDIFF_1/TIMEDIFF_2

9. Execute sql and check results

path: cases/09-DataQuerying/08-SubQuery/test_nestedQuery.py

Subquery 2.6 compatible

1. Create database and many super/child tables

2. Insert data with random rows

3. Generate select clause list

4. Generate where clause list

5. Generate order by clause list

6. Generate limit clause list

7. Selected different sql clauses to form nested query with 2.6 syntax

9. Execute sql and check results

path: cases/09-DataQuerying/08-SubQuery/test_nestedQuery_26.py

Subquery func math

1. Create database and many super/child tables

2. Insert data with random rows

3. Generate select clause list

4. Generate where clause list

5. Generate order by clause list

6. Generate limit clause list

7. Selected different sql clauses to form nested query

8. Replace math function:

- ABS/SQRT

- SIN/COS/TAN/ASIN/ACOS/ATAN

- POW/LOG

- FLOOR/CEIL/ROUND

- MAVG

- HYPERLOGLOG

- TAIL

9. Execute sql and check results

path: cases/09-DataQuerying/08-SubQuery/test_nestedQuery_math.py

Subquery func string

1. Create database and many super/child tables

2. Insert data with random rows

3. Generate select clause list

4. Generate where clause list

5. Generate order by clause list

6. Generate limit clause list

7. Selected different sql clauses to form nested query

8. Replace stringfunction:

- LTRIM/RTRIM/LOWER/UPPER

- LENGTH/CHAR_LENGTH

- SUBSTR

- CONCAT

- CONCAT_WS

9. Execute sql and check results

path: cases/09-DataQuerying/08-SubQuery/test_nestedQuery_str.py

Subquery func time

1. Create database and many super/child tables

2. Insert data with random rows

3. Generate select clause list

4. Generate where clause list

5. Generate order by clause list

6. Generate limit clause list

7. Selected different sql clauses to form nested query

8. Replace time function:

- NOW/TODAY/TIMEZONE/TIMETRUNCATE/

- TO_ISO8601/TO_UNIXTIMESTAMP/ELAPSED

9. Execute sql and check results

path: cases/09-DataQuerying/08-SubQuery/test_nestedQuery_time.py

quantified expr sub query test case

1. Prepare data.

2. Execute various select clause with different kind of quantified expr sub queries.

3. Validate the results against expected result files.

path: cases/09-DataQuerying/08-SubQuery/test_quantified_sub1.py

quantified expr sub query test case

1. Prepare data.

2. Execute various where clause with different kind of quantified expr sub queries.

3. Validate the results against expected result files.

path: cases/09-DataQuerying/08-SubQuery/test_quantified_sub2.py

quantified expr sub query test case

1. Prepare data.

2. Execute various queries with different kind of quantified expr sub queries.

3. Validate the results against expected result files.

path: cases/09-DataQuerying/08-SubQuery/test_quantified_sub3.py

quantified expr sub query test case

1. Prepare data.

2. Execute various queries with quantified expr sub queries.

3. Validate the results against expected result files.

path: cases/09-DataQuerying/08-SubQuery/test_quantified_sub4.py

quantified sub query test case

1. Prepare data.

2. Execute various nested queries with different kind of quantified sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_quantified_sub5a.py

quantified sub query test case

1. Prepare data.

2. Execute various nested queries with different kind of quantified sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_quantified_sub5b.py

quantified sub query test case

1. Prepare data.

2. Execute various nested queries with different kind of quantified sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_quantified_sub5c.py

quantified sub query test case

1. Prepare data.

2. Execute various nested queries with different kind of quantified sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_quantified_sub5d.py

quantified sub query test case

1. Prepare data.

2. Explain execute various nested queries with different kind of quantified sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_quantified_sub6a1.py

quantified sub query test case

1. Prepare data.

2. Explain analyze execute various nested queries with different kind of quantified sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_quantified_sub6a2.py

quantified sub query test case

1. Prepare data.

2. Explain execute various nested queries with different kind of quantified sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_quantified_sub6b1.py

quantified sub query test case

1. Prepare data.

2. Explain analyze execute various nested queries with different kind of quantified sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_quantified_sub6b2.py

quantified sub query test case

1. Prepare data.

2. Explain execute various nested queries with different kind of quantified sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_quantified_sub6c1.py

quantified sub query test case

1. Prepare data.

2. Explain analyze execute various nested queries with different kind of quantified sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_quantified_sub6c2.py

quantified sub query test case

1. Prepare data.

2. Explain execute various nested queries with different kind of quantified sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_quantified_sub6d1.py

quantified sub query test case

1. Prepare data.

2. Explain analyze execute various nested queries with different kind of quantified sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_quantified_sub6d2.py

Subquery basic

1. Perform projection queries on subquery results

2. Perform aggregate queries on subquery results

3. Perform window queries on subquery results

4. Perform DIFF function queries on subquery results

path: cases/09-DataQuerying/08-SubQuery/test_query_sub.py

Subquery bugs

1. Verify bug TS-30189

2. Verify bug TS-5443

3. Verify bug TS-5878

path: cases/09-DataQuerying/08-SubQuery/test_query_sub_bugs.py

Subquery with lastrow

1. Create db

2. Create supper table and sub table

3. Insert data into sub table

4. Query last row from sub table as a sub query, it should return the last row data

path: cases/09-DataQuerying/08-SubQuery/test_query_sub_bugs.py

Subquery interval

1. Create database and tables

2. Insert data

3. Flush database

4. Test subquery with interval clause and time series functions: twa, irate

5. Test to_char and to_timestamp functions

6. Test TS-3932

path: cases/09-DataQuerying/08-SubQuery/test_query_sub_interval.py

Subquery alias name

1. Create dabase with vgroups 4

2. Create stable with various data types

3. Create 10 child tables under the stable

4. Insert data into the child tables, some columns contain null values

5. Select asterisk from subquery with duplicate alias name

6. Verify the query results

path: cases/09-DataQuerying/08-SubQuery/test_query_sub_interval.py

scalar sub query test case

1. Prepare data.

2. Execute various queries with different kind of scalar sub queries.

3. Validate the results against expected result files.

path: cases/09-DataQuerying/08-SubQuery/test_scalar_sub1.py

scalar sub query test case

1. Prepare data.

2. Execute various queries with scalar sub queries.

3. Validate the results against expected result files.

path: cases/09-DataQuerying/08-SubQuery/test_scalar_sub2.py

scalar sub query test case

1. Prepare data.

2. Execute various nested queries with different kind of scalar sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_scalar_sub3a.py

scalar sub query test case

1. Prepare data.

2. Execute various nested queries with different kind of scalar sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_scalar_sub3b.py

scalar sub query test case

1. Prepare data.

2. Execute various nested queries with different kind of scalar sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_scalar_sub3c.py

scalar sub query test case

1. Prepare data.

2. Execute various nested queries with different kind of scalar sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_scalar_sub3d.py

scalar sub query test case

1. Prepare data.

2. Explain execute various nested queries with different kind of scalar sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_scalar_sub4a1.py

scalar sub query test case

1. Prepare data.

2. Explain execute various nested queries with different kind of scalar sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_scalar_sub4a2.py

scalar sub query test case

1. Prepare data.

2. Explain execute various nested queries with different kind of scalar sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_scalar_sub4a3.py

scalar sub query test case

1. Prepare data.

2. Explain execute various nested queries with different kind of scalar sub queries.

path: cases/09-DataQuerying/08-SubQuery/test_scalar_sub4a4.py