21-Meta Data

Meta bugs

1. Verify bug TS-5394(perf_queries should not exist in information_schema on init)

2. Verify bug TS-5580(ins_tags and ins_columns query performance issue)

path: cases/21-MetaData/test_meta_bugs.py

Meta changed on stable

1. Create database schema_change with 2 vgroups

2. Create stable meters with initial columns and tags

3. Randomly add/drop/rename columns and tags on stable meters

4. Query data from stable meters after schema changes

5. Flush database regularly during schema changes

6. Repeat step 3 to step 5 for 1000 times

7. Verify all operations are successful

path: cases/21-MetaData/test_meta_change.py

Meta information_schema

1. Creating databases with super/child/normal tables for metadata testing

2. Executing comprehensive queries on information_schema tables (ins_databases/ins_stables/ins_tables)

3. Testing large-scale stable table creation (70+ stables per database)

4. Verifying partition and limit operations on system tables

5. Checking table counting and distinct value operations

6. Create/Drop Database with same name as system database

7. Restart taosd service

8. Create/Drop Table with same name as system table

9. Check information_schema.ins_tables

10. Check information_schema.ins_stables

11. Check information_schema.ins_tags

12. Check information_schema.ins_databases

13. Check information_schema.ins_streams

14. Check information_schema.ins_users

15. Check information_schema.ins_user_privileges

16. Check information_schema.ins_filesets

17. Check information_schema.ins_vgroups

18. Check information_schema.ins_dnodes

19. Check information_schema.ins_mnodes

20. Check information_schema.ins_snodes

21. Check information_schema.ins_qnodes

22. Check information_schema.ins_bnodes

23. Check information_schema.ins_cluster

24. Check information_schema.ins_functions

25. Check information_schema.ins_indexes

26. Check information_schema.ins_tags

27. Check information_schema.ins_columns

28. Check information_schema.ins_virtual_child_columns

29. Check information_schema.ins_views

30. Check information_schema.ins_grants

31. Check information_schema.ins_configs

32. Check information_schema.ins_dnode_variables

33. Check information_schema.ins_stream_tasks

34. Check information_schema.ins_transaction_details

35. Check information_schema.ins_mounts

36. Check information_schema.ins_stream_recalculates

37. Check information_schema.ins_ssmigrates

38. Check information_schema.ins_scans

39. Check information_schema.ins_scan_details

40. Check information_schema.ins_rsmas

41. Check information_schema.ins_retentions

42. Check information_schema.ins_retention_details

43. Check table counting and distinct value operations again after all above tests

44. Check functions on information_schema tables

- count/sum/min/max/stddev/avg/apercentile/

- top/bottom/spread/histogram/hyperloglog/sample/mode

45. Check unsupported functions on information_schema tables

- unique/tail/leastSquares/elapsed/interp/percentile/

- derivative/irate/last_row/last/first/twa/diff/

- statecount/stateduration/csum/mavg

path: cases/21-MetaData/test_meta_information_schema.py

Meta system database

1. Check table type in information_schema.ins_tables

2. Check ins_tables count plan optimization

3. Check ins_columns result correctly with table_name filter

4. Check table count scan with group by db_name and stable_name

5. Check table count scan after taosd restart

6. Check count(distinct ...) function NOT optimized on ins_tables

path: cases/21-MetaData/test_meta_ins_tables.py

Meta system database

1. check table type in information_schema.ins_tables

2. check ins_tables count plan optimization

path: cases/21-MetaData/test_meta_sysdb2.py