~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/schema_dictionary/tests/r/data_dictionary.result

Merge catalog with current trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
1
use data_dictionary;
2
2
SELECT count(*) FROM columns;
3
3
count(*)
4
 
550
 
4
556
5
5
SELECT count(*) FROM indexes;
6
6
count(*)
7
7
0
29
29
BUF_POOL
30
30
BYTES_RECEIVED
31
31
BYTES_SENT
32
 
CATALOG_NAME
 
32
CATALOG_CREATION_TIME
 
33
CATALOG_NAME
 
34
CATALOG_NAME
 
35
CATALOG_NAME
 
36
CATALOG_UPDATE_TIME
 
37
CATALOG_UUID
 
38
CATALOG_VERSION
33
39
CHARACTER_MAXIMUM_LENGTH
34
40
CHARACTER_MAXIMUM_LENGTH
35
41
CHARACTER_MAXIMUM_LENGTH
677
683
SELECT TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME from COLUMNS ORDER BY TABLE_SCHEMA,TABLE_NAME, COLUMN_NAME;
678
684
TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME
679
685
A       A       a
 
686
DATA_DICTIONARY CATALOGS        CATALOG_CREATION_TIME
 
687
DATA_DICTIONARY CATALOGS        CATALOG_NAME
 
688
DATA_DICTIONARY CATALOGS        CATALOG_UPDATE_TIME
 
689
DATA_DICTIONARY CATALOGS        CATALOG_UUID
 
690
DATA_DICTIONARY CATALOGS        CATALOG_VERSION
 
691
DATA_DICTIONARY CATALOG_CACHE   CATALOG_NAME
680
692
DATA_DICTIONARY CHARACTER_SETS  CHARACTER_SET_NAME
681
693
DATA_DICTIONARY CHARACTER_SETS  DEFAULT_COLLATE_NAME
682
694
DATA_DICTIONARY CHARACTER_SETS  DESCRIPTION
1230
1242
SELECT TABLE_NAME,TABLE_SCHEMA,COLUMN_NAME from COLUMNS ORDER BY TABLE_SCHEMA,TABLE_NAME, COLUMN_NAME;
1231
1243
TABLE_NAME      TABLE_SCHEMA    COLUMN_NAME
1232
1244
A       A       a
 
1245
CATALOGS        DATA_DICTIONARY CATALOG_CREATION_TIME
 
1246
CATALOGS        DATA_DICTIONARY CATALOG_NAME
 
1247
CATALOGS        DATA_DICTIONARY CATALOG_UPDATE_TIME
 
1248
CATALOGS        DATA_DICTIONARY CATALOG_UUID
 
1249
CATALOGS        DATA_DICTIONARY CATALOG_VERSION
 
1250
CATALOG_CACHE   DATA_DICTIONARY CATALOG_NAME
1233
1251
CHARACTER_SETS  DATA_DICTIONARY CHARACTER_SET_NAME
1234
1252
CHARACTER_SETS  DATA_DICTIONARY DEFAULT_COLLATE_NAME
1235
1253
CHARACTER_SETS  DATA_DICTIONARY DESCRIPTION
1783
1801
SELECT TABLE_NAME,TABLE_SCHEMA,COLUMN_NAME from COLUMNS ORDER BY TABLE_NAME,TABLE_SCHEMA, COLUMN_NAME;
1784
1802
TABLE_NAME      TABLE_SCHEMA    COLUMN_NAME
1785
1803
A       A       a
 
1804
CATALOGS        DATA_DICTIONARY CATALOG_CREATION_TIME
 
1805
CATALOGS        DATA_DICTIONARY CATALOG_NAME
 
1806
CATALOGS        DATA_DICTIONARY CATALOG_UPDATE_TIME
 
1807
CATALOGS        DATA_DICTIONARY CATALOG_UUID
 
1808
CATALOGS        DATA_DICTIONARY CATALOG_VERSION
 
1809
CATALOG_CACHE   DATA_DICTIONARY CATALOG_NAME
1786
1810
CHARACTER_SETS  DATA_DICTIONARY CHARACTER_SET_NAME
1787
1811
CHARACTER_SETS  DATA_DICTIONARY DEFAULT_COLLATE_NAME
1788
1812
CHARACTER_SETS  DATA_DICTIONARY DESCRIPTION