Details
Description
If put something like dbug_print_items in the beginning of JOIN::prepare it catches passing unusable conds.
One case was on second execution MDEV-14786 but there are other
Attachments
Issue Links
- relates to
-
MDEV-14786 Server crashes in Item_cond::transform on 2nd execution of SP querying from a view
-
- Closed
-
create table t1 (i int, row_start timestamp(6) not null default now(),
row_end timestamp(6) not null default '2038-01-19 04:14:07.999999');
create view v1 as select i from t1 where i < 5 and (row_end =
TIMESTAMP'2030-01-01 0:0:0' or row_end is null);
create procedure pr(x int) select i from v1;
#set debug_dbug='d,where';
call pr(1);
call pr(2);
drop procedure pr;
drop view v1;
drop table t1;