← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/information_schema_dictionary/tests/r/tables.result

updating to latest trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/information_schema_dictionary/tests/r/tables.result
2
2
CATALOG_NAME    SCHEMA_NAME     SCHEMA_OWNER    DEFAULT_CHARACTER_SET_CATALOG   DEFAULT_CHARACTER_SET_SCHEMA    DEFAULT_CHARACTER_SET_NAME
3
3
        data_dictionary NULL    NULL    NULL    NULL
4
4
        information_schema      NULL    NULL    NULL    NULL
5
 
        mysql   NULL    NULL    NULL    NULL
6
 
        test    NULL    NULL    NULL    NULL
 
5
LOCAL   mysql   NULL    NULL    NULL    NULL
 
6
LOCAL   test    NULL    NULL    NULL    NULL
7
7
select * from INFORMATION_SCHEMA.TABLES;
8
8
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE
 
9
LOCAL   DATA_DICTIONARY CATALOGS        VIEW
 
10
LOCAL   DATA_DICTIONARY CATALOG_CACHE   VIEW
9
11
LOCAL   DATA_DICTIONARY CHARACTER_SETS  VIEW
10
12
LOCAL   DATA_DICTIONARY COLLATIONS      VIEW
11
13
LOCAL   DATA_DICTIONARY COLUMNS VIEW
84
86
test
85
87
select * from INFORMATION_SCHEMA.TABLES;
86
88
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE
 
89
LOCAL   DATA_DICTIONARY CATALOGS        VIEW
 
90
LOCAL   DATA_DICTIONARY CATALOG_CACHE   VIEW
87
91
LOCAL   DATA_DICTIONARY CHARACTER_SETS  VIEW
88
92
LOCAL   DATA_DICTIONARY COLLATIONS      VIEW
89
93
LOCAL   DATA_DICTIONARY COLUMNS VIEW
185
189
LOCAL   INFORMATION_SCHEMA      VIEW_TABLE_USAGE        VIEW
186
190
select * from INFORMATION_SCHEMA.TABLES ORDER BY TABLE_SCHEMA, TABLE_NAME;
187
191
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE
 
192
LOCAL   DATA_DICTIONARY CATALOGS        VIEW
 
193
LOCAL   DATA_DICTIONARY CATALOG_CACHE   VIEW
188
194
LOCAL   DATA_DICTIONARY CHARACTER_SETS  VIEW
189
195
LOCAL   DATA_DICTIONARY COLLATIONS      VIEW
190
196
LOCAL   DATA_DICTIONARY COLUMNS VIEW
286
292
LOCAL   a       aa      BASE
287
293
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME like "%s";
288
294
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE
 
295
LOCAL   DATA_DICTIONARY CATALOGS        VIEW
289
296
LOCAL   DATA_DICTIONARY CHARACTER_SETS  VIEW
290
297
LOCAL   DATA_DICTIONARY COLLATIONS      VIEW
291
298
LOCAL   DATA_DICTIONARY COLUMNS VIEW