| 1 |
#### suite/funcs_1/datadict/basics_mixed3.inc |
| 2 |
# |
| 3 |
# Auxiliary routine to be sourced by suite/funcs_1/t/is_basics_mixed.test |
| 4 |
# |
| 5 |
# Check if INFORMATION_SCHEMA tables contain a schema_name like 'db_data%'. |
| 6 |
# |
| 7 |
# Author: |
| 8 |
# 2008-01-23 mleich WL#4203 Reorganize and fix the data dictionary tests of |
| 9 |
# testsuite funcs_1 |
| 10 |
# Create this script based on older scripts and new code. |
| 11 |
# |
| 12 |
|
| 13 |
# No column with the name of a database contained in: |
| 14 |
# character_sets collations collation_character_set_applicability |
| 15 |
# user_privileges |
| 16 |
SELECT DISTINCT table_schema FROM information_schema.columns |
| 17 |
WHERE table_schema LIKE 'db_data%'; |
| 18 |
SELECT DISTINCT table_schema FROM information_schema.column_privileges |
| 19 |
WHERE table_schema LIKE 'db_data%'; |
| 20 |
SELECT DISTINCT constraint_schema,table_schema |
| 21 |
FROM information_schema.key_column_usage |
| 22 |
WHERE constraint_schema LIKE 'db_data%' OR table_schema LIKE 'db_data%'; |
| 23 |
SELECT DISTINCT routine_schema FROM information_schema.routines |
| 24 |
WHERE routine_schema LIKE 'db_data%'; |
| 25 |
SELECT DISTINCT schema_name FROM information_schema.schemata |
| 26 |
WHERE schema_name LIKE 'db_data%'; |
| 27 |
SELECT DISTINCT table_schema FROM information_schema.schema_privileges |
| 28 |
WHERE table_schema LIKE 'db_data%'; |
| 29 |
SELECT DISTINCT table_schema,index_schema FROM information_schema.statistics |
| 30 |
WHERE table_schema LIKE 'db_data%' OR index_schema LIKE 'db_data%'; |
| 31 |
SELECT DISTINCT table_schema FROM information_schema.tables |
| 32 |
WHERE table_schema LIKE 'db_data%'; |
| 33 |
SELECT DISTINCT constraint_schema,table_schema |
| 34 |
FROM information_schema.table_constraints |
| 35 |
WHERE constraint_schema LIKE 'db_data%' OR table_schema LIKE 'db_data%'; |
| 36 |
SELECT DISTINCT table_schema FROM information_schema.table_privileges |
| 37 |
WHERE table_schema LIKE 'db_data%'; |
| 38 |
SELECT DISTINCT trigger_schema,event_object_schema |
| 39 |
FROM information_schema.triggers |
| 40 |
WHERE trigger_schema LIKE 'db_data%' OR event_object_schema LIKE 'db_data%'; |
| 41 |
SELECT DISTINCT table_schema FROM information_schema.views |
| 42 |
WHERE table_schema LIKE 'db_data%'; |