From oracle-l-bounce@freelists.org Wed May 5 10:53:15 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i45Fr0i04985 for ; Wed, 5 May 2004 10:53:10 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i45Fqn604944 for ; Wed, 5 May 2004 10:52:59 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2103C72D40D; Wed, 5 May 2004 10:43:15 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18051-52; Wed, 5 May 2004 10:43:14 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6953372D470; Wed, 5 May 2004 10:43:14 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 05 May 2004 10:42:00 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 95E0872CB78 for ; Wed, 5 May 2004 10:41:58 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18007-20 for ; Wed, 5 May 2004 10:41:58 -0500 (EST) Received: from EBMS20.bov.de (unknown [213.23.125.8]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C335C72CC69 for ; Wed, 5 May 2004 10:41:57 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: AW: Wrong results using decode when db upgraded to 9205 Date: Wed, 5 May 2004 17:55:46 +0200 Message-ID: <87F172BCF111D0489340AB3CB16A011E5CE6BD@EBMS20.bov.int> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Wrong results using decode when db upgraded to 9205 Thread-Index: AcQytT9LURe62l4bRSuhiwuWtEgFngAAG0mAAABPzvAAAIi5gA== From: "Stefan Jahnke" To: X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4448 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Stefan.Jahnke@bov.de Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi again Sorry, haven't looked into it. Since we already changed everything to = CASE on 9.2.0.4.0. The reason wasn't a bug but to be coherent with the = usage of DECODE / CASE. We agreed upon ANSI style stuff (INNER JOIN, = CASE blahblah) since 2 developers have a SQL Server background and seem = to comprehend that faster (no pun intended, they're great). Stefan -----Urspr=FCngliche Nachricht----- Von: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]Im Auftrag von Jamadagni, Rajendra Gesendet: Wednesday, May 05, 2004 5:39 PM An: oracle-l@freelists.org Betreff: RE: Wrong results using decode when db upgraded to 9205 Thanks, I can't imagine rewriting all decodes to case statements ... That alone would take more than 6-9 months in our code base.=3D20 Are there any bug# that you know? Raj ------------------------------------------------------------------------ --------=3D20 Rajendra dot Jamadagni at nospamespn dot com=3D20 All Views expressed in this email are strictly personal.=3D20 select standard_disclaimer from company_requirements;=3D20 QOTD: Any clod can have facts, having an opinion is an art ! -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Stefan Jahnke Sent: Wednesday, May 05, 2004 11:31 AM To: oracle-l@freelists.org Subject: AW: Wrong results using decode when db upgraded to 9205 Hi Rajendra I don't know wether this helps or not: We upgraded a dev db from =3D3D 9.2.0.4.0 to 9.2.0.5.0 and as you said, CASE works fine. We have =3D3D rewritten all our DECODE statements to CASE and all of them still work. =3D3D So at with CASE there doesn't seem to be a problem. Stefan -----Urspr=3D3DFCngliche Nachricht----- Von: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]Im Auftrag von Jamadagni, Rajendra Gesendet: Wednesday, May 05, 2004 5:26 PM An: oracle-l@freelists.org Betreff: Wrong results using decode when db upgraded to 9205 I upgraded a dev db from 9202 to 9205 and one query with a DECODE statement is giving wrong results. The whole query is big, but decode statement looks like ...=3D3D20 "and decode('C8','C8',237,0) =3D3D3D = 237" =3D If the same statement is =3D3D re-written using case it works fine. I am searching on metablink but wanted to check here first. This same query with same decode statement works fine on 9202 database.=3D3D20 Any =3D hearsay? Known issues? Experiences? Thanks Raj ------------------------------------------------------------------------ --------=3D3D20 Rajendra dot Jamadagni at nospamespn dot com=3D3D20 All Views expressed = in this email are strictly personal.=3D3D20 select standard_disclaimer from company_requirements;=3D3D20 QOTD: Any clod can have facts, having an opinion is an art ! ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------