[MDEV-17209] App-period: unexpected warning on delete - Jira

XML

Word

Printable

Reporduce

create or replace table t (id int, s date, e date, period for apptime(s,e));

delete from t for portion of apptime from 777222333 to '2018-01-01';

show warnings;

Result

+---------+------+------------------------------------------------+

| Level   | Code | Message                                        |

+---------+------+------------------------------------------------+

| Warning | 1292 | Truncated incorrect DOUBLE value: '2018-01-01' |

+---------+------+------------------------------------------------+

Expected
It should print warning about first argument, not the second as it works ok. In fact it should fail with error, because when it treats wrong type as a zero date it leads to unexpected result.

relates to

MDEV-16973 Application-time periods: DELETE