~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/select.test

  • Committer: Brian Aker
  • Date: 2011-01-26 21:05:29 UTC
  • mto: (2122.1.3 build)
  • mto: This revision was merged to the branch mainline in revision 2123.
  • Revision ID: brian@tangent.org-20110126210529-2y7gt9xg9fz1b29c
Fix error message on date.

Show diffs side-by-side

added added

removed removed

Lines of Context:
2589
2589
insert into t1 values(1,'2005-01-01'),(2,'2005-09-01'),(3,'2005-09-30'),
2590
2590
  (4,'2005-10-01'),(5,'2005-12-30');
2591
2591
# should return all records
2592
 
--error ER_INVALID_DATETIME_VALUE # Bad date
 
2592
--error ER_INVALID_DATE_VALUE # Bad date
2593
2593
select * from t1 where f2 >= 0            order by f2;
2594
2594
--error ER_INVALID_DATETIME_VALUE # Bad date
2595
2595
select * from t1 where f2 >= '0000-00-00' order by f2;