~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-08-05 20:24:49 UTC
  • mto: (1688.1.1 drizzle)
  • mto: This revision was merged to the branch mainline in revision 1689.
  • Revision ID: brian@gaz-20100805202449-am05zi2zmjhklt8g
This fixes the lower casing of names from Schema even when we should not.

Show diffs side-by-side

added added

removed removed

Lines of Context:
614
614
use data_dictionary;
615
615
SELECT TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME from COLUMNS ORDER BY TABLE_SCHEMA,TABLE_NAME, COLUMN_NAME;
616
616
TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME
 
617
A       a       a
617
618
DATA_DICTIONARY CHARACTER_SETS  CHARACTER_SET_NAME
618
619
DATA_DICTIONARY CHARACTER_SETS  DEFAULT_COLLATE_NAME
619
620
DATA_DICTIONARY CHARACTER_SETS  DESCRIPTION
1100
1101
INFORMATION_SCHEMA      VIEW_TABLE_USAGE        TABLE_NAME
1101
1102
INFORMATION_SCHEMA      VIEW_TABLE_USAGE        TABLE_SCHEMA
1102
1103
INFORMATION_SCHEMA      VIEW_TABLE_USAGE        VIEW_DEFINITION
1103
 
a       a       a
1104
1104
SELECT TABLE_NAME,TABLE_SCHEMA,COLUMN_NAME from COLUMNS ORDER BY TABLE_SCHEMA,TABLE_NAME, COLUMN_NAME;
1105
1105
TABLE_NAME      TABLE_SCHEMA    COLUMN_NAME
1106
1106
CHARACTER_SETS  DATA_DICTIONARY CHARACTER_SET_NAME
1589
1589
VIEW_TABLE_USAGE        INFORMATION_SCHEMA      TABLE_NAME
1590
1590
VIEW_TABLE_USAGE        INFORMATION_SCHEMA      TABLE_SCHEMA
1591
1591
VIEW_TABLE_USAGE        INFORMATION_SCHEMA      VIEW_DEFINITION
1592
 
a       a       a
 
1592
a       A       a
1593
1593
SELECT TABLE_NAME,TABLE_SCHEMA,COLUMN_NAME from COLUMNS ORDER BY TABLE_NAME,TABLE_SCHEMA, COLUMN_NAME;
1594
1594
TABLE_NAME      TABLE_SCHEMA    COLUMN_NAME
1595
1595
CHARACTER_SETS  DATA_DICTIONARY CHARACTER_SET_NAME
2078
2078
VIEW_TABLE_USAGE        INFORMATION_SCHEMA      TABLE_NAME
2079
2079
VIEW_TABLE_USAGE        INFORMATION_SCHEMA      TABLE_SCHEMA
2080
2080
VIEW_TABLE_USAGE        INFORMATION_SCHEMA      VIEW_DEFINITION
2081
 
a       a       a
 
2081
a       A       a
2082
2082
DROP SCHEMA A;