Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
Description
- 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.
Attachments
Issue Links
- relates to
-
MDEV-16973
Application-time periods: DELETE
-
- Closed
-