DBD::Oracle 1.15 fails for tests 195, 196, 197 and 198
Note that DBD::Oracle 1.14 is OK (somehwat fewer tests, so perhaps the bug
isn't triggered -- I have not yet delved into the differrences between the
test sets).
The failure is peculiar. Oracle complains about the date format being wrong,
but as I understand it the date has been OK in previous and subsequent
queries.
Oracle version 8.1.7.0.0 for both server and client.
Sincerely,
Gerard Tromp
Perl data;
==========
Summary of my perl5 (revision 5.0 version 8 subversion 3) configuration:
Platform:
osname=solaris, osvers=2.8, archname=sun4-solaris
uname='sunos penrose 5.8 generic_108528-15 sun4u sparc sunw,ultra-60 '
config_args='-Dcc=gcc -B/usr/ccs/bin/'
hint=previous, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='gcc -B/usr/ccs/bin/', ccflags
='-fno-strict-aliasing -I/opt/local/include -I/opt/BerkeleyDB/include',
optimize='-O2',
cppflags='-fno-strict-aliasing -I/opt/local/include -I/opt/BerkeleyDB/includ
e -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fno-strict-aliasing -I/opt/loc
al/include -I/opt/BerkeleyDB/include -fno-strict-aliasing -I/opt/local/inclu
de -I/opt/BerkeleyDB/include'
ccversion='', gccversion='3.3.2', gccosandvers='solaris2.8'
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=4
alignbytes=8, prototype=define
Linker and Libraries:
ld='gcc -B/usr/ccs/bin/', ldflags
='-L/opt/local/lib -L/opt/BerkeleyDB/lib -L/opt/SUNWspro/lib -R/opt/local/li
b -R/opt/BerkeleyDB/lib -R/opt/SUNWspro/lib '
libpth=/opt/local/lib /usr/lib /usr/ccs/lib /opt/BerkeleyDB/lib
/opt/SUNWspro/lib
libs=-lsocket -lnsl -ldb -ldl -lm -lc
perllibs=-lsocket -lnsl -ldl -lm -lc
libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' -R
/opt/perl/perl5/5.8.3/sun4-solaris/CORE'
cccdlflags='-fPIC',
lddlflags='-G -L/opt/local/lib -L/opt/BerkeleyDB/lib -L/opt/SUNWspro/lib -R/
opt/local/lib -R/opt/BerkeleyDB/lib -R/opt/SUNWspro/lib'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under solaris
Compiled at Jan 28 2004 12:03:01
@INC:
/opt/perl/perl5/5.8.3/sun4-solaris
/opt/perl/perl5
/opt/perl/perl5/site_perl/5.8.3/sun4-solaris
/opt/perl/perl5/site_perl/5.8.3
/opt/perl/perl5/site_perl/5.8.0/sun4-solaris ## moved these to another
location to verify that
/opt/perl/perl5/site_perl/5.8.0 ## there is no "crosstalk"
/opt/perl/perl5/site_perl
test output (truncated to relevant tests -- with trace() around the dbh that
fails)
============================================================================
=======
ok 193
DBI::st=HASH(0x1d972c) trace level set to 5 in DBI 1.40-nothread (pid
9737)
-> fetchall_arrayref for DBD::Oracle::st
(DBI::st=HASH(0x26a4f8)~0x1d972c)
dbd_st_fetch 3 fields...
OCIErrorGet after OCIStmtFetch (er1:ok): -1, 1801: ORA-01801: date
format is too long for internal buffer
!! ERROR: 1801 'ORA-01801: date format is too long for internal buffer
(DBD ERROR: OCIStmtFetch)'
<- fetchall_arrayref= [ ] at t/gt_long.t line 156 via t/gt_long.t line
78
1 -> FETCH for DBD::Oracle::st (DBI::st=HASH(0x1d972c)~INNER
'ParamValues')
error: 1801 'ORA-01801: date format is too long for internal buffer
(DBD ERROR: OCIStmtFetch)'
1 <- FETCH= HASH(0x26a318)0keys at t/gt_long.t line 156 via t/gt_long.t
line 78
DBD::Oracle::st fetchall_arrayref failed: ORA-01801: date format is too long
for internal buffer (DBD ERROR: OCIStmtFetch) [for Statement "select * from
dbd_ora__drop_me order by idx"] at t/gt_long.t line 156.
ok 194
# failed test 195 at line 157.
not ok 195
Use of uninitialized value in string eq at t/gt_long.t line 158.
Use of uninitialized value in length at t/gt_long.t line 158.
Use of uninitialized value in length at t/gt_long.t line 438.
Use of uninitialized value in string eq at t/gt_long.t line 439.
# failed test 196 at line 158. Strings are of different lengths (0 vs 20),
Len 0
not ok 196
Use of uninitialized value in string eq at t/gt_long.t line 160.
Use of uninitialized value in length at t/gt_long.t line 160.
Use of uninitialized value in length at t/gt_long.t line 438.
Use of uninitialized value in string eq at t/gt_long.t line 439.
# failed test 197 at line 160. Strings are of different lengths (0 vs 20),
Len 0
not ok 197
Use of uninitialized value in string eq at t/gt_long.t line 162.
Use of uninitialized value in length at t/gt_long.t line 162.
Use of uninitialized value in length at t/gt_long.t line 438.
Use of uninitialized value in string eq at t/gt_long.t line 439.
# failed test 198 at line 162. Strings are of different lengths (0 vs 20),
Len 0
not ok 198
ok 199
