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