← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

Merge to trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/schema_dictionary/tests/r/data_dictionary.result
1
1
use data_dictionary;
2
2
SELECT count(*) FROM columns;
3
3
count(*)
4
 
496
 
4
497
5
5
SELECT count(*) FROM indexes;
6
6
count(*)
7
7
0
20
20
APPLIER
21
21
AS_LOCATOR
22
22
AUTO_INCREMENT
 
23
AUTO_INCREMENT
23
24
AVG_ROW_LENGTH
24
25
Auto_increment
25
26
Avg_row_length
568
569
  `COLUMN_NAME` VARCHAR(256) NOT NULL,
569
570
  `COLUMN_NUMBER` BIGINT NOT NULL,
570
571
  `SEQUENCE_IN_INDEX` BIGINT NOT NULL,
571
 
  `COMPARE_LENGTH` BIGINT NOT NULL,
 
572
  `COMPARE_LENGTH` BIGINT DEFAULT NULL,
572
573
  `IS_ORDER_REVERSE` VARCHAR(5) NOT NULL,
573
574
  `IS_USED_IN_PRIMARY` VARCHAR(5) NOT NULL,
574
575
  `IS_UNIQUE` VARCHAR(5) NOT NULL,
606
607
  `TABLE_COLLATION` VARCHAR(256) NOT NULL,
607
608
  `TABLE_CREATION_TIME` VARCHAR(256) NOT NULL,
608
609
  `TABLE_UPDATE_TIME` VARCHAR(256) NOT NULL,
609
 
  `TABLE_COMMENT` VARCHAR(2048) DEFAULT NULL
 
610
  `TABLE_COMMENT` VARCHAR(2048) DEFAULT NULL,
 
611
  `AUTO_INCREMENT` BIGINT NOT NULL
610
612
) ENGINE=FunctionEngine COLLATE = utf8_general_ci
611
613
show create table TABLE_CONSTRAINTS ;
612
614
Table   Create Table
846
848
DATA_DICTIONARY SHOW_TEMPORARY_TABLES   RECORD_LENGTH
847
849
DATA_DICTIONARY SHOW_TEMPORARY_TABLES   TABLE_NAME
848
850
DATA_DICTIONARY SHOW_TEMPORARY_TABLES   TABLE_SCHEMA
 
851
DATA_DICTIONARY TABLES  AUTO_INCREMENT
849
852
DATA_DICTIONARY TABLES  ENGINE
850
853
DATA_DICTIONARY TABLES  ROW_FORMAT
851
854
DATA_DICTIONARY TABLES  TABLE_COLLATION
1553
1556
SHOW_TEMPORARY_TABLES   DATA_DICTIONARY RECORD_LENGTH
1554
1557
SHOW_TEMPORARY_TABLES   DATA_DICTIONARY TABLE_NAME
1555
1558
SHOW_TEMPORARY_TABLES   DATA_DICTIONARY TABLE_SCHEMA
 
1559
TABLES  DATA_DICTIONARY AUTO_INCREMENT
1556
1560
TABLES  DATA_DICTIONARY ENGINE
1557
1561
TABLES  DATA_DICTIONARY ROW_FORMAT
1558
1562
TABLES  DATA_DICTIONARY TABLE_COLLATION
2052
2056
SHOW_TEMPORARY_TABLES   DATA_DICTIONARY RECORD_LENGTH
2053
2057
SHOW_TEMPORARY_TABLES   DATA_DICTIONARY TABLE_NAME
2054
2058
SHOW_TEMPORARY_TABLES   DATA_DICTIONARY TABLE_SCHEMA
 
2059
TABLES  DATA_DICTIONARY AUTO_INCREMENT
2055
2060
TABLES  DATA_DICTIONARY ENGINE
2056
2061
TABLES  DATA_DICTIONARY ROW_FORMAT
2057
2062
TABLES  DATA_DICTIONARY TABLE_COLLATION