Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
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