~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/innodb.result

  • Committer: Brian Aker
  • Date: 2009-11-20 22:34:27 UTC
  • mto: (1223.1.7 push) (1226.1.2 push)
  • mto: This revision was merged to the branch mainline in revision 1225.
  • Revision ID: brian@gaz-20091120223427-9knkzo5a04cufgmz
Removes options from DDL left in Cursor for admin operations (they were
MyISAM specific... we need to put in a generic one).

Note: Left checksum and its ability to do internal/external.

Show diffs side-by-side

added added

removed removed

Lines of Context:
1134
1134
insert t1 values (1, "aaa", "bbb"), (NULL, "", "ccccc"), (0, NULL, "");
1135
1135
insert t2 select * from t1;
1136
1136
insert t3 select * from t1;
1137
 
checksum table t1, t2, t3, t4 quick;
1138
 
Table   Checksum
1139
 
test.t1 NULL
1140
 
test.t2 NULL
1141
 
test.t3 NULL
1142
 
test.t4 NULL
1143
 
Warnings:
1144
 
Error   1146    Table 'test.t4' doesn't exist
1145
 
checksum table t1, t2, t3, t4;
1146
 
Table   Checksum
1147
 
test.t1 2948697075
1148
 
test.t2 2948697075
1149
 
test.t3 2948697075
1150
 
test.t4 NULL
1151
 
Warnings:
1152
 
Error   1146    Table 'test.t4' doesn't exist
1153
 
checksum table t1, t2, t3, t4 extended;
 
1137
checksum table t1, t2, t3, t4;
 
1138
Table   Checksum
 
1139
test.t1 2948697075
 
1140
test.t2 2948697075
 
1141
test.t3 2948697075
 
1142
test.t4 NULL
 
1143
Warnings:
 
1144
Error   1146    Table 'test.t4' doesn't exist
 
1145
checksum table t1, t2, t3, t4;
 
1146
Table   Checksum
 
1147
test.t1 2948697075
 
1148
test.t2 2948697075
 
1149
test.t3 2948697075
 
1150
test.t4 NULL
 
1151
Warnings:
 
1152
Error   1146    Table 'test.t4' doesn't exist
 
1153
checksum table t1, t2, t3, t4;
1154
1154
Table   Checksum
1155
1155
test.t1 2948697075
1156
1156
test.t2 2948697075