Skip to content

02-SubTables

Auto create child table
1. Automatically create child tables by inserting data, query data, and query tag values
2. Delete some of the created child tables and repeat the auto-creation
3. When automatically creating child tables, use some Chinese tag values
4. When automatically creating child tables, specify partial tag values
5. Insert table auto insert with cache
6. Check duplicate table with err tag
7. Check table with another stb name
8. Check table with same name
9. Check same table same timestamp
10. Check some error cases
path: cases/03-Tables/02-SubTables/test_subtable_autocreate.py

Batch set tag values on multiple subtables in one ALTER TABLE statement
ALTER TABLE
subtable1 SET TAG tag1=value1, tag2=value2, ...
subtable2 SET TAG tag1=value3, tag2=value4, ...
path: cases/03-Tables/02-SubTables/test_subtable_batch_set_tag_vals.py

Set tag values on child tables via USING supertable with optional WHERE clause
ALTER TABLE USING supertable SET TAG tag1=value1, tag2=value2, ... WHERE condition
path: cases/03-Tables/02-SubTables/test_subtable_batch_set_tag_vals.py

Batch create
1. Create super table
2. Batch-create multiple child tables
3. Insert data
4. Query results
5. Create a normal table
6. Batch-insert data
7. Query results
path: cases/03-Tables/02-SubTables/test_subtable_batchcreate.py

Child table create using csv
1. Create database with vgroups 20 stt_trigger 1
2. Create super table according to csvfile format
3. Create child table using csv file
4. Check created child table number
path: cases/03-Tables/02-SubTables/test_subtable_create_using_csv.py

Drop then query
1. Repeatedly create and drop
2. Query tags after deleting child tables
path: cases/03-Tables/02-SubTables/test_subtable_drop.py

Query
1. Create super tables and child tables
2. Check results from:
SHOW TABLES
SELECT * FROM ins_tables
SELECT * FROM ins_stables
path: cases/03-Tables/02-SubTables/test_subtable_query.py

Set tag vals
1. Modify tag values and insert data, including setting tags with NULL values
2. Perform filtered queries on the super table using the modified tag values
3. Modify multiple tag values simultaneously
path: cases/03-Tables/02-SubTables/test_subtable_set_tag_vals.py

Subtable ttl
1. Create 100 subtables with TTL
2. flush database and wait for TTL to take effect
3. Verify that the correct number of subtables have been dropped
4. Create 2 subtables, one with TTL and one without
5. Insert data into the subtable with TTL before it expires
6. Verify that the subtable with TTL is not dropped after the TTL period,
7. While the subtable without TTL remains unaffected.
8. Create/Alter ttl/comment on normal/child table
9. Verify ttl/comment in information_schema
path: cases/03-Tables/02-SubTables/test_subtable_ttl.py