Skip to content

23-Show Commands

Show alive
Continuously start and stop multiple dnodes to verify the returned results of show alive.
path: cases/23-ShowCommands/test_show_alive.py

Show basic
1. Verify show commands result with information_schema database
2. Verify show commands result after dnode restarts
3. Checking error handling for invalid operations
4. Check show command include:
show dnodes/modes/qnodes/databases/functions/stables/tables/vgroups
show apps/connections/consumers/queries/transactions/views/tags
show variables/local variables/cluster variables/compacts/cluster
show licences/grants/users
show create database/stable/table
5. Create super table/child table/view and insert data
6. Verify show tags/table tags/indexes command
7. Checking error handling for invalid operations
8. Check show command include:
show tags from super table/child table
show table tags from super table/child table
show indexes from super table/child table
path: cases/23-ShowCommands/test_show_basic.py

Show create database
1. Create three databases with different options
2. Check "show create database dbname" output correctness
3. Restart taosd and recheck the output correctness
4. Drop and recreate the databases, recheck the output correctness
path: cases/23-ShowCommands/test_show_create_db.py

Show create stream
1. Create a database with super table and child tables
2. Create streams with different window types (state_window, session)
3. Verify SHOW CREATE STREAM returns correct stream name and CREATE STREAM SQL
4. Verify the returned SQL is idempotent (drop stream, re-execute SQL, re-check)
5. Verify SHOW CREATE STREAM on a non-existent stream returns an error
path: cases/23-ShowCommands/test_show_create_stream.py

Show disk info
1. Create super tables and child tables, then write data
2. Perform a FLUSH operation on the database
3. Execute the show disk_info statement
4. Write bulk data into a database with multi-level storage configuration
5. Perform TRIM operation and validate data retention across levels
6. Compare disk usage statistics from show disk_info with actual disk usage
path: cases/23-ShowCommands/test_show_diskinfo.py

Show table distributed
1. Tests basic distributed table display for super/normal/temporary tables
2. Verifies error handling for system/internal tables
3. Includes block distribution validation with data insertion
4. Checks metadata consistency after operations
5. Covers edge cases from TD-5998/TD-22140/TD-22165
6. Validates both in-memory and on-disk data representation
7. Ensures proper cleanup of test artifacts
8. Confirms accurate row counts in various scenarios
9. Validates functionality across different cluster configurations
10. Assesses performance impact of show table distributed command
path: cases/23-ShowCommands/test_show_table_distributed.py

Show databases & tables
1. Testing various show commands for database/table classification
2. Verifying filtering capabilities with like clauses
3. Checking metadata consistency across different database contexts
path: cases/23-ShowCommands/test_show_tables.py

Show transaction
1. CREATE DATABASE db1 vgroups 16 replica 1
2. ALTER DATABASE db1 replica 3
3. CREATE DATABASE db2 vgroups 40 replica 3
4. During the above operations, stop a dnode to generate incomplete transactions
5. Use SHOW TRANSACTIONS to display ongoing transactions
6. Use SHOW TRANSACTION <id> to display transaction details
7. Query ins_transaction_details table to verify transaction details
path: cases/23-ShowCommands/test_show_transaction.py

Show Basic
1. build cluster with 3 dnodes
2. execute show vgroups commands
path: cases/23-ShowCommands/test_show_vgroups_ready.py

check vgroups is ready
Check vgroups is ready after create database
path: cases/23-ShowCommands/test_show_vgroups_ready.py