~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/delete.test

  • Committer: Padraig
  • Date: 2009-03-01 04:15:34 UTC
  • mfrom: (908 drizzle)
  • mto: (934.3.2 mordred)
  • mto: This revision was merged to the branch mainline in revision 938.
  • Revision ID: posulliv@linux-lap-20090301041534-3p2c1l2l2436cczq
MergeĀ fromĀ trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
185
185
# BUG#30385 "Server crash when deleting with order by and limit"
186
186
CREATE TABLE t1 (
187
187
  `date` date ,
188
 
  `time` time ,
189
188
  `seq` int NOT NULL auto_increment,
190
189
  PRIMARY KEY  (`seq`),
191
190
  KEY `seq` (`seq`),
192
 
  KEY `time` (`time`),
193
191
  KEY `date` (`date`)
194
192
);
195
 
DELETE FROM t1 ORDER BY date ASC, time ASC LIMIT 1;
 
193
DELETE FROM t1 ORDER BY date ASC LIMIT 1;
196
194
drop table t1;
197
195
 
198
196
--echo End of 4.1 tests