~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-09-10 16:41:50 UTC
  • mto: (1759.2.1 build)
  • mto: This revision was merged to the branch mainline in revision 1762.
  • Revision ID: brian@tangent.org-20100910164150-grktr2kjfgvk4iw2
This add a couple of utility table functions to be used with testing.

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
 
494
 
4
497
5
5
SELECT count(*) FROM indexes;
6
6
count(*)
7
7
0
482
482
USER_DEFINED_TYPE_NAME
483
483
USER_DEFINED_TYPE_SCHEMA
484
484
Unique
 
485
VALUE
 
486
VALUE
 
487
VALUE
485
488
VARIABLE_NAME
486
489
VARIABLE_NAME
487
490
VARIABLE_NAME
656
659
DATA_DICTIONARY COLUMNS ORDINAL_POSITION
657
660
DATA_DICTIONARY COLUMNS TABLE_NAME
658
661
DATA_DICTIONARY COLUMNS TABLE_SCHEMA
 
662
DATA_DICTIONARY COUNTER VALUE
659
663
DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS COUNT_ADMIN
660
664
DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS COUNT_ALTER
661
665
DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS COUNT_COMMIT
787
791
DATA_DICTIONARY PROCESSLIST     STATE
788
792
DATA_DICTIONARY PROCESSLIST     TIME
789
793
DATA_DICTIONARY PROCESSLIST     USER
 
794
DATA_DICTIONARY RANDOM_NUMBER   VALUE
 
795
DATA_DICTIONARY RANDOM_STRING   VALUE
790
796
DATA_DICTIONARY REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME
791
797
DATA_DICTIONARY REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
792
798
DATA_DICTIONARY REFERENTIAL_CONSTRAINTS DELETE_RULE
1207
1213
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_CATALOG
1208
1214
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_NAME
1209
1215
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_SCHEMA
 
1216
COUNTER DATA_DICTIONARY VALUE
1210
1217
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_ADMIN
1211
1218
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_ALTER
1212
1219
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_COMMIT
1401
1408
PROCESSLIST     DATA_DICTIONARY STATE
1402
1409
PROCESSLIST     DATA_DICTIONARY TIME
1403
1410
PROCESSLIST     DATA_DICTIONARY USER
 
1411
RANDOM_NUMBER   DATA_DICTIONARY VALUE
 
1412
RANDOM_STRING   DATA_DICTIONARY VALUE
1404
1413
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY CONSTRAINT_NAME
1405
1414
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY CONSTRAINT_SCHEMA
1406
1415
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY DELETE_RULE
1704
1713
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_CATALOG
1705
1714
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_NAME
1706
1715
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_SCHEMA
 
1716
COUNTER DATA_DICTIONARY VALUE
1707
1717
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_ADMIN
1708
1718
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_ALTER
1709
1719
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_COMMIT
1898
1908
PROCESSLIST     DATA_DICTIONARY STATE
1899
1909
PROCESSLIST     DATA_DICTIONARY TIME
1900
1910
PROCESSLIST     DATA_DICTIONARY USER
 
1911
RANDOM_NUMBER   DATA_DICTIONARY VALUE
 
1912
RANDOM_STRING   DATA_DICTIONARY VALUE
1901
1913
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY CONSTRAINT_NAME
1902
1914
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY CONSTRAINT_SCHEMA
1903
1915
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY DELETE_RULE