~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/select.result

  • Committer: Lee Bieber
  • Date: 2011-01-27 23:29:23 UTC
  • mfrom: (2122.1.4 build)
  • Revision ID: kalebral@gmail.com-20110127232923-ixdrvdy5qatgkgh6
Merge Patrick - fix bug 708879: dbqp.py --suite option should handle comma-separated list
Merge Brian - more timestamp updates and fixes
Merge Patrick - fix bug 708861: dbqp.py not running on freebsd  
Merge Patrick - Added license text to dbqp-related files

Show diffs side-by-side

added added

removed removed

Lines of Context:
2818
2818
insert into t1 values(1,'2005-01-01'),(2,'2005-09-01'),(3,'2005-09-30'),
2819
2819
(4,'2005-10-01'),(5,'2005-12-30');
2820
2820
select * from t1 where f2 >= 0            order by f2;
2821
 
ERROR HY000: Received an invalid datetime value '0'.
 
2821
ERROR HY000: Received an invalid DATE value '0'.
2822
2822
select * from t1 where f2 >= '0000-00-00' order by f2;
2823
2823
ERROR HY000: Received an invalid datetime value '0000-00-00'.
2824
2824
select * from t1 where f2 >= '2005-09-31' order by f2;