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: 30133
Status: open
Priority: 0/
Queue: DBD-Oracle

People
Owner: champoux [...] pythian.com
Requestors: kirby90 [...] yahoo.com
Cc: still [...] pythian.com
AdminCc:

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



Subject: DBD::Oracle reports wrong data type for encrypted numeric columns
Date: Fri, 19 Oct 2007 15:11:09 -0700 (PDT)
To: bug-DBD-Oracle [...] rt.cpan.org
From: "Dean H." <kirby90 [...] yahoo.com>
Download (untitled) / with headers
text/plain 1.6k
Dear module maintainer, I am writing to report a bug in the DBD::Oracle module. I am using module version 1.19 with Perl 5.8.5 on a 64-bit Intel server with RedHat Linux. Numeric table columns defined with ENCRYPT are reported as DOUBLE PRECISION, regardless of column data type. Consider table GOOBER with the following DDL: Show quoted text
SQL> desc goober
Name Type -------------------- --------------------- COL_INTEGER NUMBER(38) COL_INTEGER_ENCRYPT NUMBER(38) ENCRYPT COL_DECIMAL NUMBER(9,2) COL_DECIMAL_ENCRYPT NUMBER(9,2) ENCRYPT COL_FLOAT FLOAT(126) I requested the column info via DBI with the following code: my $sth = $dbh->prepare( 'select * from goober' ); my $columnCount = $sth->{NUM_OF_FIELDS}; my @columnNames; for(my $i=0; $i < $columnCount; $i++) { my $colName = @{$sth->{NAME}}[$i]; my $typeNum = @{$sth->{TYPE}}[$i]; my $typeName = $dbh->type_info($typeNum)->{TYPE_NAME}; my $precision = @{$sth->{PRECISION}}[$i]; my $scale = @{$sth->{SCALE}}[$i]; my @attrs = ($colName,$typeNum,$typeName,$precision,$scale); print join(",", @attrs), "\n"; } Here is the output: COL_INTEGER,3,DECIMAL,38,0 COL_INTEGER_ENCRYPT,8,DOUBLE PRECISION,126,0 COL_DECIMAL,3,DECIMAL,9,2 COL_DECIMAL_ENCRYPT,8,DOUBLE PRECISION,126,0 COL_FLOAT,8,DOUBLE PRECISION,126,0 Notice that the COL_INTEGER_ENCRYPT and COL_DECIMAL_ENCRYPT type and type name are the same as for the COL_FLOAT column. Please review at your earliest convenience. Regards, Dean Show quoted text
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Download (untitled) / with headers
text/plain 134b
Created rt30133 branch in Github repo. First step is to create a test to reproduce the problem. Need to create a wallet for that one.
Jared took the bug under his wing.
Download (untitled) / with headers
text/plain 231b
On Thu Sep 01 13:20:20 2011, PYTHIAN wrote: Show quoted text
> Jared took the bug under his wing.
Unfortunately, Jared alas doesn't have the tuits to tackle DBD::Oracle problems. Which means that this issue is back in the general pool. Schade. :-(
CC: kirby90 [...] yahoo.com
Subject: Re: [rt.cpan.org #30133] DBD::Oracle reports wrong data type for encrypted numeric columns
Date: Mon, 25 Jun 2012 09:15:18 -0700
To: bug-DBD-Oracle [...] rt.cpan.org
From: Jared Still <still [...] pythian.com>
Download (untitled) / with headers
text/plain 646b
On Mon, Jun 25, 2012 at 8:54 AM, Pythian Remote DBA via RT < bug-DBD-Oracle@rt.cpan.org> wrote: Show quoted text
> <URL: https://rt.cpan.org/Ticket/Display.html?id=30133 > > > On Thu Sep 01 13:20:20 2011, PYTHIAN wrote:
> > Jared took the bug under his wing.
> > Unfortunately, Jared alas doesn't have the tuits to tackle DBD::Oracle > problems. Which means that this issue is back in the general pool. > Schade. :-( >
Seriously wish I could. But yeah, the tuits are lacking. -- Jared Still Sr. DBA The Pythian Group -- -- Try Pythian managed services risk-free for operational support, upgrades/migrations, special projects or increased performance.


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.