Re: Inconsistent Query Results
From: Adam Ruth <owski_at_hotmail.com>
Date: 25 Jun 2003 07:38:36 -0700
Message-ID: <f0f51c80.0306250638.232f79c0_at_posting.google.com>
Date: 25 Jun 2003 07:38:36 -0700
Message-ID: <f0f51c80.0306250638.232f79c0_at_posting.google.com>
LKBrwn_DBA <member30625_at_dbforums.com> wrote in message news:<3038469.1056484024_at_dbforums.com>...
> Did you check that OS_NAME is not NULL???
>
> NULLs in any OS_NAME will produce invalid results in your query.
There are no nulls in the os_name column. Even so, I disagree with your assertion. Just because row x has a null value doesn't change the fact that row y exists. select ... where os_name = 'SunOS' should always return the same 5 records (in my table) no matter how many other records have a null os_name.
In any event, nulls or not, an index shouldn't change the query results, should it?
Adam Ruth Received on Wed Jun 25 2003 - 16:38:36 CEST