Re: WHERE Date = '' MySQL 8

[Peter Brawley]

select version();
+-----------+
| version() |
+-----------+
| 8.0.16    |
+-----------+
use test;
drop table if exists t;
create table t(d date);
set @@sql_mode='allow_invalid_dates';
select @@sql_mode;
+---------------------+
| @@sql_mode          |
+---------------------+
| ALLOW_INVALID_DATES |
+---------------------+
insert into t values('');
select d from t;                                        -- NOTE NO ERROR
+------------+
| d          |
+------------+
| 0000-00-00 |
+------------+
set @@sql_mode='allow_invalid_dates,strict_all_tables'; -- NOTE ERROR
select @@sql_mode;
insert into t values('');
Error: Incorrect date value: '' for column 'd' at row 1