← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Andrew Hutchings
  • Date: 2011-01-31 15:25:23 UTC
  • mto: (2136.1.1 build)
  • mto: This revision was merged to the branch mainline in revision 2137.
  • Revision ID: andrew@linuxjedi.co.uk-20110131152523-izqoc14ktipz3v5g
Fix test cases

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
 
558
 
4
557
5
5
SELECT count(*) FROM indexes;
6
6
count(*)
7
7
0
142
142
CONSTRAINT_TABLE
143
143
CONSTRAINT_TYPE
144
144
CONSTRAINT_TYPE
 
145
COUNTER
145
146
COUNT_ADMIN
146
147
COUNT_ADMIN
147
148
COUNT_ALTER
360
361
POS
361
362
PRIVILEGE_TYPE
362
363
PRIVILEGE_TYPE
 
364
PROTOCOL
363
365
PRTYPE
364
366
REFERENCED_TABLE_COLUMNS
365
367
REFERENCED_TABLE_NAME
543
545
USER_DEFINED_TYPE_SCHEMA
544
546
USER_LOCK_NAME
545
547
USER_NAME
546
 
VARIABLE_NAME
547
 
VARIABLE_NAME
548
 
VARIABLE_NAME
549
 
VARIABLE_NAME
550
 
VARIABLE_NAME
551
 
VARIABLE_NAME
552
 
VARIABLE_NAME
553
 
VARIABLE_NAME
554
 
VARIABLE_NAME
555
 
VARIABLE_NAME
556
 
VARIABLE_VALUE
557
 
VARIABLE_VALUE
 
548
VALUE
 
549
VARIABLE_NAME
 
550
VARIABLE_NAME
 
551
VARIABLE_NAME
 
552
VARIABLE_NAME
 
553
VARIABLE_NAME
 
554
VARIABLE_NAME
 
555
VARIABLE_NAME
 
556
VARIABLE_NAME
558
557
VARIABLE_VALUE
559
558
VARIABLE_VALUE
560
559
VARIABLE_VALUE
765
764
DATA_DICTIONARY CURRENT_SQL_COMMANDS    COUNT_UPDATE
766
765
DATA_DICTIONARY CURRENT_SQL_COMMANDS    IP
767
766
DATA_DICTIONARY CURRENT_SQL_COMMANDS    USERNAME
768
 
DATA_DICTIONARY DRIZZLE_PROTOCOL_STATUS VARIABLE_NAME
769
 
DATA_DICTIONARY DRIZZLE_PROTOCOL_STATUS VARIABLE_VALUE
770
767
DATA_DICTIONARY ERRORS  ERROR_CODE
771
768
DATA_DICTIONARY ERRORS  ERROR_MESSAGE
772
769
DATA_DICTIONARY ERRORS  ERROR_NAME
917
914
DATA_DICTIONARY MODULES MODULE_LICENSE
918
915
DATA_DICTIONARY MODULES MODULE_NAME
919
916
DATA_DICTIONARY MODULES MODULE_VERSION
920
 
DATA_DICTIONARY MYSQL_PROTOCOL_STATUS   VARIABLE_NAME
921
 
DATA_DICTIONARY MYSQL_PROTOCOL_STATUS   VARIABLE_VALUE
922
917
DATA_DICTIONARY PLUGINS IS_ACTIVE
923
918
DATA_DICTIONARY PLUGINS MODULE_NAME
924
919
DATA_DICTIONARY PLUGINS PLUGIN_NAME
932
927
DATA_DICTIONARY PROCESSLIST     STATE
933
928
DATA_DICTIONARY PROCESSLIST     TIME
934
929
DATA_DICTIONARY PROCESSLIST     USERNAME
 
930
DATA_DICTIONARY PROTOCOL_COUNTERS       COUNTER
 
931
DATA_DICTIONARY PROTOCOL_COUNTERS       PROTOCOL
 
932
DATA_DICTIONARY PROTOCOL_COUNTERS       VALUE
935
933
DATA_DICTIONARY REPLICATION_STREAMS     APPLIER
936
934
DATA_DICTIONARY REPLICATION_STREAMS     REPLICATOR
937
935
DATA_DICTIONARY SCHEMAS DEFAULT_COLLATION_NAME
1406
1404
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      DOMAIN_SCHEMA
1407
1405
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      INITIALLY_DEFERRED
1408
1406
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      IS_DEFERRABLE
1409
 
DRIZZLE_PROTOCOL_STATUS DATA_DICTIONARY VARIABLE_NAME
1410
 
