19-TSMAs

Sma basic

1. Create 1 super table and 5 child tables

2. Insert 1 million rows data into each child table

3. Put special number value (8764231) on c2 column interval 3200 rows

4. Query and check the result of count/max/min/sum on c1/c2 column with different where condition

5. Query count(*) where c2 != specail number(8764231) as no using sma

6. Query count(*) no where as using sma

7. Expect the performance step5 < step6 * 8

8. Query each function(count/max/min/avg/sum/spread/percentile/first/last) on all columns of the table ntb using sma

path: cases/19-TSMAs/test_sma_basic.py

Sma bugs

1. JIRA TD-33336

2. JIRA TS-5900

path: cases/19-TSMAs/test_sma_bugs.py

TSMAs correctness

1. Create database db1 without sma and db2 with sma

2. Create same super table and child tables on db1 and db2

3. Insert same data into child tables of db1 and db2

4. Query data from db1 and db2

5. Expect query result same from db1 and db2

path: cases/19-TSMAs/test_time_range_wise.py

TSMAs basic

1. Create snode on dnode 1

2. Initialize data

3. Execute tsma ddl test cases

4. Execute tsma query test cases

5. Execute tsma flush query test cases

6. Execute tsma redistribute vgroups test cases if cluster dnode nums > 1

7. Drop tsma test.tsma5

8. Verify TD-32519

9. Drop snode

path: cases/19-TSMAs/test_tsma.py