~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/innodb_mysql.result

  • Committer: Brian Aker
  • Date: 2010-02-14 02:02:48 UTC
  • mfrom: (1273.13.64 fix_is)
  • Revision ID: brian@gaz-20100214020248-bhovaejhz9fmer3q
MergeĀ inĀ data_dictionary.

Show diffs side-by-side

added added

removed removed

Lines of Context:
1132
1132
# - initial check;
1133
1133
 
1134
1134
SELECT table_schema, table_name, row_format
1135
 
FROM INFORMATION_SCHEMA.TABLES
 
1135
FROM data_dictionary.TABLES
1136
1136
WHERE table_schema = DATABASE() AND table_name = 't1';
1137
1137
table_schema    table_name      row_format
1138
 
test    t1      Compact
 
1138
test    t1      COMPACT
1139
1139
 
1140
1140
# - change ROW_FORMAT and check;
1141
1141
 
1142
1142
ALTER TABLE t1 ROW_FORMAT = REDUNDANT;
1143
1143
 
1144
1144
SELECT table_schema, table_name, row_format
1145
 
FROM INFORMATION_SCHEMA.TABLES
 
1145
FROM data_dictionary.TABLES
1146
1146
WHERE table_schema = DATABASE() AND table_name = 't1';
1147
1147
table_schema    table_name      row_format
1148
 
test    t1      Redundant
 
1148
test    t1      REDUNDANT
1149
1149
 
1150
1150
# - that's it, cleanup.
1151
1151