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-----