You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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).
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:
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.
The text was updated successfully, but these errors were encountered: