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: 59461
Status: rejected
Priority: 0/
Queue: DBD-Oracle
People
Owner: Nobody in particular
Requestors: RUZ [...] cpan.org
Cc:
AdminCc:
Bug Information
Severity: Normal
Broken in: 1.24b
Fixed in: (no value)

History Show all quoted text
  Fri Jul 16 17:37:57 2010 RUZ [...] cpan.org - Ticket created
Subject: column_info is case sensetive
Hello, It took me a while to figure out that column_info actually works, but is case sensetive and Oracle thinks that upper case is cool. Could you please either document this or make search query case insensetive. -- Best regards, Ruslan.
  Sat Jul 17 15:38:33 2010 champoux [...] pythian.com - Correspondence added
Column_info simply runs an sql to get the info. Normal an oracle DB does not care about the 'case' of a table or row name however oracle does allow you to do this create table "BlaB" ("Bla_BLA" COL1 NUMBER) and that will hardcode your table and field name so only this SQL will work Select Bla_Bla from BlaB while if you created your table like this create table BlaB (Bla_BLA COL1 NUMBER) then Select Bla_Bla from BlaB Select BLA_BLA FROM BLAB select bla_bla from blab will all work most likely you are running into this. Basically there is no way around this to get the table info even in say SQlPlus you would have to use the name of the field that created in this manner.
  Sat Jul 17 15:38:34 2010 The RT System itself - Status changed from 'new' to 'open'
  Sat Jul 17 15:38:34 2010 champoux [...] pythian.com - Status changed from 'open' to 'rejected'