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)

History Show all quoted text
  Fri Dec 06 09:37:16 2013 Andy.Bucksch [...] ext.imperia-ag.de - Ticket created
Subject: The RULE (and CHOOSE) OPTIMIZER_MODE has been deprecated and desupported in 11g
Date: Fri, 6 Dec 2013 14:37:03 +0000
To: "bug-DBD-Oracle [...] rt.cpan.org" <bug-DBD-Oracle [...] rt.cpan.org>
From: Andy Bucksch <Andy.Bucksch [...] ext.imperia-ag.de>
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
  Fri Dec 06 12:59:22 2013 champoux [...] pythian.com - Correspondence added
Subject: Re: [rt.cpan.org #91217] The RULE (and CHOOSE) OPTIMIZER_MODE has been deprecated and desupported in 11g
Date: Fri, 06 Dec 2013 12:59:08 -0500
To: bug-DBD-Oracle [...] rt.cpan.org
From: Yanick Champoux <champoux [...] pythian.com>
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 -- --
  Fri Dec 06 12:59:22 2013 The RT System itself - Status changed from 'new' to 'open'
  Thu Feb 20 08:30:12 2014 bohica [...] ntlworld.com - Correspondence added
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
  Thu Feb 27 04:14:32 2014 Andy.Bucksch [...] ext.imperia-ag.de - Correspondence added
Subject: AW: [rt.cpan.org #91217] The RULE (and CHOOSE) OPTIMIZER_MODE has been deprecated and desupported in 11g
Date: Thu, 27 Feb 2014 09:14:15 +0000
To: "bug-DBD-Oracle [...] rt.cpan.org" <bug-DBD-Oracle [...] rt.cpan.org>
From: Andy Bucksch <Andy.Bucksch [...] ext.imperia-ag.de>
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
  Fri Mar 07 15:27:08 2014 champoux [...] pythian.com - Status changed from 'open' to 'patched'
  Mon May 26 14:28:05 2014 champoux [...] pythian.com - Status changed from 'patched' to 'resolved'