Re: Oracle Bug? SQL not returning correct rows.

From: Thorsten Kettner <thorsten.kettner_at_web.de>
Date: 13 Feb 2007 03:43:02 -0800
Message-ID: <1171366982.260141.102790@a34g2000cwb.googlegroups.com>

> Why don't the results from Query 1 match the results from Query 3?

As both Query 1 and Query 3 look exactly like this, only differing in the IN clause

  select bill_of_lading, qty
  from ps_rsc_ar820_tbl
  where bill_of_lading IN ( ... )

it should be impossible that Query 1 returns five records for bill_of_lading = M353655 and Query 3 returns just one. There are only two possible reasons for it as far as I can see it: 1. A bug in Oracle. 2. Your actual query differs from what you posted. The second reason is much more likely than the first one, however. Maybe you tried to simplify your query for posting it here and accidentally removed the critical part? Received on Tue Feb 13 2007 - 05:43:02 CST