Skip Menu |
 

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-Oracle CPAN distribution.

Report information
The Basics
Id: 91217
Status: resolved
Priority: 0/
Queue: DBD-Oracle

People
Owner: Nobody in particular
Requestors: Andy.Bucksch [...] ext.imperia-ag.de
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



From Andy.Bucksch [...] ext.imperia-ag.de Fri Dec 6 09: 37:15 2013
MIME-Version: 1.0
X-Spam-Status: No, score=-6.892 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5, UPPERCASE_50_75=0.008] autolearn=ham
X-Spam-Flag: NO
Content-Language: de-DE
content-type: text/plain; charset="utf-8"
Message-ID: <25455996AFF0F749B2496AE5840B27DE766B4B [...] piro-ex01.pironet-ndh.dom>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-MS-Tnef-Correlator:
X-Spam-Score: -6.892
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id C1B612409FC for <cpan-bug+dbd-oracle [...] hipster.bestpractical.com>; Fri, 6 Dec 2013 09:37:15 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id wsmPRsJ9ar-h for <cpan-bug+dbd-oracle [...] hipster.bestpractical.com>; Fri, 6 Dec 2013 09:37:13 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 963DD2409FB for <bug-dbd-oracle [...] rt.cpan.org>; Fri, 6 Dec 2013 09:37:13 -0500 (EST)
Received: (qmail 21058 invoked by alias); 6 Dec 2013 14:37:12 -0000
Received: from secure-mail02.pironet-ndh.com (HELO secure-mail02.pironet-ndh.com) (195.227.216.10) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Fri, 06 Dec 2013 06:37:10 -0800
Received: from piro-ex01.pironet-ndh.dom (piro-ex01.pironet-ndh.com [195.227.216.116]) by secure-mail02.pironet-ndh.com with ESMTP id rB6Eb41T031147-rB6Eb41V031147 (version=TLSv1.0 cipher=AES128-SHA bits=128 verify=CAFAIL) for <bug-DBD-Oracle [...] rt.cpan.org>; Fri, 6 Dec 2013 15:37:04 +0100
Received: from PIRO-EX01.pironet-ndh.dom ([195.227.216.116]) by piro-ex01.pironet-ndh.dom ([195.227.216.116]) with mapi id 14.02.0309.002; Fri, 6 Dec 2013 15:37:04 +0100
Delivered-To: cpan-bug+dbd-oracle [...] hipster.bestpractical.com
Subject: The RULE (and CHOOSE) OPTIMIZER_MODE has been deprecated and desupported in 11g
X-Feas-System-WL: 195.227.216.116
Return-Path: <Andy.Bucksch [...] ext.imperia-ag.de>
Thread-Index: Ac7ykA9LK1D5ZKhIQ+uNQEUIzQDhWA==
X-RT-Mail-Extension: dbd-oracle
X-Original-To: cpan-bug+dbd-oracle [...] hipster.bestpractical.com
X-Spam-Check-BY: la.mx.develooper.com
Date: Fri, 6 Dec 2013 14:37:03 +0000
X-Spam-Level:
X-MS-Has-Attach:
Thread-Topic: The RULE (and CHOOSE) OPTIMIZER_MODE has been deprecated and desupported in 11g
X-Originating-Ip: [195.227.222.196]
Accept-Language: de-DE, en-US
To: "bug-DBD-Oracle [...] rt.cpan.org" <bug-DBD-Oracle [...] rt.cpan.org>
Content-Transfer-Encoding: quoted-printable
From: Andy Bucksch <Andy.Bucksch [...] ext.imperia-ag.de>
X-RT-Original-Encoding: ascii
X-RT-Interface: Email
Content-Length: 941
Download (untitled) / with headers
text/plain 941b
Hi, as the title implies, since oracle 11g the RULE (and CHOOSE) OPTIMIZER_MODE has been deprecated and desupported. More infos about that: http://www.confio.com/logicalread/oracle-11g-optimizer-changes-affect-tuning-mc02/#.UqHZDcO5TtE Oracle::DBD in version 1.68 produces SQL statements like: SELECT * FROM ( SELECT /*+ CHOOSE */ NULL TABLE_CAT , t.OWNER TABLE_SCHEM , t.TABLE_NAME TABLE_NAME , decode(t.OWNER , 'SYS' , 'SYSTEM ' , 'SYSTEM' , 'SYSTEM ' , '' ) || t.TABLE_TYPE TABLE_TYPE , c.COMMENTS REMARKS FROM ALL_TAB_COMMENTS c , ALL_CATALOG t WHERE c.OWNER (+) = t.OWNER AND c.TABLE_NAME (+) = t.TABLE_NAME AND c.TABLE_TYPE (+) = t.TABLE_TYPE ) WHERE TABLE_SCHEM LIKE '%' ESCAPE '\' AND TABLE_NAME LIKE '%TEST_KD_NEWS' ESCAPE '\' ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME which shows that the CHOOSE hint is still applied by DBD::Oracle. I'm no Oracle expert just a perl developer, please keep that in mind. Greetings, Andy
From champoux [...] pythian.com Fri Dec 6 12: 59:21 2013
MIME-Version: 1.0
X-Spam-Status: No, score=-6.121 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5, SPF_NEUTRAL=0.779] autolearn=ham
In-Reply-To: <rt-4.0.18-19640-1386340636-377.91217-4-0 [...] rt.cpan.org>
X-Spam-Flag: NO
X-RT-Interface: API
References: <RT-Ticket-91217 [...] rt.cpan.org> <25455996AFF0F749B2496AE5840B27DE766B4B [...] piro-ex01.pironet-ndh.dom> <rt-4.0.18-19640-1386340636-377.91217-4-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Received: by 10.42.118.14 with SMTP id v14mr2529376icq.73.1386352750209; Fri, 06 Dec 2013 09:59:10 -0800 (PST)
X-Received: by 10.42.118.14 with SMTP id v14mr2529371icq.73.1386352750051; Fri, 06 Dec 2013 09:59:10 -0800 (PST)
Message-ID: <52A2106C.90102 [...] pythian.com>
content-type: text/plain; charset="utf-8"; format="flowed"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -6.121
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id C10022409AA for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Fri, 6 Dec 2013 12:59:21 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id MSIQ-8uOTY27 for <cpan-bug+DBD-Oracle [...] hipster.bestpractical.com>; Fri, 6 Dec 2013 12:59:20 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 2C004240045 for <bug-DBD-Oracle [...] rt.cpan.org>; Fri, 6 Dec 2013 12:59:19 -0500 (EST)
Received: (qmail 4980 invoked by alias); 6 Dec 2013 17:59:19 -0000
Received: from na3sys009aog129.obsmtp.com (HELO na3sys009aog129.obsmtp.com) (74.125.149.142) by la.mx.develooper.com (qpsmtpd/0.28) with SMTP; Fri, 06 Dec 2013 09:59:14 -0800
Received: from mail-ie0-f180.google.com ([209.85.223.180]) (using TLSv1) by na3sys009aob129.postini.com ([74.125.148.12]) with SMTP ID DSNKUqIQbtB+gPTmN53oyGa6OLAiqoFX3Sv8 [...] postini.com; Fri, 06 Dec 2013 09:59:14 PST
Received: by mail-ie0-f180.google.com with SMTP id tp5so1853435ieb.11 for <bug-DBD-Oracle [...] rt.cpan.org>; Fri, 06 Dec 2013 09:59:10 -0800 (PST)
Received: from [192.168.0.103] (198-84-238-196.cpe.teksavvy.com. [198.84.238.196]) by mx.google.com with ESMTPSA id f5sm4766417igc.4.2013.12.06.09.59.08 for <bug-DBD-Oracle [...] rt.cpan.org> (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Fri, 06 Dec 2013 09:59:09 -0800 (PST)
Delivered-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
User-Agent: Mozilla/5.0 (X11; Linux i686 on x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.1.1
Subject: Re: [rt.cpan.org #91217] The RULE (and CHOOSE) OPTIMIZER_MODE has been deprecated and desupported in 11g
Return-Path: <champoux [...] pythian.com>
X-Spam-Check-BY: la.mx.develooper.com
X-Original-To: cpan-bug+DBD-Oracle [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbd-oracle
X-Google-Dkim-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:message-id:date:from:user-agent:mime-version:to :subject:references:in-reply-to:content-type; bh=UOAMQo22Ci4HqC1kEeBL1PDYa1ZAHil9kb2oBIB5v9U=; b=ijxlKqXbcNfldT0MpCKS6RP9vSBEVfoTzJnpZM6UD5sQtPN2G81rORLGqdfgGIWSWA wcCE+NHSvO/ES9aGeZ0NaetCBLix1ae+QaykL5Zlf3Fxx4ebY5REQ3CXmvgwvTilVcdC NaQy+H4yu2Z+fioa1HH4p2OyIOdo6fBrmrTIQYNpuKBtxY41CVUrfKdthTIOAE/KM9fo 5hRo6Vj9LUlLMAtjX86zClkKyTF7MrXuBNBCrr0c1qBPLpyL42bQFH1Z/t8yp/J2LSDD aUFuon7B5AL0QAB73h+5OJFUPdFR8fuUgOeVWgUZN62luLMEUrutFLmpRxr5mw8ol4wj 6zzw==
Date: Fri, 06 Dec 2013 12:59:08 -0500
X-Spam-Level:
To: bug-DBD-Oracle [...] rt.cpan.org
X-GM-Message-State: ALoCoQloojVBhBKmbEfykMPb4hvrzHspq9jS7uf1BypbDzujEq1RPwXB79/qcjS5XkKxGxWvwqOjNeB77XvxUXA2mVgNsC+/XGlFjCoa+SLMQD2K8PBrPiGl4pgHYPCxI0l8SzHAsV04inFTNAndv6dDBZAn9ZSdFCn9r8HCP4jHrOlxNo4HLn8=
From: Yanick Champoux <champoux [...] pythian.com>
RT-Message-ID: <rt-4.0.18-26226-1386352762-1839.91217-0-0 [...] rt.cpan.org>
Content-Length: 216
Download (untitled) / with headers
text/plain 216b
On 13-12-06 09:37 AM, Andy Bucksch via RT wrote: Show quoted text
> I'm no Oracle expert just a perl developer, please keep that in mind.
Heh. Same thing here. :-) Thanks for the info, I'll see what I can do! `/anick -- --
MIME-Version: 1.0
In-Reply-To: <rt-4.0.18-26226-1386352762-1839.91217-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <RT-Ticket-91217 [...] rt.cpan.org> <25455996AFF0F749B2496AE5840B27DE766B4B [...] piro-ex01.pironet-ndh.dom> <rt-4.0.18-19640-1386340636-377.91217-4-0 [...] rt.cpan.org> <52A2106C.90102 [...] pythian.com> <rt-4.0.18-26226-1386352762-1839.91217-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-31025-1392903012-945.91217-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 392
Download (untitled) / with headers
text/plain 392b
On Fri Dec 06 12:59:22 2013, PYTHIAN wrote: Show quoted text
> On 13-12-06 09:37 AM, Andy Bucksch via RT wrote:
> > I'm no Oracle expert just a perl developer, please keep that in mind.
> > Heh. Same thing here. :-) Thanks for the info, I'll see what I can do! > > `/anick >
See pull request https://github.com/pythian/DBD-Oracle/pull/12 I think this fixes this. Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
X-Spam-Flag: NO
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
content-type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -4.2
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 7995724046A for <cpan-bug+dbd-oracle [...] hipster.bestpractical.com>; Thu, 27 Feb 2014 04:14:31 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id lOMJnIbihtDq for <cpan-bug+dbd-oracle [...] hipster.bestpractical.com>; Thu, 27 Feb 2014 04:14:29 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 6BD4B240358 for <bug-dbd-oracle [...] rt.cpan.org>; Thu, 27 Feb 2014 04:14:28 -0500 (EST)
Received: (qmail 32292 invoked by alias); 27 Feb 2014 09:14:27 -0000
Received: from secure-mail02.pironet-ndh.com (HELO secure-mail02.pironet-ndh.com) (195.227.216.10) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Thu, 27 Feb 2014 01:14:23 -0800
Received: from piro-ex01.pironet-ndh.dom (piro-ex01.pironet-ndh.com [195.227.216.116]) by secure-mail02.pironet-ndh.com with ESMTP id s1R9EGXq009218-s1R9EGXs009218 (version=TLSv1.0 cipher=AES128-SHA bits=128 verify=CAFAIL) for <bug-DBD-Oracle [...] rt.cpan.org>; Thu, 27 Feb 2014 10:14:16 +0100
Received: from PIRO-EX01.pironet-ndh.dom ([195.227.216.116]) by piro-ex01.pironet-ndh.dom ([195.227.216.116]) with mapi id 14.02.0309.002; Thu, 27 Feb 2014 10:14:16 +0100
Delivered-To: cpan-bug+dbd-oracle [...] hipster.bestpractical.com
Subject: AW: [rt.cpan.org #91217] The RULE (and CHOOSE) OPTIMIZER_MODE has been deprecated and desupported in 11g
X-Feas-System-WL: 195.227.216.116
X-Spam-Check-BY: la.mx.develooper.com
Thread-Index: Ac7ykA9LK1D5ZKhIQ+uNQEUIzQDhWA7r9XypAVcNIV8=
Date: Thu, 27 Feb 2014 09:14:15 +0000
X-Spam-Level:
To: "bug-DBD-Oracle [...] rt.cpan.org" <bug-DBD-Oracle [...] rt.cpan.org>
Content-Transfer-Encoding: quoted-printable
From Andy.Bucksch [...] ext.imperia-ag.de Thu Feb 27 04: 14:31 2014
In-Reply-To: <rt-4.0.18-31025-1392903012-1037.91217-6-0 [...] rt.cpan.org>
X-Spam-Status: No, score=-4.2 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3] autolearn=ham
X-RT-Interface: API
Content-Language: de-DE
References: <RT-Ticket-91217 [...] rt.cpan.org> <25455996AFF0F749B2496AE5840B27DE766B4B [...] piro-ex01.pironet-ndh.dom> <rt-4.0.18-19640-1386340636-377.91217-4-0 [...] rt.cpan.org> <52A2106C.90102 [...] pythian.com> <rt-4.0.18-26226-1386352762-1839.91217-6-0 [...] rt.cpan.org>,<rt-4.0.18-31025-1392903012-1037.91217-6-0 [...] rt.cpan.org>
Message-ID: <25455996AFF0F749B2496AE5840B27DE6C5C20F6 [...] piro-ex01.pironet-ndh.dom>
X-MS-Tnef-Correlator:
Return-Path: <Andy.Bucksch [...] ext.imperia-ag.de>
X-RT-Mail-Extension: dbd-oracle
X-Original-To: cpan-bug+dbd-oracle [...] hipster.bestpractical.com
X-MS-Has-Attach:
Thread-Topic: [rt.cpan.org #91217] The RULE (and CHOOSE) OPTIMIZER_MODE has been deprecated and desupported in 11g
X-Originating-Ip: [195.227.222.196]
Accept-Language: de-DE, en-US
From: Andy Bucksch <Andy.Bucksch [...] ext.imperia-ag.de>
RT-Message-ID: <rt-4.0.18-32556-1393492472-1502.91217-0-0 [...] rt.cpan.org>
Content-Length: 1490
Download (untitled) / with headers
text/plain 1.4k
Hi Martin, thanks for the info, i will check it out. Greetings, Andy Bucksch Technischer Consultant Imperia AG Von-der-Wettern-Straße 27 51149 Köln Tel: +49 2203 93530 2271 Fax: +49 2203 93530 2101 andy.bucksch@ext.imperia-ag.de – http://www.imperia-ag.de Aktiengesellschaft mit Sitz in Köln Vorsitzender des Aufsichtsrats: Felix Höger Vorstand: Daniel Redanz HRB 45063, Amtsgericht Köln ---- Kennen Sie schon unseren Blog? http://www.cms-board.de ---- Notice: This e-mail is confidential and may contain copyright material of Imperia AG. If you are not the intended recipient, please notify us and delete all copies of this message. Imperia AG accepts no responsibility for damage due to incorrect use of attached materials, corrupted files or viruses. Show quoted text
________________________________________ Von: Martin J Evans via RT [bug-DBD-Oracle@rt.cpan.org] Gesendet: Donnerstag, 20. Februar 2014 14:30 An: Andy Bucksch Betreff: [rt.cpan.org #91217] The RULE (and CHOOSE) OPTIMIZER_MODE has been deprecated and desupported in 11g <URL: https://rt.cpan.org/Ticket/Display.html?id=91217 > On Fri Dec 06 12:59:22 2013, PYTHIAN wrote:
> On 13-12-06 09:37 AM, Andy Bucksch via RT wrote:
> > I'm no Oracle expert just a perl developer, please keep that in mind.
> > Heh. Same thing here. :-) Thanks for the info, I'll see what I can do! > > `/anick >
See pull request https://github.com/pythian/DBD-Oracle/pull/12 I think this fixes this. Martin -- Martin J. Evans Wetherby, UK


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.