Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.0, 10.1, 10.2, 10.3, 10.4
-
Fix Version/s: 10.4.0
-
Component/s: Temporal Types
-
Labels:None
Description
SELECT TIME('+100:20:30'); |
+--------------------+
|
| TIME('+100:20:30') |
|
+--------------------+
|
| 00:00:00 |
|
+--------------------+
|
1 row in set, 1 warning (0.00 sec)
|
Looks wrong. The expected result is '100:20:30'.
The literal plays a role of an interval string here:
<interval string> ::= <quote> <unquoted interval string> <quote>
|
<unquoted interval string> ::= [ <sign> ] { <year-month literal> | <day-time literal> }
|
<sign> ::= <plus sign> | <minus sign>
|
So it should understand both - and +
Attachments
Issue Links
- blocks
-
MDEV-16991 Rounding vs truncation for TIME, DATETIME, TIMESTAMP
-
- Closed
-
- relates to
-
MDEV-17563 Different results using table or view when comparing values of time type
-
- Closed
-