← Back to branch summary

~vadim-tk/percona-server/flushing-algo

« back to all changes in this revision

Viewing changes to mysql-test/suite/funcs_1/datadict/basics_mixed3.inc

  • Committer: root
  • Date: 2011-10-29 01:34:40 UTC
  • Revision ID: root@hppro1.office.percona.com-20111029013440-qhnf4jk8kdjcf4e0
Initial import

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/funcs_1/datadict/basics_mixed3.inc
 
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%';