← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/r/information_schema-big.result

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/information_schema-big.result
 
1
DROP TABLE IF EXISTS t0,t1,t2,t3,t4,t5;
 
2
DROP VIEW IF EXISTS v1;
 
3
#
 
4
# Bug#18925: subqueries with MIN/MAX functions on INFORMARTION_SCHEMA 
 
5
#
 
6
SELECT t.table_name, c1.column_name
 
7
FROM information_schema.tables t
 
8
INNER JOIN
 
9
information_schema.columns c1
 
10
ON t.table_schema = c1.table_schema AND
 
11
t.table_name = c1.table_name
 
12
WHERE t.table_schema = 'information_schema' AND
 
13
c1.ordinal_position =
 
14
( SELECT COALESCE(MIN(c2.ordinal_position),1)
 
15
FROM information_schema.columns c2
 
16
WHERE c2.table_schema = t.table_schema AND
 
17
c2.table_name = t.table_name AND
 
18
c2.column_name LIKE '%SCHEMA%'
 
19
        )
 
20
AND t.table_name NOT LIKE 'falcon%';
 
21
table_name      column_name
 
22
CHARACTER_SETS  CHARACTER_SET_NAME
 
23
COLLATIONS      COLLATION_NAME
 
24
COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME
 
25
COLUMNS TABLE_SCHEMA
 
26
COLUMN_PRIVILEGES       TABLE_SCHEMA
 
27
ENGINES ENGINE
 
28
EVENTS  EVENT_SCHEMA
 
29
FILES   TABLE_SCHEMA
 
30
GLOBAL_STATUS   VARIABLE_NAME
 
31
GLOBAL_VARIABLES        VARIABLE_NAME
 
32
KEY_COLUMN_USAGE        CONSTRAINT_SCHEMA
 
33
PARAMETERS      SPECIFIC_SCHEMA
 
34
PARTITIONS      TABLE_SCHEMA
 
35
PLUGINS PLUGIN_NAME
 
36
PROCESSLIST     ID
 
37
PROFILING       QUERY_ID
 
38
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
 
39
ROUTINES        ROUTINE_SCHEMA
 
40
SCHEMATA        SCHEMA_NAME
 
41
SCHEMA_PRIVILEGES       TABLE_SCHEMA
 
42
SESSION_STATUS  VARIABLE_NAME
 
43
SESSION_VARIABLES       VARIABLE_NAME
 
44
STATISTICS      TABLE_SCHEMA
 
45
TABLES  TABLE_SCHEMA
 
46
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
 
47
TABLE_PRIVILEGES        TABLE_SCHEMA
 
48
TRIGGERS        TRIGGER_SCHEMA
 
49
USER_PRIVILEGES GRANTEE
 
50
VIEWS   TABLE_SCHEMA
 
51
SELECT t.table_name, c1.column_name
 
52
FROM information_schema.tables t
 
53
INNER JOIN
 
54
information_schema.columns c1
 
55
ON t.table_schema = c1.table_schema AND
 
56
t.table_name = c1.table_name
 
57
WHERE t.table_schema = 'information_schema' AND
 
58
c1.ordinal_position =
 
59
( SELECT COALESCE(MIN(c2.ordinal_position),1)
 
60
FROM information_schema.columns c2
 
61
WHERE c2.table_schema = 'information_schema' AND
 
62
c2.table_name = t.table_name AND
 
63
c2.column_name LIKE '%SCHEMA%'
 
64
        )
 
65
AND t.table_name NOT LIKE 'falcon%';
 
66
table_name      column_name
 
67
CHARACTER_SETS  CHARACTER_SET_NAME
 
68
COLLATIONS      COLLATION_NAME
 
69
COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME
 
70
COLUMNS TABLE_SCHEMA
 
71
COLUMN_PRIVILEGES       TABLE_SCHEMA
 
72
ENGINES ENGINE
 
73
EVENTS  EVENT_SCHEMA
 
74
FILES   TABLE_SCHEMA
 
75
GLOBAL_STATUS   VARIABLE_NAME
 
76
GLOBAL_VARIABLES        VARIABLE_NAME
 
77
KEY_COLUMN_USAGE        CONSTRAINT_SCHEMA
 
78
PARAMETERS      SPECIFIC_SCHEMA
 
79
PARTITIONS      TABLE_SCHEMA
 
80
PLUGINS PLUGIN_NAME
 
81
PROCESSLIST     ID
 
82
PROFILING       QUERY_ID
 
83
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
 
84
ROUTINES        ROUTINE_SCHEMA
 
85
SCHEMATA        SCHEMA_NAME
 
86
SCHEMA_PRIVILEGES       TABLE_SCHEMA
 
87
SESSION_STATUS  VARIABLE_NAME
 
88
SESSION_VARIABLES       VARIABLE_NAME
 
89
STATISTICS      TABLE_SCHEMA
 
90
TABLES  TABLE_SCHEMA
 
91
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
 
92
TABLE_PRIVILEGES        TABLE_SCHEMA
 
93
TRIGGERS        TRIGGER_SCHEMA
 
94
USER_PRIVILEGES GRANTEE
 
95
VIEWS   TABLE_SCHEMA