- 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.
|