Skip to content

16-Views

View basic
1. Create view from one database
2. Create view from multi database
3. Create view with different view name params
4. Create view with different data type in query
5. Show view
6. Drop view
7. View permission test
8. Query from view
9. TMQ consume from view
10. Verify bug TD-33390
path: cases/16-Views/test_view_basic.py

View management
1. Create 3 super tables
2. Create child tables and insert data
3. Create view with root user
4. Grant /revoke privilege on view to normal users and test
5. Nested view privilege test
6. Query view test
7. show/desc view test
8. Same name table and view test
9. Test keepColumnName is 1 and 0
10. Restart server test
11. Drop view test
path: cases/16-Views/test_view_mgmt.py

View with nested join
1. Create 1 stable and 1 normal table
2. Create view with nested join of stable and normal table
3. Query view
path: cases/16-Views/test_view_nested_join.py