*** pgsql/src/test/regress/sql/select.sql 2008/11/20 14:04:46 1.15 --- pgsql/src/test/regress/sql/select.sql 2009/09/29 01:20:34 1.16 *************** select sillysrf(42); *** 202,204 **** --- 202,209 ---- select sillysrf(-1) order by 1; drop function sillysrf(int); + + -- X = X isn't a no-op, it's effectively X IS NOT NULL assuming = is strict + -- (see bug #5084) + select * from (values (2),(null),(1)) v(k) where k = k order by k; + select * from (values (2),(null),(1)) v(k) where k = k;