Re: Finding a SQL bug in 9.2.0.8

"DG problem" <skatefree_at_gmail.com> a écrit dans le message de news: 1cdd426f-cb03-41e5-8ddb-fbb40632ab18_at_l43g2000hsh.googlegroups.com...
| 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?
|
|

Post a simple test case that reproduces the problem.

Regards
Michel Received on Fri Sep 05 2008 - 10:14:55 CDT