DRIZZLE_PROTOCOL_STATUS DATA_DICTIONARY VARIABLE_VALUE
1411
1407
ERRORS  DATA_DICTIONARY ERROR_CODE
1412
1408
ERRORS  DATA_DICTIONARY ERROR_MESSAGE
1413
1409
ERRORS  DATA_DICTIONARY ERROR_NAME
1566
1562
MODULES DATA_DICTIONARY MODULE_LICENSE
1567
1563
MODULES DATA_DICTIONARY MODULE_NAME
1568
1564
MODULES DATA_DICTIONARY MODULE_VERSION
1569
 
MYSQL_PROTOCOL_STATUS   DATA_DICTIONARY VARIABLE_NAME
1570
 
MYSQL_PROTOCOL_STATUS   DATA_DICTIONARY VARIABLE_VALUE
1571
1565
PARAMETERS      INFORMATION_SCHEMA      AS_LOCATOR
1572
1566
PARAMETERS      INFORMATION_SCHEMA      CHARACTER_MAXIMUM_LENGTH
1573
1567
PARAMETERS      INFORMATION_SCHEMA      CHARACTER_OCTET_LENGTH
1611
1605
PROCESSLIST     DATA_DICTIONARY STATE
1612
1606
PROCESSLIST     DATA_DICTIONARY TIME
1613
1607
PROCESSLIST     DATA_DICTIONARY USERNAME
 
1608
PROTOCOL_COUNTERS       DATA_DICTIONARY COUNTER
 
1609
PROTOCOL_COUNTERS       DATA_DICTIONARY PROTOCOL
 
1610
PROTOCOL_COUNTERS       DATA_DICTIONARY VALUE
1614
1611
REFERENTIAL_CONSTRAINTS INFORMATION_SCHEMA      CONSTRAINT_CATALOG
1615
1612
REFERENTIAL_CONSTRAINTS INFORMATION_SCHEMA      CONSTRAINT_NAME
1616
1613
REFERENTIAL_CONSTRAINTS INFORMATION_SCHEMA      CONSTRAINT_SCHEMA
1967
1964
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      DOMAIN_SCHEMA
1968
1965
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      INITIALLY_DEFERRED
1969
1966
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      IS_DEFERRABLE
1970
 
DRIZZLE_PROTOCOL_STATUS DATA_DICTIONARY VARIABLE_NAME
1971
 
DRIZZLE_PROTOCOL_STATUS DATA_DICTIONARY VARIABLE_VALUE
1972
1967
ERRORS  DATA_DICTIONARY ERROR_CODE
1973
1968
ERRORS  DATA_DICTIONARY ERROR_MESSAGE
1974
1969
ERRORS  DATA_DICTIONARY ERROR_NAME
2127
2122
MODULES DATA_DICTIONARY MODULE_LICENSE
2128
2123
MODULES DATA_DICTIONARY MODULE_NAME
2129
2124
MODULES DATA_DICTIONARY MODULE_VERSION
2130
 
MYSQL_PROTOCOL_STATUS   DATA_DICTIONARY VARIABLE_NAME
2131
 
MYSQL_PROTOCOL_STATUS   DATA_DICTIONARY VARIABLE_VALUE
2132
2125
PARAMETERS      INFORMATION_SCHEMA      AS_LOCATOR
2133
2126
PARAMETERS      INFORMATION_SCHEMA      CHARACTER_MAXIMUM_LENGTH
2134
2127
PARAMETERS      INFORMATION_SCHEMA      CHARACTER_OCTET_LENGTH
2172
2165
PROCESSLIST     DATA_DICTIONARY STATE
2173
2166
PROCESSLIST     DATA_DICTIONARY TIME
2174
2167
PROCESSLIST     DATA_DICTIONARY USERNAME
 
2168
PROTOCOL_COUNTERS       DATA_DICTIONARY COUNTER
 
2169
PROTOCOL_COUNTERS       DATA_DICTIONARY PROTOCOL
 
2170
PROTOCOL_COUNTERS       DATA_DICTIONARY VALUE
2175
2171
REFERENTIAL_CONSTRAINTS INFORMATION_SCHEMA      CONSTRAINT_CATALOG
2176
2172
REFERENTIAL_CONSTRAINTS INFORMATION_SCHEMA      CONSTRAINT_NAME
2177
2173
REFERENTIAL_CONSTRAINTS INFORMATION_SCHEMA      CONSTRAINT_SCHEMA