Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
11.4.3
-
None
-
ubuntu,x86
Description
What I did:
There was a problem with the addition of TIME types when adding a time to another time and the result exceeded the 24-hour format. The result of the TIME type was not accurate.
An error occurred when '23:59:59' + TIME '00:01:00' was calculated.
CREATE TABLE t1( |
c1 TIME |
);
|
INSERT INTO t1 (c1) VALUES |
('00:00:01'), |
('23:59:59'); |
 |
SELECT c1 + TIME '00:01:00' < TIME '01:00:00' |
FROM t1; |
What I wanted to happen:
The SELECT statement should return ((1,), (0,)).
What actually happened:
The SELECT statement actually returned ((1,), (1,)).