DBD::Oracle sometimes return wrong PRECISION

"H.Merijn Brand" <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.sybase.devel
Message-ID <[email protected]>
I have something weird in DBD::Oracle (1.44 and 1.74)
Client = 10.2.0.1.0 / AIX-5.3 - Server = 11.2.0.3.0 - 64bit / Linux

consider a field that looks like this:

{   LINK             => undef,
    NAME             => 'D_GELD',
    NAME_lc          => 'd_geld',
    NAME_uc          => 'D_GELD',
    NULLABLE         => '',
    PRECISION        => 8,
    SCALE            => 0,
    TYPE             => 3,
    TYPE_NAME        => 'DECIMAL',
    dbd_type         => undef,
    ora_est_row_width => undef,
    ora_fail_over    => undef,
    ora_lengths      => 172,
    ora_rowid        => undef,
    ora_type         => undef,
    ora_types        => 2
    }

*sometimes* I get 126 in the PRECISION entry instead of 8
does that ring any bells?

I get 126 only if I use a where clause that addresses a field that is
first in an index on that table otherwise I get 8

-- 
H.Merijn Brand  http://tux.nl   Perl Monger  http://amsterdam.pm.org/
using perl5.00307 .. 5.21   porting perl5 on HP-UX, AIX, and openSUSE
http://mirrors.develooper.com/hpux/        http://www.test-smoke.org/
http://qa.perl.org   http://www.goldmark.org/jeff/stupid-disclaimers/
signature.asc (application/pgp-signature, 490 B)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.22 (GNU/Linux)

iQEcBAEBAgAGBQJUpB0uAAoJEAOhR6E+XcCYn3oIALVmzyJKgMim71+Q9gO62EjA
SiXL/XfqUtQjAEEgvBhgdfIMbtZMLQNJnDCez0MmL87OUX7BocucI5JW7LX4jv/T
F52xVoBC7zVUIrDhSp0WVrTDxTFtc+o2O/5UtjKhuGm7D+wcwRj+LUlkHWH21Okx
vLfkJnYkyg1ScPwOUWGb4Tm8QZ67DXf2NjbssF5qsLOPCuLREU4GH6jG0IWiEN0U
F9bAcgKn5GO1ABF3fk4P8uL4RDGJM4V83zgqyFkB30D097MOBLVc0CV730VwhXuv
LInwPKkV/LTTo2bz2rpciqJTpdmLTJxbnIyi3U+GomNN5gh5ZMTxbz6zUcZFGzE=
=LOFH
-----END PGP SIGNATURE-----
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.