← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_time.result

  • Committer: Monty Taylor
  • Date: 2009-02-11 23:45:52 UTC
  • mfrom: (881 drizzle)
  • mto: This revision was merged to the branch mainline in revision 885.
  • Revision ID: mordred@inaugust.com-20090211234552-d57gtqlup0pr7g13
Merged trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/func_time.result
384
384
ERROR HY000: Received an invalid datetime value '0000-00-00'.
385
385
select year("0000-00-00"),year(d),year(dt),year(t),year(c) from t1;
386
386
ERROR HY000: Received an invalid datetime value '0000-00-00'.
387
 
select to_days("0000-00-00"),to_days(d),to_days(dt),to_days(t),to_days(c) from t1;
388
 
to_days("0000-00-00")   to_days(d)      to_days(dt)     to_days(t)      to_days(c)
389
 
NULL    NULL    NULL    733814  NULL
 
387
select to_days("0000-00-00"),to_days(d),to_days(dt),to_days(c) from t1;
 
388
to_days("0000-00-00")   to_days(d)      to_days(dt)     to_days(c)
 
389
NULL    NULL    NULL    NULL
390
390
Warnings:
391
391
Warning 1292    Incorrect datetime value: '0000-00-00'
392
392
select extract(MONTH FROM "0000-00-00"),extract(MONTH FROM d),extract(MONTH FROM dt),extract(MONTH FROM t),extract(MONTH FROM c) from t1;