Oracle 9.2.0.4 CBO bug

From: Rob Kinyon (Rob.Kinyon_at_progressive-medical.com)
Date: 03/19/04

  • Next message: Nathan Vonnahme: "RE: ODBC + MSAccess + Perl + Linux or FreeBSD question." 
    Date: Fri, 19 Mar 2004 12:48:55 -0500
To: <dbi-users@perl.org>

    Tim -

     

                FYI - I have found a reproducible CBO bug in Oracle 9i,
    latest patchset. I was wondering if you could look at it and tell me if
    you have any insight into it. I've attached a tar.gz containing five
    files - four setup scripts and a shell script that runs them in the
    correct order. It requires a connection to a database with scott/tiger
    set up.

     

                The bug is related to using the same where condition twice.
    (SELECT * FROM foo WHERE a = b AND a = b) I found it when doing some SQL
    generation.

     

                I'm not looking for you to do anything with it re:
    DBD::Oracle - this is just a FYI.

     

    Thanks,

    Rob

  • Next message: Nathan Vonnahme: "RE: ODBC + MSAccess + Perl + Linux or FreeBSD question."