~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Lee Bieber
  • Date: 2010-11-13 23:44:42 UTC
  • mfrom: (1927.2.2 trunk)
  • Revision ID: kalebral@gmail.com-20101113234442-zaihys061gmpswvl
Merge Brian - Add table function so that you can see set @var style variables

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
 
478
 
4
480
5
5
SELECT count(*) FROM indexes;
6
6
count(*)
7
7
0
476
476
VARIABLE_NAME
477
477
VARIABLE_NAME
478
478
VARIABLE_NAME
 
479
VARIABLE_NAME
 
480
VARIABLE_VALUE
479
481
VARIABLE_VALUE
480
482
VARIABLE_VALUE
481
483
VARIABLE_VALUE
831
833
DATA_DICTIONARY TABLE_DEFINITION_CACHE  TABLE_NAME
832
834
DATA_DICTIONARY TABLE_DEFINITION_CACHE  TABLE_SCHEMA
833
835
DATA_DICTIONARY TABLE_DEFINITION_CACHE  VERSION
 
836
DATA_DICTIONARY USER_DEFINED_VARIABLES  VARIABLE_NAME
 
837
DATA_DICTIONARY USER_DEFINED_VARIABLES  VARIABLE_VALUE
834
838
DATA_DICTIONARY USER_LOCKS      SESSION_ID
835
839
DATA_DICTIONARY USER_LOCKS      USER_LOCK_NAME
836
840
DATA_DICTIONARY USER_LOCKS      USER_NAME
1541
1545
TABLE_PRIVILEGES        INFORMATION_SCHEMA      TABLE_CATALOG
1542
1546
TABLE_PRIVILEGES        INFORMATION_SCHEMA      TABLE_NAME
1543
1547
TABLE_PRIVILEGES        INFORMATION_SCHEMA      TABLE_SCHEMA
 
1548
USER_DEFINED_VARIABLES  DATA_DICTIONARY VARIABLE_NAME
 
1549
USER_DEFINED_VARIABLES  DATA_DICTIONARY VARIABLE_VALUE
1544
1550
USER_LOCKS      DATA_DICTIONARY SESSION_ID
1545
1551
USER_LOCKS      DATA_DICTIONARY USER_LOCK_NAME
1546
1552
USER_LOCKS      DATA_DICTIONARY USER_NAME
2022
2028
TABLE_PRIVILEGES        INFORMATION_SCHEMA      TABLE_CATALOG
2023
2029
TABLE_PRIVILEGES        INFORMATION_SCHEMA      TABLE_NAME
2024
2030
TABLE_PRIVILEGES        INFORMATION_SCHEMA      TABLE_SCHEMA
 
2031
USER_DEFINED_VARIABLES  DATA_DICTIONARY VARIABLE_NAME
 
2032
USER_DEFINED_VARIABLES  DATA_DICTIONARY VARIABLE_VALUE
2025
2033
USER_LOCKS      DATA_DICTIONARY SESSION_ID
2026
2034
USER_LOCKS      DATA_DICTIONARY USER_LOCK_NAME
2027
2035
USER_LOCKS      DATA_DICTIONARY USER_NAME