← 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-04-04 21:37:55 UTC
  • mfrom: (2241.6.2 drizzle-trunk)
  • mto: This revision was merged to the branch mainline in revision 2268.
  • Revision ID: brian@tangent.org-20110404213755-k4kl3qd5fkbvjmhe
Merge in owner tree.

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
 
580
 
4
582
5
5
SELECT count(*) FROM indexes;
6
6
count(*)
7
7
2
403
403
ROW_FORMAT
404
404
SAVEPOINT_NAME
405
405
SCHEMA_CREATION_TIME
 
406
SCHEMA_DEFINER
406
407
SCHEMA_LEVEL_ROUTINE
407
408
SCHEMA_NAME
408
409
SCHEMA_NAME
461
462
TABLE_COMMENT
462
463
TABLE_COUNT
463
464
TABLE_CREATION_TIME
 
465
TABLE_DEFINER
464
466
TABLE_ID
465
467
TABLE_ID
466
468
TABLE_ID
631
633
  `ENUM_VALUES` VARCHAR(1024) DEFAULT NULL,
632
634
  `COLLATION_NAME` VARCHAR(256) NOT NULL,
633
635
  `COLUMN_COMMENT` VARCHAR(1024) DEFAULT NULL
634
 
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
 
636
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER SYSTEM
635
637
show create table INDEXES ;
636
638
Table   Create Table
637
639
INDEXES CREATE TABLE `INDEXES` (
644
646
  `KEY_LENGTH` BIGINT NOT NULL,
645
647
  `INDEX_TYPE` VARCHAR(256) NOT NULL,
646
648
  `INDEX_COMMENT` VARCHAR(1024) DEFAULT NULL
647
 
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
 
649
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER SYSTEM
648
650
show create table INDEX_PARTS ;
649
651
Table   Create Table
650
652
INDEX_PARTS     CREATE TABLE `INDEX_PARTS` (
659
661
  `IS_USED_IN_PRIMARY` BOOLEAN NOT NULL,
660
662
  `IS_UNIQUE` BOOLEAN NOT NULL,
661
663
  `IS_NULLABLE` BOOLEAN NOT NULL
662
 
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
 
664
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER SYSTEM
663
665
show create table REFERENTIAL_CONSTRAINTS ;
664
666
ERROR 42S02: Unknown table 'data_dictionary.REFERENTIAL_CONSTRAINTS'
665
667
show create table SCHEMAS ;
672
674
  `SCHEMA_UUID` VARCHAR(36) DEFAULT NULL,
673
675
  `SCHEMA_VERSION` BIGINT DEFAULT NULL,
674
676
  `SCHEMA_USE_COUNT` BIGINT DEFAULT NULL,
675
 
  `IS_REPLICATED` BOOLEAN NOT NULL
676
 
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
 
677
  `IS_REPLICATED` BOOLEAN NOT NULL,
 
678
  `SCHEMA_DEFINER` VARCHAR(64) DEFAULT NULL
 
679
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER SYSTEM
677
680
show create table TABLES ;
678
681
Table   Create Table
679
682
TABLES  CREATE TABLE `TABLES` (
690
693
  `AUTO_INCREMENT` BIGINT NOT NULL,
691
694
  `TABLE_UUID` VARCHAR(36) DEFAULT NULL,
692
695
  `TABLE_VERSION` BIGINT DEFAULT NULL,
693
 
  `IS_REPLICATED` BOOLEAN NOT NULL
694
 
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
 
696
  `IS_REPLICATED` BOOLEAN NOT NULL,
 
697
  `TABLE_DEFINER` VARCHAR(64) DEFAULT NULL
 
698
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER SYSTEM
695
699
show create table TABLE_CONSTRAINTS ;
696
700
Table   Create Table
697
701
TABLE_CONSTRAINTS       CREATE TABLE `TABLE_CONSTRAINTS` (
700
704
  `TABLE_SCHEMA` VARCHAR(256) NOT NULL,
701
705
  `TABLE_NAME` VARCHAR(256) NOT NULL,
702
706
  `CONSTRAINT_TYPE` VARCHAR(256) NOT NULL
703
 
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
 
707
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER SYSTEM
704
708
CREATE SCHEMA A;
705
709
use A;
706
710
create table A (a int);
963
967
DATA_DICTIONARY SCHEMAS DEFAULT_COLLATION_NAME
964
968
DATA_DICTIONARY SCHEMAS IS_REPLICATED
965
969
DATA_DICTIONARY SCHEMAS SCHEMA_CREATION_TIME
 
970
DATA_DICTIONARY SCHEMAS SCHEMA_DEFINER
966
971
DATA_DICTIONARY SCHEMAS SCHEMA_NAME
967
972
DATA_DICTIONARY SCHEMAS SCHEMA_UPDATE_TIME
968
973
DATA_DICTIONARY SCHEMAS SCHEMA_USE_COUNT
1004
1009
DATA_DICTIONARY TABLES  TABLE_COLLATION
1005
1010
DATA_DICTIONARY TABLES  TABLE_COMMENT
1006
1011
DATA_DICTIONARY TABLES  TABLE_CREATION_TIME
 
1012
DATA_DICTIONARY TABLES  TABLE_DEFINER
1007
1013
DATA_DICTIONARY TABLES  TABLE_NAME
1008
1014
DATA_DICTIONARY TABLES  TABLE_SCHEMA
1009
1015
DATA_DICTIONARY TABLES  TABLE_TYPE
1749
1755
SCHEMAS DATA_DICTIONARY DEFAULT_COLLATION_NAME
1750
1756
SCHEMAS DATA_DICTIONARY IS_REPLICATED
1751
1757
SCHEMAS DATA_DICTIONARY SCHEMA_CREATION_TIME
 
1758
SCHEMAS DATA_DICTIONARY SCHEMA_DEFINER
1752
1759
SCHEMAS DATA_DICTIONARY SCHEMA_NAME
1753
1760
SCHEMAS DATA_DICTIONARY SCHEMA_UPDATE_TIME
1754
1761
SCHEMAS DATA_DICTIONARY SCHEMA_USE_COUNT
1796
1803
TABLES  DATA_DICTIONARY TABLE_COLLATION
1797
1804
TABLES  DATA_DICTIONARY TABLE_COMMENT
1798
1805
TABLES  DATA_DICTIONARY TABLE_CREATION_TIME
 
1806
TABLES  DATA_DICTIONARY TABLE_DEFINER
1799
1807
TABLES  DATA_DICTIONARY TABLE_NAME
1800
1808
TABLES  DATA_DICTIONARY TABLE_SCHEMA
1801
1809
TABLES  DATA_DICTIONARY TABLE_TYPE
2332
2340
SCHEMAS DATA_DICTIONARY DEFAULT_COLLATION_NAME
2333
2341
SCHEMAS DATA_DICTIONARY IS_REPLICATED
2334
2342
SCHEMAS DATA_DICTIONARY SCHEMA_CREATION_TIME
 
2343
SCHEMAS DATA_DICTIONARY SCHEMA_DEFINER
2335
2344
SCHEMAS DATA_DICTIONARY SCHEMA_NAME
2336
2345
SCHEMAS DATA_DICTIONARY SCHEMA_UPDATE_TIME
2337
2346
SCHEMAS DATA_DICTIONARY SCHEMA_USE_COUNT
2379
2388
TABLES  DATA_DICTIONARY TABLE_COLLATION
2380
2389
TABLES  DATA_DICTIONARY TABLE_COMMENT
2381
2390
TABLES  DATA_DICTIONARY TABLE_CREATION_TIME
 
2391
TABLES  DATA_DICTIONARY TABLE_DEFINER
2382
2392
TABLES  DATA_DICTIONARY TABLE_NAME
2383
2393
TABLES  DATA_DICTIONARY TABLE_SCHEMA
2384
2394
TABLES  DATA_DICTIONARY TABLE_TYPE