← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_time.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:
tests/r/func_time.result
348
348
create table t1 (d date, dt datetime, t timestamp, c char(10));
349
349
insert into t1 values (null, null, null, null);
350
350
insert into t1 values ("0000-00-00", "0000-00-00", "0000-00-00", "0000-00-00");
351
 
ERROR HY000: Received an invalid datetime value '0000-00-00'.
 
351
ERROR HY000: Received an invalid DATE value '0000-00-00'.
352
352
select dayofyear("0000-00-00"),dayofyear(d),dayofyear(dt),dayofyear(t),dayofyear(c) from t1;
353
353
ERROR HY000: Received an invalid datetime value '0000-00-00'.
354
354
select dayofmonth("0000-00-00"),dayofmonth(d),dayofmonth(dt),dayofmonth(t),dayofmonth(c) from t1;