Finding a SQL bug in 9.2.0.8

On a HP-UX machine running Oracle Enterprize 9208

This query (has been simplified)

select a,b
from t1
where (a,b) not in (
-- select * from (

      select a,b
      from t1
      where a in (1,2)

returns a different number of rows to this query

select a,b
from t1
where (a,b) not in (
  select * from (
    select a,b
    from t1
    where a in (1,2)
  )
);

The last query returns the correct number of rows.

The sub query has a complex select part which includes

Case When ... in (8,10) and Lag(...,1,null) over (order by ..., ...) = ...

This seems like a bug to me, but has anyone got any tips on finding the bug in metalink? Received on Fri Sep 05 2008 - 00:11:18 CDT