405
405
create table t2 (id int not null, cur_date date not null);
406
406
insert into t1 (id, cur_date) values (1, '2007-04-25 18:30:22');
407
407
insert into t2 (id, cur_date) values (1, '2007-04-25');
417
Note 1003 select `test`.`t1`.`id` AS `id`,`test`.`t1`.`cur_date` AS `cur_date` from `test`.`t1` where <in_optimizer>(`test`.`t1`.`id`,<exists>(select 1 AS `Not_used` from `test`.`t1` `x1` where 0))
423
410
where id in (select id from t2 as x1 where (t2.cur_date is null));