|
1
by brian
clean slate |
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%'; |