[MDEV-17478] Wrong result for TIME('+100:20:30') - Jira

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 +

blocks

MDEV-16991 Rounding vs truncation for TIME, DATETIME, TIMESTAMP

relates to

MDEV-17563 Different results using table or view when comparing values of time type