~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

1) Fixed a couple of tests that were still relying on counts of tables in
schemas.
2) Removed utility dictionary from being loaded automatically.

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
 
499
 
4
496
5
5
SELECT count(*) FROM indexes;
6
6
count(*)
7
7
0
484
484
USER_DEFINED_TYPE_NAME
485
485
USER_DEFINED_TYPE_SCHEMA
486
486
Unique
487
 
VALUE
488
 
VALUE
489
 
VALUE
490
487
VARIABLE_NAME
491
488
VARIABLE_NAME
492
489
VARIABLE_NAME
665
662
DATA_DICTIONARY COLUMNS ORDINAL_POSITION
666
663
DATA_DICTIONARY COLUMNS TABLE_NAME
667
664
DATA_DICTIONARY COLUMNS TABLE_SCHEMA
668
 
DATA_DICTIONARY COUNTER VALUE
669
665
DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS COUNT_ADMIN
670
666
DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS COUNT_ALTER
671
667
DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS COUNT_COMMIT
797
793
DATA_DICTIONARY PROCESSLIST     STATE
798
794
DATA_DICTIONARY PROCESSLIST     TIME
799
795
DATA_DICTIONARY PROCESSLIST     USER
800
 
DATA_DICTIONARY RANDOM_NUMBER   VALUE
801
 
DATA_DICTIONARY RANDOM_STRING   VALUE
802
796
DATA_DICTIONARY REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME
803
797
DATA_DICTIONARY REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
804
798
DATA_DICTIONARY REFERENTIAL_CONSTRAINTS DELETE_RULE
1221
1215
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_CATALOG
1222
1216
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_NAME
1223
1217
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_SCHEMA
1224
 
COUNTER DATA_DICTIONARY VALUE
1225
1218
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_ADMIN
1226
1219
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_ALTER
1227
1220
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_COMMIT
1416
1409
PROCESSLIST     DATA_DICTIONARY STATE
1417
1410
PROCESSLIST     DATA_DICTIONARY TIME
1418
1411
PROCESSLIST     DATA_DICTIONARY USER
1419
 
RANDOM_NUMBER   DATA_DICTIONARY VALUE
1420
 
RANDOM_STRING   DATA_DICTIONARY VALUE
1421
1412
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY CONSTRAINT_NAME
1422
1413
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY CONSTRAINT_SCHEMA
1423
1414
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY DELETE_RULE
1723
1714
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_CATALOG
1724
1715
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_NAME
1725
1716
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_SCHEMA
1726
 
COUNTER DATA_DICTIONARY VALUE
1727
1717
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_ADMIN
1728
1718
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_ALTER
1729
1719
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_COMMIT
1918
1908
PROCESSLIST     DATA_DICTIONARY STATE
1919
1909
PROCESSLIST     DATA_DICTIONARY TIME
1920
1910
PROCESSLIST     DATA_DICTIONARY USER
1921
 
RANDOM_NUMBER   DATA_DICTIONARY VALUE
1922
 
RANDOM_STRING   DATA_DICTIONARY VALUE
1923
1911
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY CONSTRAINT_NAME
1924
1912
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY CONSTRAINT_SCHEMA
1925
1913
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY DELETE_RULE