Wrong warning for CAST(TIME('10:20:30') AS DATE) + INTERVAL 1 DAY

Description

A confusing warning is printed in the following SQL script:

The word "Truncated" is not appropriate here.

The expected warning is something like:
"Incorrect datetime value: '0000-00:00 00:00:00'"
or
"Incorrect date value: '0000-00:00".

A warning generated in MySQL-5.1 and 5.5 is also not perfect:
Incorrect datetime value: '10:20:30'
But at least does not contain the confusing word "Truncated".

Environment

None

Status

Assignee

Alexander Barkov

Reporter

Alexander Barkov

Labels

None

External issue ID

None

External issue ID

None

Fix versions

Affects versions

Priority

Minor
Configure