← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_time.result

  • 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:
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;