← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/innodb_mysql.result

  • Committer: Padraig O'Sullivan
  • Date: 2009-09-13 01:03:01 UTC
  • mto: (1126.9.2 captain-20090915-01)
  • mto: This revision was merged to the branch mainline in revision 1133.
  • Revision ID: osullivan.padraig@gmail.com-20090913010301-tcvvezipx1124acy
Added calls to the dtrace delete begin/end probes.

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` (