Skip to content

01-SQL

Write basic
1. Write data with timestamp
2. Write data with double
3. Insert and drop database concurrently
4. Write data with future timestamp
5. Write data with wide column
path: cases/06-DataIngestion/01-SQL/test_write.py

Write basic
1. Write data to a nanosecond-precision database
2. Write data to regular tables and child tables
3. Write data to specified columns
4. Batch write multiple records to different child tables in a single operation
5. Write data covering all supported data types
6. Insert data into multiple tables and databases
7. Query with order by desc
8. Validate data integrity after write operations and system restarts
path: cases/06-DataIngestion/01-SQL/test_write_basic.py

Write ns precision
1. create table
2. insert data
3. query data
path: cases/06-DataIngestion/01-SQL/test_write_blob.py

Write bugs
1. TD-27388
2. TD-29157
3. TD-29793
4. TS-4219
5. TS-4272
6. TS-4295
7. TS-4479
path: cases/06-DataIngestion/01-SQL/test_write_bugs.py

Write special columns
1. Write data with different data types
2. Write data to super table with special column
3. Write data to child table with special column
4. Write data to normal table with special column
5. JIRA TS-5184
path: cases/06-DataIngestion/01-SQL/test_write_column_value.py

Write commit scenarios
1. Data exists across multiple files
2. Data distributed across multiple blocks
3. Data coexists in both memory and files
4. Restart the dnode (force kill)
5. Verify data integrity through queries
path: cases/06-DataIngestion/01-SQL/test_write_commit.py

insert use ns precision
1. create table
2. insert data
3. query data
path: cases/06-DataIngestion/01-SQL/test_write_csv_with_quote.py

Write data types
1. Write data with NULL values
2. Write data using different floating-point representations
3. Write Chinese character data
4. Write data with different timestamp representations
5. Write data with backquote
path: cases/06-DataIngestion/01-SQL/test_write_datatypes.py

Write mixed delete
1. Insert data
2. Flush the database
3. Delete data by specific timestamp
4. Delete data by timestamp range
5. Delete data using timestamp condition comparisons
6. Restart the dnode
7. Check data integrity
path: cases/06-DataIngestion/01-SQL/test_write_delete.py

Write from select clause
1. Insert into select from child table
2. Insert into select from normal table
3. Insert into select from super table
path: cases/06-DataIngestion/01-SQL/test_write_insert_select.py

Write more vgroups
1. Write data with taosBenchmark with 5 threads
2. Write data with taosBenchmark with 8 threads
path: cases/06-DataIngestion/01-SQL/test_write_morevgroup.py

Write null none
1. Create a database and super table with various data types.
2. Insert data into the super table with null and none values for different columns.
3. Flush the database to ensure all data is written to disk.
4. Verify that the data has been inserted correctly by querying the super table.
path: cases/06-DataIngestion/01-SQL/test_write_null_none.py

Write expired data
1. Write out-of-order and expired data, including:
Data distributed across multiple files
Data existing in multiple blocks
Data present in both memory and files
2. Restart the dnode
3. Query data integrity
path: cases/06-DataIngestion/01-SQL/test_write_out_of_order_data.py

Write super table
1. Create a super table containing multiple tag types
2. Insert super table with multiple data types
3. Insert super table with consecutive data
4. Insert super table data with stmt
path: cases/06-DataIngestion/01-SQL/test_write_stb.py

Write update
1. Update data in memory
2. Update data in files
3. Write to update multiple records at once
4. Update data using NULL values
5. Restart the dnode
6. Check data integrity
path: cases/06-DataIngestion/01-SQL/test_write_update.py

Write with multi-rows
1. Write data with multi rows
2. Update multi rows with 10000 times
3. Update normal table
4. Update child table
path: cases/06-DataIngestion/01-SQL/test_write_update_multi_rows.py