← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/func_time.test

  • 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/t/func_time.test
197
197
select quarter("0000-00-00"),quarter(d),quarter(dt),quarter(t),quarter(c) from t1;
198
198
--error 1686 # Argh.  0000-00-00 is not a date.
199
199
select year("0000-00-00"),year(d),year(dt),year(t),year(c) from t1;
200
 
select to_days("0000-00-00"),to_days(d),to_days(dt),to_days(t),to_days(c) from t1;
 
200
select to_days("0000-00-00"),to_days(d),to_days(dt),to_days(c) from t1;
201
201
--error 1686 # Ugh. bad datetime
202
202
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;
203
203
drop table t1;