Skip to content

02-Drop

Drop db basic
1. Drop database with if exists
2. Drop empty database
3. Drop database with only meta
4. Drop database with super/child/normal tables
5. Loop drop and create database for many times
6. Verify drop database on information_schema.ins_databases
path: cases/02-Databases/02-Drop/test_db_catalog.py

Drop db while querying
1. Create database
2. Drop database
3. Create database again
4. reset query cache
5. Attempt to write data to its tables (expected to fail)
6. Create normal table with same name
7. Insert data
8. Query data
9. Drop database
10. Repeat 20 times from step 3 ~ 9
path: cases/02-Databases/02-Drop/test_db_delete_reuse.py

Drop db repeatedly
1. Create a database and a normal table, insert data, and repeat the above 30 times using the same names
2. Restart the dnode
3. Create a database and a super table, create child tables, insert data, and repeat the above 10 times using the same names
path: cases/02-Databases/02-Drop/test_db_delete_reuse_vnode.py

Drop db many repeatly
1. Create database
2. Create table
3. Drop both
4. Repeat several times
path: cases/02-Databases/02-Drop/test_db_repeat.py

Drop db while writing
1. Create database
2. Create normal table
3. Insert data
4. Sleep 1s
5. Repeat 10 times with the same names
6. Meanwhile, start a thread that keeps inserting into that table regardless of success
path: cases/02-Databases/02-Drop/test_db_writing.py