create table t (a int); | |
create table t2 (b int); | |
create table t3 (c int); | |
insert into t values(3),(10); | |
explain select a from t,t2,t3 where | |
(a>3 and null between 0 and 10) is null | |
; | |
explain select a from t,t2,t3 where | |
(a>5 or null between 0 and 10) and (a*a < 101) | |
and t.a=t2.b and t.a=t3.c | |
; |