← 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

  • Committer: Brian Aker
  • Date: 2011-02-22 23:14:37 UTC
  • mfrom: (2192.1.2 drizzle-staging)
  • Revision ID: brian@tangent.org-20110222231437-s9vawppxyq1s6ldk
Rollup changes in build.

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
 
566
 
4
568
5
5
SELECT count(*) FROM indexes;
6
6
count(*)
7
7
2
271
271
IS_NULLABLE
272
272
IS_NULL_CALL
273
273
IS_ORDER_REVERSE
 
274
IS_REPLICATED
 
275
IS_REPLICATED
274
276
IS_RESULT
275
277
IS_SIGNED
276
278
IS_UNIQUE
617
619
  `ENUM_VALUES` VARCHAR(1024) DEFAULT NULL,
618
620
  `COLLATION_NAME` VARCHAR(256) NOT NULL,
619
621
  `COLUMN_COMMENT` VARCHAR(1024) DEFAULT NULL
620
 
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATION = FALSE
 
622
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
621
623
show create table INDEXES ;
622
624
Table   Create Table
623
625
INDEXES CREATE TABLE `INDEXES` (
630
632
  `KEY_LENGTH` BIGINT NOT NULL,
631
633
  `INDEX_TYPE` VARCHAR(256) NOT NULL,
632
634
  `INDEX_COMMENT` VARCHAR(1024) DEFAULT NULL
633
 
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATION = FALSE
 
635
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
634
636
show create table INDEX_PARTS ;
635
637
Table   Create Table
636
638
INDEX_PARTS     CREATE TABLE `INDEX_PARTS` (
645
647
  `IS_USED_IN_PRIMARY` BOOLEAN NOT NULL,
646
648
  `IS_UNIQUE` BOOLEAN NOT NULL,
647
649
  `IS_NULLABLE` BOOLEAN NOT NULL
648
 
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATION = FALSE
 
650
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
649
651
show create table REFERENTIAL_CONSTRAINTS ;
650
652
Table   Create Table
651
653
show create table SCHEMAS ;
657
659
  `SCHEMA_UPDATE_TIME` VARCHAR(256) NOT NULL,
658
660
  `SCHEMA_UUID` VARCHAR(36) DEFAULT NULL,
659
661
  `SCHEMA_VERSION` BIGINT DEFAULT NULL,
660
 
  `SCHEMA_USE_COUNT` BIGINT DEFAULT NULL
661
 
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATION = FALSE
 
662
  `SCHEMA_USE_COUNT` BIGINT DEFAULT NULL,
 
663
  `IS_REPLICATED` BOOLEAN NOT NULL
 
664
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
662
665
show create table TABLES ;
663
666
Table   Create Table
664
667
TABLES  CREATE TABLE `TABLES` (
674
677
  `TABLE_COMMENT` VARCHAR(2048) DEFAULT NULL,
675
678
  `AUTO_INCREMENT` BIGINT NOT NULL,
676
679
  `TABLE_UUID` VARCHAR(36) DEFAULT NULL,
677
 
  `TABLE_VERSION` BIGINT DEFAULT NULL
678
 
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATION = FALSE
 
680
  `TABLE_VERSION` BIGINT DEFAULT NULL,
 
681
  `IS_REPLICATED` BOOLEAN NOT NULL
 
682
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
679
683
show create table TABLE_CONSTRAINTS ;
680
684
Table   Create Table
681
685
TABLE_CONSTRAINTS       CREATE TABLE `TABLE_CONSTRAINTS` (
684
688
  `TABLE_SCHEMA` VARCHAR(256) NOT NULL,
685
689
  `TABLE_NAME` VARCHAR(256) NOT NULL,
686
690
  `CONSTRAINT_TYPE` VARCHAR(256) NOT NULL
687
 
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATION = FALSE
 
691
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
688
692
CREATE SCHEMA A;
689
693
use A;
690
694
create table A (a int);
945
949
DATA_DICTIONARY REPLICATION_STREAMS     APPLIER
946
950
DATA_DICTIONARY REPLICATION_STREAMS     REPLICATOR
947
951
DATA_DICTIONARY SCHEMAS DEFAULT_COLLATION_NAME
 
952
DATA_DICTIONARY SCHEMAS IS_REPLICATED
948
953
DATA_DICTIONARY SCHEMAS SCHEMA_CREATION_TIME
949
954
DATA_DICTIONARY SCHEMAS SCHEMA_NAME
950
955
DATA_DICTIONARY SCHEMAS SCHEMA_UPDATE_TIME
969
974
DATA_DICTIONARY SYS_REPLICATION_LOG     SEGID
970
975
DATA_DICTIONARY TABLES  AUTO_INCREMENT
971
976
DATA_DICTIONARY TABLES  ENGINE
 
977
DATA_DICTIONARY TABLES  IS_REPLICATED
972
978
DATA_DICTIONARY TABLES  ROW_FORMAT
973
979
DATA_DICTIONARY TABLES  TABLE_ARCHETYPE
974
980
DATA_DICTIONARY TABLES  TABLE_COLLATION
1717
1723
ROUTINE_COLUMNS INFORMATION_SCHEMA      TABLE_NAME
1718
1724
ROUTINE_COLUMNS INFORMATION_SCHEMA      TABLE_SCHEMA
1719
1725
SCHEMAS DATA_DICTIONARY DEFAULT_COLLATION_NAME
 
1726
SCHEMAS DATA_DICTIONARY IS_REPLICATED
1720
1727
SCHEMAS DATA_DICTIONARY SCHEMA_CREATION_TIME
1721
1728
SCHEMAS DATA_DICTIONARY SCHEMA_NAME
1722
1729
SCHEMAS DATA_DICTIONARY SCHEMA_UPDATE_TIME
1747
1754
SYS_REPLICATION_LOG     DATA_DICTIONARY SEGID
1748
1755
TABLES  DATA_DICTIONARY AUTO_INCREMENT
1749
1756
TABLES  DATA_DICTIONARY ENGINE
 
1757
TABLES  DATA_DICTIONARY IS_REPLICATED
1750
1758
TABLES  DATA_DICTIONARY ROW_FORMAT
1751
1759
TABLES  DATA_DICTIONARY TABLE_ARCHETYPE
1752
1760
TABLES  DATA_DICTIONARY TABLE_COLLATION
2286
2294
ROUTINE_COLUMNS INFORMATION_SCHEMA      TABLE_NAME
2287
2295
ROUTINE_COLUMNS INFORMATION_SCHEMA      TABLE_SCHEMA
2288
2296
SCHEMAS DATA_DICTIONARY DEFAULT_COLLATION_NAME
 
2297
SCHEMAS DATA_DICTIONARY IS_REPLICATED
2289
2298
SCHEMAS DATA_DICTIONARY SCHEMA_CREATION_TIME
2290
2299
SCHEMAS DATA_DICTIONARY SCHEMA_NAME
2291
2300
SCHEMAS DATA_DICTIONARY SCHEMA_UPDATE_TIME
2316
2325
SYS_REPLICATION_LOG     DATA_DICTIONARY SEGID
2317
2326
TABLES  DATA_DICTIONARY AUTO_INCREMENT
2318
2327
TABLES  DATA_DICTIONARY ENGINE
 
2328
TABLES  DATA_DICTIONARY IS_REPLICATED
2319
2329
TABLES  DATA_DICTIONARY ROW_FORMAT
2320
2330
TABLES  DATA_DICTIONARY TABLE_ARCHETYPE
2321
2331
TABLES  DATA_DICTIONARY TABLE_COLLATION