Re: make test failed with DBD::Oracle 1.27

  On 05/01/2011 4:31 AM, ZHANG Jiaqiang A wrote:

Yep those are two known bugs with 64bit system.

Still working on getting rid of them.  It is hard to reproduce  but one 
of the ones we will be fixing soon

The good news is unless you are using embedded objects like VARRY, 
OBJECT or TABLE you can ignore the 58object tests

On 31lob front the test that fails is a rater obscure OCI check dealing 
with the length of a returned lob.  I doubt it will give you a problem

cheers
John
> Hello All,
>
> I need your help, now I am trying to use DBD::Oracle on Oracle 11g on Solaris 10.
>
> I am blocked with two test files: t/31lob.t and t/58object.t:
>
> 	1)There are some garbled characters when I executed the 31lob.t alone.
> 	2)When I executed the 58object.t alone, it quits without any error msg.
> 	
> 	
> 	~/DBD-Oracle-1.27$make test
> 	PERL_DL_NONLAZY=1 /home/tester/perl/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
> 	t/01base.t .............. # Test loading DBI, DBD::Oracle and version
> 	t/01base.t .............. ok
> 	t/10general.t ........... ok
> 	t/12impdata.t ........... ok
> 	t/14threads.t ........... ok
> 	t/15nls.t ............... ok
> 	t/20select.t ............ ok
> 	t/21nchar.t ............. ok
> 	t/22nchar_al32utf8.t .... ok
> 	t/22nchar_utf8.t ........ ok
> 	t/23wide_db.t ........... ok
> 	t/23wide_db_8bit.t ...... ok
> 	t/23wide_db_al32utf8.t .. ok
> 	t/24implicit_utf8.t ..... ok
> 	t/25plsql.t ............. ok
> 	t/26exe_array.t ......... ok
> 	t/28array_bind.t ........ ok
> 	t/30long.t .............. ok
> 	t/31lob.t ............... Dubious, test returned 1 (wstat 256, 0x100)
> 	Failed 4/12 subtests
> 	t/31lob_extended.t ...... ok
> 	t/32xmltype.t ........... ok
> 	t/34pres_lobs.t ......... ok
> 	t/40ph_type.t ........... 1/19  Placeholder behaviour for ora_type=1 VARCHAR2 (the default) varies with Oracle version.
> 	 Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
> 	 Your system doesn't. If that seems odd, let us know.
> 	t/40ph_type.t ........... ok
> 	t/50cursor.t ............ ok
> 	t/51scroll.t ............ ok
> 	t/55nested.t ............ ok
> 	t/56embbeded.t .......... ok
> 	t/58object.t ............ Dubious, test returned 1 (wstat 256, 0x100)
> 	Failed 28/51 subtests
> 	t/60reauth.t ............ skipped: ORACLE_USERID_2 not defined.
> 	t/70meta.t .............. ok
> 	t/80ora_charset.t ....... ok
>
> 	
> 	Test Summary Report
> 	-------------------
> 	t/31lob.t             (Wstat: 256 Tests: 8 Failed: 0)
> 	  Non-zero exit status: 1
> 	  Parse errors: Bad plan.  You planned 12 tests but ran 8.
> 	t/58object.t          (Wstat: 256 Tests: 23 Failed: 0)
> 	  Non-zero exit status: 1
> 	  Parse errors: Bad plan.  You planned 51 tests but ran 23.
> 	Files=30, Tests=2254, 85 wallclock secs ( 2.34 usr  0.72 sys + 44.29 cusr  4.22 csys = 51.57 CPU)
> 	Result: FAIL
> 	Failed 2/30 test programs. 0/2254 subtests failed.
> 	*** Error code 255
> 	make: Fatal error: Command failed for target `test_dynamic'
> 	
>
> 	~/DBD-Oracle-1.27$perl -Mlib=./lib,./blib/lib,./blib/arch t/31lob.t
> 	1..12
> 	ok 1 - returned valid locator
> 	ok 2 - inserted into BLOB successfully
> 	ok 3 - got back what we put in
> 	ok 4 - returned valid locator
> 	ok 5 - returned valid locator
> 	ok 6 - returned initialized locator
> 	ok 7 - returned length
> 	ok 8 - returned written value
> 	Errors in file :
> 	OCI-21500: internal error code, arguments: [kpullas-1], [], [], [], [], [], [], []
> 	ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`Errors in file :
> 	OCI-21500: internal error code, arguments: [kpullas-1], [], [], [], [], [], [], []
> 	ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`~/DBD-Oracle-1.27$
> 	
> 	~/DBD-Oracle-1.27$perl -Mlib=./lib,./blib/lib,./blib/arch t/58object.t
> 	1..51
> 	ok 1 - use DBI;
> 	ok 2 - ora_objects flag is set to 1
> 	ok 3 - ora_objects flag is set to 0
> 	ok 4 - The object isa DBI::db
> 	ok 5 - Fetch current schema name
> 	ok 6 - old: Prepare select
> 	ok 7 - old: Execute select
> 	ok 8 - old: Fetch first row
> 	ok 9 - old: Row 1 column 2 is an ARRAY
> 	ok 10 - old: Row 1 column 2 is has 2 elements
> 	ok 11 - old: Fetch second row
> 	ok 12 - old: Row 2 column 2 is an ARRAY
> 	ok 13 - old: Row 2 column 2 is has 2 elements
> 	ok 14 - old: Fetch third row
> 	ok 15 - old: Row 3 column 2 is an ARRAY
> 	ok 16 - old: Row 3 column 2 is has 2 elements
> 	ok 17 - old: No more rows expected
> 	ok 18 - new: Prepare select
> 	ok 19 - new: Execute select
> 	ok 20 - new: Fetch first row
> 	ok 21 - new: Row 1 column 2 is an DBD:Oracle::Object
> 	ok 22 - new: Row 1 column 2 object type
> 	ok 23 - new: Row 1 column 2 object attributes
> 	~/DBD-Oracle-1.27$
> 	
> 	
> 	
> 	perl -V
> 	Summary of my perl5 (revision 5 version 12 subversion 2) configuration:
> 	
> 	  Platform:
> 	    osname=solaris, osvers=2.10, archname=sun4-solaris-thread-multi-64
> 	    uname='sunos lteoam181 5.10 generic_141444-09 sun4v sparc sunw,sparc-enterprise-t5220 '
> 	    config_args='-des -Dprefix=/home/tester/perl -Duse64bitall -Dusethreads -Duseithreads'
> 	    hint=recommended, useposix=true, d_sigaction=define
> 	    useithreads=define, usemultiplicity=define
> 	    useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
> 	    use64bitint=define, use64bitall=define, uselongdouble=undef
> 	    usemymalloc=n, bincompat5005=undef
> 	  Compiler:
> 	    cc='cc', ccflags ='-D_REENTRANT -xarch=generic64 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPERL_USE_SAFE_PUTENV',
> 	    optimize='-O',
> 	    cppflags='-D_REENTRANT -xarch=generic64'
> 	    ccversion='Sun C 5.11 SunOS_sparc 2010/08/13', gccversion='', gccosandvers=''
> 	    intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=87654321
> 	    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
> 	    ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
> 	    alignbytes=8, prototype=define
> 	  Linker and Libraries:
> 	    ld='cc', ldflags =' -xarch=generic64 -L/opt/solstudio12.2/prod/lib/sparc/64 -L/opt/solstudio12.2/prod/lib/v9 -L/lib/64 -L/usr/lib/sparcv9 -L/usr/ccs/lib/sparcv9 '
> 	    libpth=/opt/solstudio12.2/prod/lib/sparc/64 /opt/solstudio12.2/prod/lib/v9 /lib/64 /usr/lib/sparcv9 /usr/ccs/lib/sparcv9 /usr/lib /usr/ccs/lib
> 	    libs=-lsocket -lnsl -ldl -lm -lpthread -lc
> 	    perllibs=-lsocket -lnsl -ldl -lm -lpthread -lc
> 	    libc=/usr/lib/sparcv9/libc.so, so=so, useshrplib=false, libperl=libperl.a
> 	    gnulibc_version=''
> 	  Dynamic Linking:
> 	    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
> 	    cccdlflags='-KPIC', lddlflags=' -G -xarch=generic64 -L/opt/solstudio12.2/prod/lib/sparc/64 -L/opt/solstudio12.2/prod/lib/v9 -L/lib/64 -L/usr/lib/sparcv9 -L/usr/ccs/lib/sparcv9'
> 	
> 	
> 	Characteristics of this binary (from libperl):
> 	  Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV
> 	                        PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP
> 	                        PERL_USE_SAFE_PUTENV USE_64_BIT_ALL USE_64_BIT_INT
> 	                        USE_ITHREADS USE_LARGE_FILES USE_PERLIO USE_PERL_ATOF
> 	                        USE_REENTRANT_API
> 	  Built under solaris
> 	  Compiled at Dec 24 2010 12:46:07
> 	  @INC:
> 	    /home/tester/perl/lib/site_perl/5.12.2/sun4-solaris-thread-multi-64
> 	    /home/tester/perl/lib/site_perl/5.12.2
> 	    /home/tester/perl/lib/5.12.2/sun4-solaris-thread-multi-64
> 	    /home/tester/perl/lib/5.12.2
> 	    .
> 	
> 	
>
>
>