Re: optimizer seems to skip stored function call in where clause?

[John LeSueur]

Here is the simplest reproduce script we have found, and this still exists as of 8.0.18.

drop table if exists t1;
create table t1 (id int PRIMARY KEY);
insert into t1 VALUES(1234);
drop function if exists returnzero;
create function returnzero() returns int(11)
begin
return 0;
end;
select 1 from t1 where t1.id = '1234' and 1=returnzero();
select 1 from t1 where t1.id = 1234 and 1=returnzero();