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 <[EMAIL PROTECTED]>
Date: 3/28/2002 12:23 PM
[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
