now() + 1 results in illegal argument

[monetdb-team]

Date: 2012-01-18 17:20:50 +0100
From: @skinkie
To: SQL devs <>
Version: 11.13.3 (Oct2012)
CC: @njnes, @elpetrak

Last updated: 2013-01-22 09:29:19 +0100

Comment 16782

Date: 2012-01-18 17:20:50 +0100
From: @skinkie

User-Agent: Mozilla/5.0 (X11; Linux i686) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.83 Safari/535.2
Build Identifier:

sql>select now() + 1;
IllegalArgumentException:calc.second_interval:illegal argument

(yeah it should be done with interval)

Reproducible: Always

Comment 17552

Date: 2012-07-21 19:03:59 +0200
From: @grobian

sql>select now() + interval '1' day;
+----------------------------------+
| current_timestamp |
+==================================+
| 2012-07-22 18:03:33.000000+01:00 |
+----------------------------------+
1 tuple (0.613ms)

I guess this bug is then just about making the error message a bit more clear?

Comment 17666

Date: 2012-08-24 14:54:32 +0200
From: @sjoerdmullender

Jul2012-SP1 has been released.

Comment 18047

Date: 2012-11-27 13:03:25 +0100
From: @elpetrak

To make a test for this case, I should have a substraction (now()-now()) in order to have a stable result. However, this substraction returns an error. Moreover, the query returns an error when the interval unit is smaller than second (e.g., millisecond).

Comment 18207

Date: 2012-11-28 13:45:54 +0100
From: @elpetrak

Changeset 973503cfeacd made by Eleni Petraki petraki@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=973503cfeacd

Changeset description:

Add test for bug #2978 (now() + 1 results in illegal argument).

Comment 18217

Date: 2012-11-28 19:33:37 +0100
From: @njnes

addition/substraction of timestamps isn't supported. We now give a proper error.

Comment 18386

Date: 2013-01-22 09:29:19 +0100
From: @sjoerdmullender

Oct2012-SP3 has been released.