04-Query

Show create db

1. Create database

2. Run SHOW CREATE DATABASE

3. Verify the result

path: cases/02-Databases/04-Query/test_db_show_create_db.py

Show create table

1. Create a normal table

2. Create a super table

3. Create child tables

4. Execute SHOW CREATE TABLE and verify the output

5. Change the showFullCreateTableColumn parameter

6. Execute SHOW CREATE TABLE again and verify the new output

path: cases/02-Databases/04-Query/test_db_show_create_table.py

Show create table empty nchar tag

1. when nchar-type tag is empty, show create table should output an empty string

2. alter table to set nchar-type tag to a non-empty string, show create table should output the new string

3. alter table to set nchar-type tag to an empty string, show create table should output an empty string again

4. alter table to set nchar-type tag to a non-empty string again, show create table should output the new string again

5. drop database

path: cases/02-Databases/04-Query/test_db_show_create_table.py

Show vgroups

1. Create multiple databases

2. Repeatedly create and drop tables

3. Run SHOW VGROUPS after each cycle to confirm the expected vgroup count

path: cases/02-Databases/04-Query/test_db_show_vgroup.py