← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/innodb_mysql.result

  • Committer: Stewart Smith
  • Date: 2009-08-20 17:15:54 UTC
  • mto: (1119.2.2 merge)
  • mto: This revision was merged to the branch mainline in revision 1124.
  • Revision ID: stewart@flamingspork.com-20090820171554-72eo1tqlc4n64rak
Valgrind 3.5 requires --alignment to be a power of 2 between 16 and 4096. The specifying --alignment is not important for us, so remove it.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/innodb_mysql.result
1132
1132
# - initial check;
1133
1133
 
1134
1134
SELECT table_schema, table_name, row_format
1135
 
FROM data_dictionary.TABLES
 
1135
FROM INFORMATION_SCHEMA.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 data_dictionary.TABLES
 
1145
FROM INFORMATION_SCHEMA.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
 
1153
1153
create table t1(a char(10) not null, unique key aa(a(1)),
1154
1154
b char(4) not null, unique key bb(b(4))) engine=innodb;
1155
1155
desc t1;
1156
 
Field   Type    Null    Default Default_is_NULL On_Update
1157
 
a       VARCHAR FALSE           FALSE   
1158
 
b       VARCHAR FALSE           FALSE   
 
1156
Field   Type    Null    Key     Default Extra
 
1157
a       varchar(10)     NO      UNI     NULL    
 
1158
b       varchar(4)      NO      PRI     NULL    
1159
1159
show create table t1;
1160
1160
Table   Create Table
1161
1161
t1      CREATE TABLE `t1` (