~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: 2010-10-09 04:44:38 UTC
  • mto: (1827.1.1 trunk-drizzle)
  • mto: This revision was merged to the branch mainline in revision 1828.
  • Revision ID: brian@tangent.org-20101009044438-inypezfli460whto
First pass on moving show create schema out.

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
 
504
 
4
506
5
5
SELECT count(*) FROM indexes;
6
6
count(*)
7
7
0
354
354
SCHEMA_NAME
355
355
SCHEMA_NAME
356
356
SCHEMA_NAME
 
357
SCHEMA_NAME
357
358
SCHEMA_OWNER
 
359
SCHEMA_SQL_DEFINITION
358
360
SCHEMA_UPDATE_TIME
359
361
SCHEMA_UUID
360
362
SCHEMA_VERSION
824
826
DATA_DICTIONARY SCHEMAS SCHEMA_UPDATE_TIME
825
827
DATA_DICTIONARY SCHEMAS SCHEMA_UUID
826
828
DATA_DICTIONARY SCHEMAS SCHEMA_VERSION
 
829
DATA_DICTIONARY SCHEMA_SQL_DEFINITION   SCHEMA_NAME
 
830
DATA_DICTIONARY SCHEMA_SQL_DEFINITION   SCHEMA_SQL_DEFINITION
827
831
DATA_DICTIONARY SCOREBOARD_STATISTICS   MAX_USERS_LOGGED
828
832
DATA_DICTIONARY SCOREBOARD_STATISTICS   MEMORY_USAGE_BYTES
829
833
DATA_DICTIONARY SCOREBOARD_STATISTICS   NUMBER_OF_RANGE_LOCKS
1539
1543
SCHEMATA        INFORMATION_SCHEMA      DEFAULT_CHARACTER_SET_SCHEMA
1540
1544
SCHEMATA        INFORMATION_SCHEMA      SCHEMA_NAME
1541
1545
SCHEMATA        INFORMATION_SCHEMA      SCHEMA_OWNER
 
1546
SCHEMA_SQL_DEFINITION   DATA_DICTIONARY SCHEMA_NAME
 
1547
SCHEMA_SQL_DEFINITION   DATA_DICTIONARY SCHEMA_SQL_DEFINITION
1542
1548
SCOREBOARD_STATISTICS   DATA_DICTIONARY MAX_USERS_LOGGED
1543
1549
SCOREBOARD_STATISTICS   DATA_DICTIONARY MEMORY_USAGE_BYTES
1544
1550
SCOREBOARD_STATISTICS   DATA_DICTIONARY NUMBER_OF_RANGE_LOCKS
2046
2052
SCHEMATA        INFORMATION_SCHEMA      DEFAULT_CHARACTER_SET_SCHEMA
2047
2053
SCHEMATA        INFORMATION_SCHEMA      SCHEMA_NAME
2048
2054
SCHEMATA        INFORMATION_SCHEMA      SCHEMA_OWNER
 
2055
SCHEMA_SQL_DEFINITION   DATA_DICTIONARY SCHEMA_NAME
 
2056
SCHEMA_SQL_DEFINITION   DATA_DICTIONARY SCHEMA_SQL_DEFINITION
2049
2057
SCOREBOARD_STATISTICS   DATA_DICTIONARY MAX_USERS_LOGGED
2050
2058
SCOREBOARD_STATISTICS   DATA_DICTIONARY MEMORY_USAGE_BYTES
2051
2059
SCOREBOARD_STATISTICS   DATA_DICTIONARY NUMBER_OF_RANGE_LOCKS