← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/func_date_add.test

  • Committer: Olaf van der Spek
  • Date: 2011-02-12 18:24:24 UTC
  • mto: (2167.1.2 build) (2172.1.4 build)
  • mto: This revision was merged to the branch mainline in revision 2168.
  • Revision ID: olafvdspek@gmail.com-20110212182424-kgnm9osi7qo97at2
casts

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/func_date_add.test
55
55
insert into t1 values (date_add('2000-01-04', INTERVAL NULL DAY));
56
56
# These will all work now, and we'll end up with some NULL entries in the
57
57
# table and some warnings.
58
 
--error 1441
 
58
--error ER_DATETIME_FUNCTION_OVERFLOW
59
59
insert into t1 (d) select date_sub('2000-01-01', INTERVAL 2001 YEAR);
60
 
--error 1441
 
60
--error ER_DATETIME_FUNCTION_OVERFLOW
61
61
insert into t1 (d) select date_add('2000-01-01',interval 8000 year);
62
62
insert into t1 values (date_add(NULL, INTERVAL 1 DAY));
63
63
insert into t1 values (date_add('2000-01-04', INTERVAL NULL DAY));