Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.5.36, 10.0.8
-
None
-
None
Description
drop table if exists t1;
|
create table t1 (a int);
|
insert into t1 values (0);
|
select last_day(a), last_day(0) from t1;
|
+-------------+-------------+
|
| last_day(a) | last_day(0) |
|
+-------------+-------------+
|
| NULL | NULL |
|
+-------------+-------------+
|
1 row in set, 1 warning (0.00 sec)
|
 |
show warnings;
|
+---------+------+-------------------------------+
|
| Level | Code | Message |
|
+---------+------+-------------------------------+
|
| Warning | 1292 | Incorrect datetime value: '0' |
|
+---------+------+-------------------------------+
|
There is only one warning.
Two warnings are expected.