← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/delete.test

  • Committer: Jay Pipes
  • Date: 2009-02-21 16:00:06 UTC
  • mto: (907.1.1 trunk-with-temporal)
  • mto: This revision was merged to the branch mainline in revision 908.
  • Revision ID: jpipes@serialcoder-20090221160006-vnk3wt4qbcz62eru
Removes the TIME column type and related time functions.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/delete.test
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