~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

Merge with 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
 
552
 
4
558
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
681
687
SELECT TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME from COLUMNS ORDER BY TABLE_SCHEMA,TABLE_NAME, COLUMN_NAME;
682
688
TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME
683
689
A       A       a
 
690
DATA_DICTIONARY CATALOGS        CATALOG_CREATION_TIME
 
691
DATA_DICTIONARY CATALOGS        CATALOG_NAME
 
692
DATA_DICTIONARY CATALOGS        CATALOG_UPDATE_TIME
 
693
DATA_DICTIONARY CATALOGS        CATALOG_UUID
 
694
DATA_DICTIONARY CATALOGS        CATALOG_VERSION
 
695
DATA_DICTIONARY CATALOG_CACHE   CATALOG_NAME
684
696
DATA_DICTIONARY CHARACTER_SETS  CHARACTER_SET_NAME
685
697
DATA_DICTIONARY CHARACTER_SETS  DEFAULT_COLLATE_NAME
686
698
DATA_DICTIONARY CHARACTER_SETS  DESCRIPTION
1236
1248
SELECT TABLE_NAME,TABLE_SCHEMA,COLUMN_NAME from COLUMNS ORDER BY TABLE_SCHEMA,TABLE_NAME, COLUMN_NAME;
1237
1249
TABLE_NAME      TABLE_SCHEMA    COLUMN_NAME
1238
1250
A       A       a
 
1251
CATALOGS        DATA_DICTIONARY CATALOG_CREATION_TIME
 
1252
CATALOGS        DATA_DICTIONARY CATALOG_NAME
 
1253
CATALOGS        DATA_DICTIONARY CATALOG_UPDATE_TIME
 
1254
CATALOGS        DATA_DICTIONARY CATALOG_UUID
 
1255
CATALOGS        DATA_DICTIONARY CATALOG_VERSION
 
1256
CATALOG_CACHE   DATA_DICTIONARY CATALOG_NAME
1239
1257
CHARACTER_SETS  DATA_DICTIONARY CHARACTER_SET_NAME
1240
1258
CHARACTER_SETS  DATA_DICTIONARY DEFAULT_COLLATE_NAME
1241
1259
CHARACTER_SETS  DATA_DICTIONARY DESCRIPTION
1791
1809
SELECT TABLE_NAME,TABLE_SCHEMA,COLUMN_NAME from COLUMNS ORDER BY TABLE_NAME,TABLE_SCHEMA, COLUMN_NAME;
1792
1810
TABLE_NAME      TABLE_SCHEMA    COLUMN_NAME
1793
1811
A       A       a
 
1812
CATALOGS        DATA_DICTIONARY CATALOG_CREATION_TIME
 
1813
CATALOGS        DATA_DICTIONARY CATALOG_NAME
 
1814
CATALOGS        DATA_DICTIONARY CATALOG_UPDATE_TIME
 
1815
CATALOGS        DATA_DICTIONARY CATALOG_UUID
 
1816
CATALOGS        DATA_DICTIONARY CATALOG_VERSION
 
1817
CATALOG_CACHE   DATA_DICTIONARY CATALOG_NAME
1794
1818
CHARACTER_SETS  DATA_DICTIONARY CHARACTER_SET_NAME
1795
1819
CHARACTER_SETS  DATA_DICTIONARY DEFAULT_COLLATE_NAME
1796
1820
CHARACTER_SETS  DATA_DICTIONARY DESCRIPTION