← Back to branch summary

~thomir-deactivatedaccount/drizzle/drizzle-fix-bug653747

« back to all changes in this revision

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

  • Committer: Brian Aker
  • Date: 2010-10-10 02:07:52 UTC
  • mfrom: (1827.2.3 staging)
  • Revision ID: brian@tangent.org-20101010020752-ktv73isay5dxtvp3
Merge in switch on table_share_instance inheritance.

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
 
510
 
4
506
5
5
SELECT count(*) FROM indexes;
6
6
count(*)
7
7
0
358
358
SCHEMA_OWNER
359
359
SCHEMA_SQL_DEFINITION
360
360
SCHEMA_UPDATE_TIME
361
 
SCHEMA_USE_COUNT
362
361
SCHEMA_UUID
363
362
SCHEMA_VERSION
364
363
SCOPE_CATALOG
370
369
SCOREBOARD_SIZE
371
370
SEQUENCE_IN_INDEX
372
371
SESSION_ID
373
 
SESSION_ID
374
372
SORTLEN
375
373
SPECIFIC_CATALOG
376
374
SPECIFIC_CATALOG
495
493
USER_DEFINED_TYPE_CATALOG
496
494
USER_DEFINED_TYPE_NAME
497
495
USER_DEFINED_TYPE_SCHEMA
498
 
USER_LOCK_NAME
499
 
USER_NAME
500
496
Unique
501
497
VARIABLE_NAME
502
498
VARIABLE_NAME
609
605
  `SCHEMA_CREATION_TIME` VARCHAR(256) NOT NULL,
610
606
  `SCHEMA_UPDATE_TIME` VARCHAR(256) NOT NULL,
611
607
  `SCHEMA_UUID` VARCHAR(36) DEFAULT NULL,
612
 
  `SCHEMA_VERSION` BIGINT DEFAULT NULL,
613
 
  `SCHEMA_USE_COUNT` BIGINT DEFAULT NULL
 
608
  `SCHEMA_VERSION` BIGINT DEFAULT NULL
614
609
) ENGINE=FunctionEngine COLLATE = utf8_general_ci
615
610
show create table TABLES ;
616
611
Table   Create Table
829
824
DATA_DICTIONARY SCHEMAS SCHEMA_CREATION_TIME
830
825
DATA_DICTIONARY SCHEMAS SCHEMA_NAME
831
826
DATA_DICTIONARY SCHEMAS SCHEMA_UPDATE_TIME
832
 
DATA_DICTIONARY SCHEMAS SCHEMA_USE_COUNT
833
827
DATA_DICTIONARY SCHEMAS SCHEMA_UUID
834
828
DATA_DICTIONARY SCHEMAS SCHEMA_VERSION
835
829
DATA_DICTIONARY SCHEMA_SQL_DEFINITION   SCHEMA_NAME
906
900
DATA_DICTIONARY TABLE_DEFINITION_CACHE  VERSION
907
901
DATA_DICTIONARY TABLE_SQL_DEFINITION    TABLE_NAME
908
902
DATA_DICTIONARY TABLE_SQL_DEFINITION    TABLE_SQL_DEFINITION
909
 
DATA_DICTIONARY USER_LOCKS      SESSION_ID
910
 
DATA_DICTIONARY USER_LOCKS      USER_LOCK_NAME
911
 
DATA_DICTIONARY USER_LOCKS      USER_NAME
912
903
INFORMATION_SCHEMA      CHECK_CONSTRAINTS       CHECK_CLAUSE
913
904
INFORMATION_SCHEMA      CHECK_CONSTRAINTS       CONSTRAINT_CATALOG
914
905
INFORMATION_SCHEMA      CHECK_CONSTRAINTS       CONSTRAINT_NAME
1544
1535
SCHEMAS DATA_DICTIONARY SCHEMA_CREATION_TIME
1545
1536
SCHEMAS DATA_DICTIONARY SCHEMA_NAME
1546
1537
SCHEMAS DATA_DICTIONARY SCHEMA_UPDATE_TIME
1547
 
SCHEMAS DATA_DICTIONARY SCHEMA_USE_COUNT
1548
1538
SCHEMAS DATA_DICTIONARY SCHEMA_UUID
1549
1539
SCHEMAS DATA_DICTIONARY SCHEMA_VERSION
1550
1540
SCHEMATA        INFORMATION_SCHEMA      CATALOG_NAME
1648
1638
TABLE_PRIVILEGES        INFORMATION_SCHEMA      TABLE_SCHEMA
1649
1639
TABLE_SQL_DEFINITION    DATA_DICTIONARY TABLE_NAME
1650
1640
TABLE_SQL_DEFINITION    DATA_DICTIONARY TABLE_SQL_DEFINITION
1651
 
USER_LOCKS      DATA_DICTIONARY SESSION_ID
1652
 
USER_LOCKS      DATA_DICTIONARY USER_LOCK_NAME
1653
 
USER_LOCKS      DATA_DICTIONARY USER_NAME
1654
1641
VIEWS   INFORMATION_SCHEMA      TABLE_CATALOG
1655
1642
VIEWS   INFORMATION_SCHEMA      TABLE_NAME
1656
1643
VIEWS   INFORMATION_SCHEMA      TABLE_SCHEMA
2057
2044
SCHEMAS DATA_DICTIONARY SCHEMA_CREATION_TIME
2058
2045
SCHEMAS DATA_DICTIONARY SCHEMA_NAME
2059
2046
SCHEMAS DATA_DICTIONARY SCHEMA_UPDATE_TIME
2060
 
SCHEMAS DATA_DICTIONARY SCHEMA_USE_COUNT
2061
2047
SCHEMAS DATA_DICTIONARY SCHEMA_UUID
2062
2048
SCHEMAS DATA_DICTIONARY SCHEMA_VERSION
2063
2049
SCHEMATA        INFORMATION_SCHEMA      CATALOG_NAME
2161
2147
TABLE_PRIVILEGES        INFORMATION_SCHEMA      TABLE_SCHEMA
2162
2148
TABLE_SQL_DEFINITION    DATA_DICTIONARY TABLE_NAME
2163
2149
TABLE_SQL_DEFINITION    DATA_DICTIONARY TABLE_SQL_DEFINITION
2164
 
USER_LOCKS      DATA_DICTIONARY SESSION_ID
2165
 
USER_LOCKS      DATA_DICTIONARY USER_LOCK_NAME
2166
 
USER_LOCKS      DATA_DICTIONARY USER_NAME
2167
2150
VIEWS   INFORMATION_SCHEMA      TABLE_CATALOG
2168
2151
VIEWS   INFORMATION_SCHEMA      TABLE_NAME
2169
2152
VIEWS   INFORMATION_SCHEMA      TABLE_SCHEMA