| 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 | |
| ; |