Gecko [ 122.154.134.11 ]

Name	Size	Permission
basics_mixed1.inc	1.92 KB	-rw-r--r--
basics_mixed2.inc	2.21 KB	-rw-r--r--
basics_mixed3.inc	1.95 KB	-rw-r--r--
columns.inc	2.73 KB	-rw-r--r--
datadict.pre	2.08 KB	-rw-r--r--
datadict_bug_12777.inc	1.8 KB	-rw-r--r--
datadict_load.inc	4.16 KB	-rw-r--r--
datadict_priv.inc	3.33 KB	-rw-r--r--
is_key_column_usage.inc	14.01 KB	-rw-r--r--
is_routines.inc	18.85 KB	-rw-r--r--
is_schemata.inc	10.82 KB	-rw-r--r--
is_table_query.inc	1.29 KB	-rw-r--r--
is_tables.inc	18.28 KB	-rw-r--r--
is_triggers.inc	10.45 KB	-rw-r--r--
is_views.inc	11.8 KB	-rw-r--r--
processlist_priv.inc	22.16 KB	-rw-r--r--
processlist_val.inc	17.23 KB	-rw-r--r--
statistics.inc	1.61 KB	-rw-r--r--
table_constraints.inc	1.42 KB	-rw-r--r--
tables.inc	1.73 KB	-rw-r--r--
tables1.inc	1.15 KB	-rw-r--r--
tables2.inc	1.78 KB	-rw-r--r--

Code Editor : basics_mixed3.inc

#### suite/funcs_1/datadict/basics_mixed3.inc
#
# Auxiliary routine to be sourced by suite/funcs_1/t/is_basics_mixed.test
#
# Check if INFORMATION_SCHEMA tables contain a schema_name like 'db_data%'.
#
# Author:
# 2008-01-23 mleich WL#4203 Reorganize and fix the data dictionary tests of
#                           testsuite funcs_1
#                   Create this script based on older scripts and new code.
#

# No column with the name of a database contained in:
#    character_sets collations collation_character_set_applicability
#    user_privileges
SELECT DISTINCT table_schema FROM information_schema.columns
WHERE table_schema LIKE 'db_data%';
SELECT DISTINCT table_schema FROM information_schema.column_privileges
WHERE table_schema LIKE 'db_data%';
SELECT DISTINCT constraint_schema,table_schema
FROM information_schema.key_column_usage
WHERE constraint_schema LIKE 'db_data%' OR table_schema LIKE 'db_data%';
SELECT DISTINCT routine_schema FROM information_schema.routines
WHERE routine_schema LIKE 'db_data%';
SELECT DISTINCT schema_name FROM information_schema.schemata
WHERE schema_name LIKE 'db_data%';
SELECT DISTINCT table_schema FROM information_schema.schema_privileges
WHERE table_schema LIKE 'db_data%';
SELECT DISTINCT table_schema,index_schema FROM information_schema.statistics
WHERE table_schema LIKE 'db_data%' OR index_schema LIKE 'db_data%';
SELECT DISTINCT table_schema FROM information_schema.tables
WHERE table_schema LIKE 'db_data%';
SELECT DISTINCT constraint_schema,table_schema
FROM information_schema.table_constraints
WHERE constraint_schema LIKE 'db_data%' OR table_schema LIKE 'db_data%';
SELECT DISTINCT table_schema FROM information_schema.table_privileges
WHERE table_schema LIKE 'db_data%';
SELECT DISTINCT trigger_schema,event_object_schema
FROM information_schema.triggers
WHERE trigger_schema LIKE 'db_data%' OR event_object_schema LIKE 'db_data%';
SELECT DISTINCT table_schema FROM information_schema.views
WHERE table_schema LIKE 'db_data%';

${this.title}

Code Editor : basics_mixed3.inc