Re: 11g. Incorrect results returned from query.

From: DA Morgan <>
Date: Tue, 10 Jun 2008 08:17:29 -0700
Message-ID: <> wrote:

> On 31 May, 00:58, (Dan Blum) wrote:
>> Shakespeare <> wrote:
>>> "Dan Blum" <> schreef in bericht
>>> news:g1po2l$qf1$
>>>> wrote:
>>>>> Unfortunately we have attempted to re run our bulk load process (this
>>>>> is a DW app) from the beginning and the queries are now showing the
>>>>> correct results.
>>>>> The first issue we encontered of this type (which I alluded to in my
>>>>> first post)
>>>>>  is still repeatable...)
>>>>> Here is the example of that one. I think that the two must be related.
>>>> <snip>
>>>> I may be missing something obvious, but the results for all three queries
>>>> in this example looked correct to me - what is the problem?
>>>> --
>>>> _______________________________________________________________________
>>>> Dan Blum
>>>> "I wouldn't have believed it myself if I hadn't just made it up."
>>> There's a column missing when more than 4 values are returned fo a row.
>> Ah, I was expecting something similar to the other issue, where it was
>> rows that were missing. I thought this was just a SQL*Plus display issue.
>> --
>> _______________________________________________________________________
>> Dan Blum                                               
>> "I wouldn't have believed it myself if I hadn't just made it up."- Hide quoted text -
>> - Show quoted text -

> Hi All,
> Update: The problem is due to an 11g bug with table compression. We
> are in the process of producing a test case for OSS. The issue is
> extremely rare, in our case only effecting 6 rows out of 50 million,
> so producing a small test case is proving difficult. In the mean time
> we are not using compression.
> Cheers
> Ralph

When you get one please email it to me directly as I would like to try it against the 11gR2 beta. Thanks.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Tue Jun 10 2008 - 10:17:29 CDT

Original text of this message