Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.5, 10.0, 10.1, 10.2, 10.3, 10.4
-
Fix Version/s: 10.3.7
-
Component/s: Temporal Types
-
Labels:None
Description
SELECT TIMESTAMP'2001-01-01 10:20:30' - INTERVAL '10' YEAR AS c1, |
-INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c2; |
+---------------------+-----------------+
|
| c1 | c2 |
|
+---------------------+-----------------+
|
| 1991-01-01 10:20:30 | -20110101102030 |
|
+---------------------+-----------------+
|
The result for c2 is wrong. It should be the same with c1.
PostgreSQL returns correct results for the same query:
c1 | c2
|
---------------------+---------------------
|
1991-01-01 10:20:30 | 1991-01-01 10:20:30
|
Attachments
Issue Links
- relates to
-
MDEV-16156 PIPES_AS_CONCAT does not work well
-
- Open
-