Re[2]: Odd Sql result

Stephane,

    Yeah, it's weird at best. Asked OTS about it, along with sending them the view defs and they replied that I should try on a supported version of Oracle. I forgot to mention in the previous post that this is on 8.0.5.2.1. Anyway, I tried on 8.1.7 & bingo it did not re-occur. The end result is that Oracle believes it to be a bug in 8.0. Well good for them, I really did need one more reason to upgrade this PIG and now I've got another.

Dick Goulet

____________________Reply Separator____________________
Author: Stephane Faroult <sfaroult_at_oriole.com>
Date:       3/28/2002 12:23 PM

dgoulet_at_vicr.com wrote:
>
> Hey folks,
>
> Now I've seen some odd results form queries in the past, but I'll be
d*mned
> is I can figure this one out. It defies logic.
>
> I've two queries that each return 50 rows from the database & the rows are
> the same is each case (stubby pencil check), but of the three columns returned
> the last two reverse. I'm including the SQL, a sample result set, and the
view
> definitions that are being used. If you can figure it out, please let me
know.
> I'm asking OTS as well.
>
> Dick Goulet
>

Waow, that's really weird. You say that what you are querying are VIEWS. Could you post the view text as well? I suspect that's where weirdness comes from. If they happen to be UNIONs with swapped columns in one segment, the fact that the RTRIM() changes the execution plan (probably) might hit other sections of the data.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).