01-NormalTables

Normal table create 100w

1. Create 100w normal tables

2. Query table order by col

3. flush database

path: cases/03-Tables/01-NormalTables/test_normaltable_100w.py

Alter: then desc

1. ALTER TABLE … ADD/DROP/MODIFY columns

2. DESCRIBE each change to confirm

3. Restart the database

4. Resume ADD/DROP/MODIFY operations and verify again

path: cases/03-Tables/01-NormalTables/test_normaltable_alter_1.py

Alter: then insert

1. Execute ADD COLUMN, DROP COLUMN, MODIFY COLUMN operations.

2. Insert data and run SELECT COUNT queries to verify.

3. Restart the database.

4. Continue modifying columns and verify the changes.

path: cases/03-Tables/01-NormalTables/test_normaltable_alter_2.py

Alter: import old data

1. Add column

2. Insert out-of-order data

3. Query data

path: cases/03-Tables/01-NormalTables/test_normaltable_alter_3.py

Alter: repeatedly add

1. Add column

2. Insert data

3. Project query

4. Loop for 7 times

5. Kill then restart

path: cases/03-Tables/01-NormalTables/test_normaltable_alter_4.py

Alter: repeatedly drop

1. Drop column

2. Insert data

3. Project query

4. Loop for 7 times

5. Kill then restart

path: cases/03-Tables/01-NormalTables/test_normaltable_alter_5.py

Column num limit

1. Create normal table

2. Add or delete columns

3. Check column count, the count should not exceed 4096

path: cases/03-Tables/01-NormalTables/test_normaltable_column_limit.py

Normal table data types

1. Create a normal table containing bigint, binary, bool, double, float, int, smallint, tinyint types

2. Write data

3. Perform a projection query, including an order by condition

4. Perform a filter query, including various comparison conditions

path: cases/03-Tables/01-NormalTables/test_normaltable_datatypes.py

Repeatedly drop same name

1. Create a normal table (same name)

2. Insert data

3. Query data

4. Repeat 20 timeses

path: cases/03-Tables/01-NormalTables/test_normaltable_delete_reuse1.py

Repeatedly drop new name

1. Create a normal table (new name)

2. Insert data

3. Query data

4. Repeat 20 timeses

path: cases/03-Tables/01-NormalTables/test_normaltable_delete_reuse2.py

Normal table drop while writing

1. Create a background process that continuously writes data

2. Create a normal table

3. Insert data

4. Query data

5. Repeat 20 timeses

path: cases/03-Tables/01-NormalTables/test_normaltable_delete_writing.py

Normal table after drop

1. Create a table → insert one record → query that record → repeat this sequence 8 times

2. Drop all created tables

3. Repeat 1 times

path: cases/03-Tables/01-NormalTables/test_normaltable_query_after_drop.py

Normal table aggregate

1. Create a table with 256 columns

2. Insert data

3. Execute projection queries

4. Execute filter queries

5. Execute aggregate queries

6. Kill the process and restart the database

path: cases/03-Tables/01-NormalTables/test_normaltable_query_aggregate.py

Normal table composite key

Error Reading Composite Key Data from Memory and STT Files

Root Cause:

The minKeyused a shallow copy. During backward iteration in STT, this accidentally modified the minKeyvalue. When merging keys from memory and STT, inconsistent key states caused data corruption.

Reproduction Steps:

1. Create table with timestamp column and composite key string column. Insert 4 records into STT files and 1 record into memory.

2. Execute query → Trigger failure

path: cases/03-Tables/01-NormalTables/test_normaltable_query_composite.py

Normal table filter

1. Create a normal table

2. Insert data

3. Execute projection queries

4. Execute aggregate queries

5. Execute field filtering queries

path: cases/03-Tables/01-NormalTables/test_normaltable_query_filter.py

Normal table syntax

1. Attempt to create tables with invalid table names

2. Attempt to create tables with invalid column names

3. Attempt to create tables with invalid data types

4. Create normal tables with valid and invalid names

path: cases/03-Tables/01-NormalTables/test_normaltable_synatx.py