01-Create

Stable name basic

1. Attempt to create stables with invalid table names, column names, and invalid data types

2. Create a super table containing multiple tag types

3. Create child tables and insert data

4. Query using tags

path: cases/04-SuperTables/01-Create/test_stable_create_basic.py

Stable keep options

1. prepare database

2. check create stb with keep

3. check create stb with err keep duration

4. check alter stb with keep

5. check alter stb with keep err

6. check child table with keep

7. check normal table with keep

8. check stb keep show create

9. check stb keep ins_stables

path: cases/04-SuperTables/01-Create/test_stable_create_keep.py

Stable prefix & suffix

1. Create Database with random vgroups

2. Create Super Table with random prefix and suffix

3. Create Sub Tables with random prefix and suffix

4. Insert data into Sub Tables

5. Check data in Sub Tables and Super Table

path: cases/04-SuperTables/01-Create/test_stable_create_presuf.py

Stable max row length alter

1. Create stable with max columns to test limit

2. Create stable with max tags to test limit

3. Alter stable to test column and tag limit

4. Insert data to test max columns and tags

5. Query data to test max columns and tags

path: cases/04-SuperTables/01-Create/test_stable_create_rowlength64k.py

Stable max row length benchmark

1. taosBenchmark create table with column 1023

2. taosBenchmark create table with column 4095

3. taosBenchmark create table with column 1021

4. taosBenchmark create table with column 4093

5. taosBenchmark run with rowlength64k.json

6. verify result is ok

path: cases/04-SuperTables/01-Create/test_stable_create_rowlength64k_benchmark.py

Stable max row length

1. Call Table Max Columns Case with Different queryPolicy (-Q 1 to 4)

2. Call Table Max Columns Case with restful

path: cases/04-SuperTables/01-Create/test_stable_create_rowlength64k_call.py

Stable keep options

1. Super table keep parameter only takes effect during compaction

2. Before compaction, all historical data is visible regardless of keep settings

3. After compaction, data older than the keep period is removed

4. Different combinations of database keep and super table keep behave as expected

path: cases/04-SuperTables/01-Create/test_stable_keep_compact.py

Stable comment options

1. Create normal table, stable and child table with/without comment

2. Alter table comment

3. Verify comment info in information_schema.ins_tables and information_schema.ins_stables

4. Verify error when comment length > 1024

path: cases/04-SuperTables/01-Create/test_table_comment.py

Stable ttl options

1. Create normal table with ttl param

2. Create stable and child table with ttl param

3. Insert data into child table with ttl param

4. Verify ttl param is ok

path: cases/04-SuperTables/01-Create/test_table_param_ttl.py