In 7.1.2 you could do a
select * from foo where
and it will do what you expect. In 7.2 this
will not return rows. You have to do:
where bar is
If you want to test this at home, here is a test script:
create table null_test ( index integer primary key, value varchar ); insert into null_test (index, value) values (1, NULL); insert into null_test (index, value) values (2, 'baz'); select * from null_test where value=NULL; select * from null_test where value is NULL; drop table null_test;I think that a global search and replace of =NULL and = Null will fix this. At least that is what I am going to try.