~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Monty Taylor
  • Date: 2010-10-05 16:22:12 UTC
  • mfrom: (1802.7.3 refactor)
  • Revision ID: mordred@inaugust.com-20101005162212-vdih5ps69hquz2s0
Rollup patch from Brian.

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
 
500
 
4
497
5
5
SELECT count(*) FROM indexes;
6
6
count(*)
7
7
0
485
485
USER_DEFINED_TYPE_NAME
486
486
USER_DEFINED_TYPE_SCHEMA
487
487
Unique
488
 
VALUE
489
 
VALUE
490
 
VALUE
491
488
VARIABLE_NAME
492
489
VARIABLE_NAME
493
490
VARIABLE_NAME
667
664
DATA_DICTIONARY COLUMNS ORDINAL_POSITION
668
665
DATA_DICTIONARY COLUMNS TABLE_NAME
669
666
DATA_DICTIONARY COLUMNS TABLE_SCHEMA
670
 
DATA_DICTIONARY COUNTER VALUE
671
667
DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS COUNT_ADMIN
672
668
DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS COUNT_ALTER
673
669
DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS COUNT_COMMIT
799
795
DATA_DICTIONARY PROCESSLIST     STATE
800
796
DATA_DICTIONARY PROCESSLIST     TIME
801
797
DATA_DICTIONARY PROCESSLIST     USER
802
 
DATA_DICTIONARY RANDOM_NUMBER   VALUE
803
 
DATA_DICTIONARY RANDOM_STRING   VALUE
804
798
DATA_DICTIONARY REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME
805
799
DATA_DICTIONARY REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
806
800
DATA_DICTIONARY REFERENTIAL_CONSTRAINTS DELETE_RULE
1224
1218
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_CATALOG
1225
1219
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_NAME
1226
1220
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_SCHEMA
1227
 
COUNTER DATA_DICTIONARY VALUE
1228
1221
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_ADMIN
1229
1222
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_ALTER
1230
1223
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_COMMIT
1419
1412
PROCESSLIST     DATA_DICTIONARY STATE
1420
1413
PROCESSLIST     DATA_DICTIONARY TIME
1421
1414
PROCESSLIST     DATA_DICTIONARY USER
1422
 
RANDOM_NUMBER   DATA_DICTIONARY VALUE
1423
 
RANDOM_STRING   DATA_DICTIONARY VALUE
1424
1415
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY CONSTRAINT_NAME
1425
1416
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY CONSTRAINT_SCHEMA
1426
1417
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY DELETE_RULE
1727
1718
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_CATALOG
1728
1719
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_NAME
1729
1720
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_SCHEMA
1730
 
COUNTER DATA_DICTIONARY VALUE
1731
1721
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_ADMIN
1732
1722
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_ALTER
1733
1723
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_COMMIT
1922
1912
PROCESSLIST     DATA_DICTIONARY STATE
1923
1913
PROCESSLIST     DATA_DICTIONARY TIME
1924
1914
PROCESSLIST     DATA_DICTIONARY USER
1925
 
RANDOM_NUMBER   DATA_DICTIONARY VALUE
1926
 
RANDOM_STRING   DATA_DICTIONARY VALUE
1927
1915
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY CONSTRAINT_NAME
1928
1916
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY CONSTRAINT_SCHEMA
1929
1917
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY DELETE_RULE