I'm having problems with a couple on tests. The bug report is below.
Everything seems ok and most of the tests are alright but t60unlog,
t91udts and t93lvarchar are partially failing. This is on an AIX4.3.3
server. I haven't been able to find anything that might address this
sort of failure for DBD::Informix make test on the maillist.
Any suggestions would be very appreciated!
Todd
Command: BugReport D t/t60unlog.t t/t91udts.t t/t92rows.t
t/t93lvarchar.t
Date: Thu Oct 7 14:35:10 CDT 2004
Machine: sbctss (AIX 3)
User: uid=0(root) gid=0(system)
groups=2(bin),3(sys),7(security),8(cron),10(audit)
Directory: /usr/opt/perl5/lib/5.6.1/DBD-Informix-2003.04
Umask: 026
Terminal: /dev/pts/4
#
# Perl Version
Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
Platform:
osname=aix, osvers=4.3.3.0, archname=aix
uname='aix sbctss 3 4 000200554c00 '
config_args=''
hint=previous, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
Compiler:
cc='cc', ccflags ='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
-qmaxmem=16384 -DUSE_NATIVE_DLOPEN -q32 -D_LARGE_FILES -qlonglong',
optimize='-O',
cppflags='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
-qmaxmem=16384 -DUSE_NATIVE_DLOPEN -q32 -D_LARGE_FILES -qlonglong'
ccversion='4.4.0.3', gccversion='', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=8, usemymalloc=n, prototype=define
Linker and Libraries:
ld='ld', ldflags ='-brtl -b32'
libpth=/lib /usr/lib /usr/ccs/lib
libs=-lbind -lnsl -ldbm -ldl -lld -lm -lc -lcrypt -lbsd -lPW -liconv
perllibs=-lbind -lnsl -ldl -lld -lm -lc -lcrypt -lbsd -lPW -liconv
libc=/lib/libc.a, so=a, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_aix.xs, dlext=so, d_dlsymun=undef,
ccdlflags='-bE:/usr/opt/perl5/lib/5.6.1/aix/CORE/perl.exp
-bE:/usr/opt/perl5/lib/5.6.1/aix/CORE/perl.exp'
cccdlflags=' ', lddlflags='-bhalt:4 -bM:SRE -bI:$(PERL_INC)/perl.exp
-bE:$(BASEEXT).exp -b noentry -lc'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under aix
Compiled at Mar 5 2002 14:17:17
@INC:
/usr/opt/perl5/lib/5.6.1/aix
/usr/opt/perl5/lib/5.6.1
/usr/opt/perl5/lib/site_perl/5.6.1/aix
/usr/opt/perl5/lib/site_perl/5.6.1
/usr/opt/perl5/lib/site_perl
.
#
# Informix Version
INFORMIXDIR = /usr/informix
ESQLC = esql
Version = INFORMIX-ESQL Version 9.50.UC1
DBMS Version = Informix Dynamic Server 2000 Version 9.21.UC4
Informix Server Entries in sqlhosts file
#
# Sorted Environment
AUTHSTATE=files
A__z=! LOGNAME
DBD_INFORMIX_DATABASE=adsl_results
[EMAIL PROTECTED]
DBD_INFORMIX_PASSWORD2=XXXXXXXX
DBD_INFORMIX_USERNAME2=root
DBI_DBNAME=adsl_results
ENV=/.kshrc
HOME=/
INFORMIXDIR=/usr/informix
INFORMIXSERVER=sbctss_s1
INFORMIXTMP=/INFORMIXTMP
K5MUTE=1
LANG=en_US
LC__FASTMSG=true
LOCPATH=/usr/lib/nls/loc
LOGIN=root
LOGNAME=root
MAIL=/usr/spool/mail/root
MAILMSG=[YOU HAVE NEW MAIL]
MANPATH=/usr/lpp/ssp/man:/usr/share/man
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
ODMDIR=/etc/objrepos
ONCONFIG=onconfig.sbctss_s1
PATH=/usr/local/bin:/usr/bin:/etc:/usr/sbin:/usr/lbin:/usr/lclbin:/usr/t
bin:/usr/ucb://bin:/usr/bin/X11:/sbin:/usr/lpp/ssp/rcmd/bin:/usr/informi
x/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/lpp/ssp/b
in:/usr/lpp/ssp/kerberos/bin:/usr/lpp/ssp/kerberos/etc:/usr/lpp/ssp/inst
all/bin:/var/sysman:/etc/amd:/apache/bin:/usr/informix/bin:/usr/jdk_base
/bin:/var/ifor:/usr/opt/ifor/ls/conf:/usr/vac/bin:.
[EMAIL PROTECTED]:$PWD>
PWD=/usr/opt/perl5/lib/5.6.1/DBD-Informix-2003.04
SHELL=/bin/ksh
TERM=aixterm
TZ=CST6CDT
USER=root
WCOLL=/.wcoll_hosts
_=/usr/local/bin/perl
# End of Configuration Report
#
# Redoing configuration
+ [ ! -f Makefile ] || make realclean
rm -f blib/script/InformixTechSupport
rm -rf Informix.c Informix.xsi esqlinfo.h esqlvrsn.h
t/decgen.sql t/dtgen.sql lib/DBD/Informix/Defaults.pm ./blib
Makefile.aperl blib/arch/auto/DBD/Informix/extralibs.all perlmain.c
tmon.out mon.out so_locations pm_to_blib *.o *.a perl.exe perl perl
Informix.bs Informix.bso Informix.def libInformix.def Informix.exp
Informix.x core core.*perl.*.? *perl.core
mv Makefile Makefile.old > /dev/null 2>&1
[ ! -f esql ] || mv esql esql.old
rm -rf blib/lib/auto/DBD/Informix blib/arch/auto/DBD/Informix
rm -rf DBD-Informix-2003.04
rm -f blib/arch/auto/DBD/Informix/Informix.so
blib/arch/auto/DBD/Informix/Informix.bs
rm -f blib/arch/auto/DBD/Informix/Informix.a
rm -f blib/lib/DBD/Informix/TestHarness.pm
blib/lib/DBD/Informix/TechSupport.pm
rm -f blib/lib/DBD/Informix/Summary.pm
blib/lib/DBD/Informix/Configure.pm
rm -f blib/lib/DBD/Informix/Metadata.pm
blib/lib/DBD/Informix/Defaults.pm
rm -f blib/lib/Bundle/DBD/Informix.pm
blib/lib/DBD/Informix/GetInfo.pm
rm -f blib/lib/DBD/Informix/TypeInfo.pm blib/lib/DBD/Informix.pm
rm -rf Makefile Makefile.old esql
+ rm -f esql esqlvrsn.h esqlinfo.h
+ perl Makefile.PL
*** ExtUtils::AutoInstall version 0.60
*** Checking for dependencies...
Subroutine WriteMakefile redefined at
/usr/opt/perl5/lib/site_perl/5.6.1/ExtUtils/AutoInstall.pm line 487.
[Core Features]
- DBI ...loaded. (1.45 >= 1.33)
[High Resolution Timing]
- Time::HiRes ...loaded. (1.65)
*** ExtUtils::AutoInstall configuration finished.
Configuring IBM Informix Database Driver for Perl Version 2003.04
(2003-03-05) (aka DBD::Informix)
You are using DBI version 1.45 and Perl version 5.006001
Remember to actually read the README file!
Perl: perl5.006001 aix dl_aix.xs
System: aix sbctss 3 4 000200554c00
Compiler: cc -O -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
-qmaxmem=16384 -DUSE_NATIVE_DLOPEN -q32 -D_LARGE_FILES -qlonglong
Loader: ld
Using INFORMIX-ESQL Version 9.50.UC1 from /usr/informix
Beware: DBD::Informix is not yet aware of all the new IUS data types.
Assert macro will be disabled!
lib/DBD/Informix/Defaults.pm written OK
esqlvrsn.h written OK
esqlinfo.h written OK
Testing whether your Informix test environment will work...
1506-173 (W) Option 32 is not valid. Enter xlc for list of valid
options.
1506-173 (W) Option 32 is not valid. Enter xlc for list of valid
options.
ESQLTEST Program Running:
@(#)$Id: esqltest.ec,v 100.3 2002/02/08 22:49:23 jleffler Exp $
$INFORMIXDIR is set to '/usr/informix'.
$INFORMIXSERVER is set to 'sbctss_s1'.
$DBI_DBNAME set to 'adsl_results'.
$DBD_INFORMIX_DATABASE set to 'adsl_results'.
$DBD_INFORMIX_DATABASE2 set to '[EMAIL PROTECTED]'.
$DBD_INFORMIX_USERNAME is unset.
$DBD_INFORMIX_USERNAME2 is set to 'root'.
$DBD_INFORMIX_PASSWORD is unset.
$DBD_INFORMIX_PASSWORD2 is set.
Testing connection to adsl_results
CONNECT TO 'adsl_results' - no user info
Testing concurrent connection to [EMAIL PROTECTED]
CONNECT TO '[EMAIL PROTECTED]' with user info
Your Informix environment is (probably) OK
Fortunately, you are using a new version of ESQL/C. We could
use 'esql -libs' to tell us which libraries to use, except that
some versions of the esql script are very Clintonian and do not
tell us the whole truth. So we have to do a fiddly workaround,
editing the esql script on the fly and feeding the edited
version to the shell and ... Oh, you really don't want to know
what we do; it's horrid but it works, usually!
... Replacing reference to -lnetstub with /usr/informix/lib/netstub.a
(override with DBD_INFORMIX_AIX_USENETSTUB)
... We are going to use the library list:
-lifsql -lifasf -lifgen -lifos -lifgls /usr/informix/lib/netstub.a -lc_r
-ldl -ltli_r -lm_r /usr/informix/lib/esql/checkapi.o -lifglx
Checking if your kit is complete...
Looks good
Using DBI 1.45 (for perl 5.006001 on aix) installed in
/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI/
Writing Makefile for DBD::Informix
#
# Redoing build
+ make
cp lib/DBD/Informix/TestHarness.pm blib/lib/DBD/Informix/TestHarness.pm
cp lib/DBD/Informix/Summary.pm blib/lib/DBD/Informix/Summary.pm
cp lib/DBD/Informix/Defaults.pm blib/lib/DBD/Informix/Defaults.pm
cp lib/DBD/Informix/TechSupport.pm blib/lib/DBD/Informix/TechSupport.pm
cp lib/DBD/Informix/Metadata.pm blib/lib/DBD/Informix/Metadata.pm
cp lib/DBD/Informix/TypeInfo.pm blib/lib/DBD/Informix/TypeInfo.pm
cp lib/DBD/Informix/Configure.pm blib/lib/DBD/Informix/Configure.pm
cp lib/DBD/Informix/GetInfo.pm blib/lib/DBD/Informix/GetInfo.pm
cp lib/Bundle/DBD/Informix.pm blib/lib/Bundle/DBD/Informix.pm
cp Informix.pm blib/lib/DBD/Informix.pm
/usr/local/bin/perl -e 'use ExtUtils::Mksymlists;
Mksymlists("NAME" => "DBD::Informix", "DL_FUNCS" => { }, "FUNCLIST" =>
[], "DL_VARS" => []);'
/usr/local/bin/perl -p -e "s/~DRIVER~/Informix/g"
/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI//Driver.xst >
Informix.xsi
/usr/local/bin/perl /usr/opt/perl5/lib/5.6.1/ExtUtils/xsubpp
-typemap /usr/opt/perl5/lib/5.6.1/ExtUtils/typemap Informix.xs >
Informix.xsc && mv Informix.xsc Informix.c
cc -c -I/usr/informix/incl/esql
-I/usr/opt/perl5/lib/5.6.1/aix/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -I/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -DUSE_NATIVE_DLOPEN -q32
-D_LARGE_FILES -qlonglong -O -DVERSION=\"2003.04\"
-DXS_VERSION=\"2003.04\" "-I/usr/opt/perl5/lib/5.6.1/aix/CORE"
-DESQLC_VERSION=950 -DNDEBUG -qlanglvl=ansi -D__H_LOCALEDEF Informix.c
1506-173 (W) Option 32 is not valid. Enter xlc for list of valid
options.
INFORMIXC="/usr/local/bin/perl esqlcc" ESQLCC="cc" esql -c
-shared -I/usr/informix/incl/esql
-I/usr/opt/perl5/lib/5.6.1/aix/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -I/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -DUSE_NATIVE_DLOPEN -q32
-D_LARGE_FILES -qlonglong -O -DVERSION=\"2003.04\"
-DXS_VERSION=\"2003.04\" -I/usr/opt/perl5/lib/5.6.1/aix/CORE
-DESQLC_VERSION=950 -DNDEBUG -qlanglvl=ansi -D__H_LOCALEDEF dbdimp.ec
1506-173 (W) Option 32 is not valid. Enter xlc for list of valid
options.
rm -f dbdimp.c
INFORMIXC="/usr/local/bin/perl esqlcc" ESQLCC="cc" esql -c
-shared -I/usr/informix/incl/esql
-I/usr/opt/perl5/lib/5.6.1/aix/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -I/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -DUSE_NATIVE_DLOPEN -q32
-D_LARGE_FILES -qlonglong -O -DVERSION=\"2003.04\"
-DXS_VERSION=\"2003.04\" -I/usr/opt/perl5/lib/5.6.1/aix/CORE
-DESQLC_VERSION=950 -DNDEBUG -qlanglvl=ansi -D__H_LOCALEDEF dbdattr.ec
1506-173 (W) Option 32 is not valid. Enter xlc for list of valid
options.
rm -f dbdattr.c
cc -c -I/usr/informix/incl/esql
-I/usr/opt/perl5/lib/5.6.1/aix/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -I/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -DUSE_NATIVE_DLOPEN -q32
-D_LARGE_FILES -qlonglong -O -DVERSION=\"2003.04\"
-DXS_VERSION=\"2003.04\" "-I/usr/opt/perl5/lib/5.6.1/aix/CORE"
-DESQLC_VERSION=950 -DNDEBUG -qlanglvl=ansi -D__H_LOCALEDEF sqltoken.c
1506-173 (W) Option 32 is not valid. Enter xlc for list of valid
options.
INFORMIXC="/usr/local/bin/perl esqlcc" ESQLCC="cc" esql -c
-shared -I/usr/informix/incl/esql
-I/usr/opt/perl5/lib/5.6.1/aix/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -I/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -DUSE_NATIVE_DLOPEN -q32
-D_LARGE_FILES -qlonglong -O -DVERSION=\"2003.04\"
-DXS_VERSION=\"2003.04\" -I/usr/opt/perl5/lib/5.6.1/aix/CORE
-DESQLC_VERSION=950 -DNDEBUG -qlanglvl=ansi -D__H_LOCALEDEF sqltype.ec
1506-173 (W) Option 32 is not valid. Enter xlc for list of valid
options.
rm -f sqltype.c
INFORMIXC="/usr/local/bin/perl esqlcc" ESQLCC="cc" esql -c
-shared -I/usr/informix/incl/esql
-I/usr/opt/perl5/lib/5.6.1/aix/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -I/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -DUSE_NATIVE_DLOPEN -q32
-D_LARGE_FILES -qlonglong -O -DVERSION=\"2003.04\"
-DXS_VERSION=\"2003.04\" -I/usr/opt/perl5/lib/5.6.1/aix/CORE
-DESQLC_VERSION=950 -DNDEBUG -qlanglvl=ansi -D__H_LOCALEDEF ixblob.ec
1506-173 (W) Option 32 is not valid. Enter xlc for list of valid
options.
rm -f ixblob.c
cc -c -I/usr/informix/incl/esql
-I/usr/opt/perl5/lib/5.6.1/aix/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -I/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -DUSE_NATIVE_DLOPEN -q32
-D_LARGE_FILES -qlonglong -O -DVERSION=\"2003.04\"
-DXS_VERSION=\"2003.04\" "-I/usr/opt/perl5/lib/5.6.1/aix/CORE"
-DESQLC_VERSION=950 -DNDEBUG -qlanglvl=ansi -D__H_LOCALEDEF decsci.c
1506-173 (W) Option 32 is not valid. Enter xlc for list of valid
options.
cc -c -I/usr/informix/incl/esql
-I/usr/opt/perl5/lib/5.6.1/aix/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -I/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -DUSE_NATIVE_DLOPEN -q32
-D_LARGE_FILES -qlonglong -O -DVERSION=\"2003.04\"
-DXS_VERSION=\"2003.04\" "-I/usr/opt/perl5/lib/5.6.1/aix/CORE"
-DESQLC_VERSION=950 -DNDEBUG -qlanglvl=ansi -D__H_LOCALEDEF odbctype.c
1506-173 (W) Option 32 is not valid. Enter xlc for list of valid
options.
cc -c -I/usr/informix/incl/esql
-I/usr/opt/perl5/lib/5.6.1/aix/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -I/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -DUSE_NATIVE_DLOPEN -q32
-D_LARGE_FILES -qlonglong -O -DVERSION=\"2003.04\"
-DXS_VERSION=\"2003.04\" "-I/usr/opt/perl5/lib/5.6.1/aix/CORE"
-DESQLC_VERSION=950 -DNDEBUG -qlanglvl=ansi -D__H_LOCALEDEF link.c
1506-173 (W) Option 32 is not valid. Enter xlc for list of valid
options.
INFORMIXC="/usr/local/bin/perl esqlcc" ESQLCC="cc" esql -c
-shared -I/usr/informix/incl/esql
-I/usr/opt/perl5/lib/5.6.1/aix/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -I/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -DUSE_NATIVE_DLOPEN -q32
-D_LARGE_FILES -qlonglong -O -DVERSION=\"2003.04\"
-DXS_VERSION=\"2003.04\" -I/usr/opt/perl5/lib/5.6.1/aix/CORE
-DESQLC_VERSION=950 -DNDEBUG -qlanglvl=ansi -D__H_LOCALEDEF esqlcver.ec
1506-173 (W) Option 32 is not valid. Enter xlc for list of valid
options.
rm -f esqlcver.c
INFORMIXC="/usr/local/bin/perl esqlcc" ESQLCC="cc" esql -c
-shared -I/usr/informix/incl/esql
-I/usr/opt/perl5/lib/5.6.1/aix/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -I/auto/DBI
-I/usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -DUSE_NATIVE_DLOPEN -q32
-D_LARGE_FILES -qlonglong -O -DVERSION=\"2003.04\"
-DXS_VERSION=\"2003.04\" -I/usr/opt/perl5/lib/5.6.1/aix/CORE
-DESQLC_VERSION=950 -DNDEBUG -qlanglvl=ansi -D__H_LOCALEDEF esqlc_v6.ec
1506-173 (W) Option 32 is not valid. Enter xlc for list of valid
options.
rm -f esqlc_v6.c
Running Mkbootstrap for DBD::Informix ()
chmod 644 Informix.bs
rm -f blib/arch/auto/DBD/Informix/Informix.so
LD_RUN_PATH="" ld -bhalt:4 -bM:SRE
-bI:/usr/opt/perl5/lib/5.6.1/aix/CORE/perl.exp -bE:Informix.exp -b
noentry -lc Informix.o dbdimp.o dbdattr.o sqltoken.o sqltype.o ixblob.o
decsci.o odbctype.o link.o esqlcver.o esqlc_v6.o -L/usr/informix/lib
-L/usr/informix/lib/esql -lifsql -lifasf -lifgen -lifos -lifgls
/usr/informix/lib/netstub.a -lc_r -ldl -ltli_r -lm_r
/usr/informix/lib/esql/checkapi.o -lifglx -o
blib/arch/auto/DBD/Informix/Informix.so
chmod 755 blib/arch/auto/DBD/Informix/Informix.so
cp Informix.bs blib/arch/auto/DBD/Informix/Informix.bs
chmod 644 blib/arch/auto/DBD/Informix/Informix.bs
cp InformixTechSupport blib/script/InformixTechSupport
/usr/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)"
blib/script/InformixTechSupport
Manifying blib/man3/DBD::Informix::TestHarness.3
Manifying blib/man3/DBD::Informix::Summary.3
Manifying blib/man3/DBD::Informix::Defaults.3
Manifying blib/man3/DBD::Informix::Metadata.3
Manifying blib/man1/InformixTechSupport.1
Manifying blib/man3/DBD::Informix::TypeInfo.3
Manifying blib/man3/DBD::Informix::TechSupport.3
Manifying blib/man3/DBD::Informix::Configure.3
Manifying blib/man3/Bundle::DBD::Informix.3
Manifying blib/man3/DBD::Informix.3
Target "makemakerdflt" is up to date.
#
# Redoing general testing
+ make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM"
"-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/t00basic.t
t/t01stproc.t t/t02ixtype.t t/t05dbase.t t/t07dblist.t t/t09exec.t
t/t10sqlca.t t/t12bindval.t t/t13bindref.t t/t14bindcol.t t/t15bindtyp.t
t/t20error.t t/t21mconn.t t/t22mconn.t t/t23mconn.t t/t24mcurs.t
t/t25dratt.t t/t28dtlit.t t/t29update.t t/t30update.t t/t31nulls.t
t/t32nulls.t t/t35cursor.t t/t40rows.t t/t41txacoff.t t/t42txacon.t
t/t43trans.t t/t44txansi.t t/t46chpblk.t t/t50update.t t/t51getinfo.t
t/t53types.t t/t54native.t t/t55mdata.t t/t56tabinfo.t t/t57tables.t
t/t58typeinfoall.t t/t60unlog.t t/t65updcur.t t/t66insert.t t/t72blob.t
t/t73blobupd.t t/t74blob.t t/t75blob.t t/t76blob.t t/t90ius.t
t/t91udts.t t/t92rows.t t/t93lvarchar.t t/t94bool.t t/t99clean.t
t/t00basic..........ok
t/t01stproc.........ok
t/t02ixtype.........ok
t/t05dbase..........DBD::Informix::db do failed: SQL: -330: Cannot
create or rename database.
ISAM: -100: ISAM error: duplicate value for a record with unique key.
at
/usr/opt/perl5/lib/5.6.1/DBD-Informix-2003.04/blib/lib/DBD/Informix/Test
Harness.pm line 336.
DBD::Informix::db prepare failed: SQL: -349: Database not selected yet.
at t/t05dbase.t line 39.
Can't call method "execute" on an undefined value at t/t05dbase.t line
40.
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-13
Failed 12/13 tests, 7.69% okay
t/t07dblist.........ok
t/t09exec...........ok
t/t10sqlca..........ok
t/t12bindval........ok
t/t13bindref........skipped
all skipped: bind_param_inout not supported by DBD::Informix
t/t14bindcol........ok
t/t15bindtyp........ok
t/t20error..........ok
t/t21mconn..........ok
t/t22mconn..........ok
t/t23mconn..........ok
t/t24mcurs..........ok
t/t25dratt..........ok
t/t28dtlit..........ok
t/t29update.........ok
t/t30update.........ok
t/t31nulls..........ok
t/t32nulls..........ok
t/t35cursor.........ok
t/t40rows...........ok
t/t41txacoff........ok
t/t42txacon.........ok
t/t43trans..........ok
t/t44txansi.........skipped
all skipped: MODE ANSI test - database 'adsl_results' is not
MODE ANSI
t/t46chpblk.........ok
t/t50update.........ok
t/t51getinfo........ok
t/t53types..........ok
t/t54native.........ok
t/t55mdata..........ok
t/t56tabinfo........ok
t/t57tables.........ok
t/t58typeinfoall....ok
t/t60unlog..........!! Terminating Test !!
DBD::Informix::TestHarness::stmt_fail called at t/t60unlog.t
line 73
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 8-9
Failed 2/9 tests, 77.78% okay
t/t65updcur.........ok
t/t66insert.........ok
t/t72blob...........ok
t/t73blobupd........ok
t/t74blob...........ok
t/t75blob...........ok
t/t76blob...........ok
t/t90ius............ok
t/t91udts...........DBD::Informix::st execute failed: SQL: -9602:
Illegal attempt to convert a collection type into another type. at
t/t91udts.t line 130.
Died at t/t91udts.t line 130.
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 10-16
Failed 7/16 tests, 56.25% okay
t/t92rows...........DBD::Informix::db do failed: SQL: -9991: Named row
type (dbd_ix_udts_named) already exists in database. at t/t92rows.t line
27.
DBD::Informix::db do failed: SQL: -9990: Cannot drop named row type
(dbd_ix_udts_named): still in use. at t/t92rows.t line 133.
ok
t/t93lvarchar.......DBD::Informix::db do failed: SQL: -9996: Distinct
type (root.dbd_ix_distoflvc) already exists in database. at
/usr/opt/perl5/lib/5.6.1/DBD-Informix-2003.04/blib/lib/DBD/Informix/Test
Harness.pm line 336.
DBD::Informix::db do failed: SQL: -9630: Cannot drop type
(dbd_ix_distoflvc): still in use. at t/t93lvarchar.t line 119.
dubious
Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 1
Failed 1/7 tests, 85.71% okay
t/t94bool...........ok
t/t99clean..........ok
Failed 4/51 test scripts, 92.16% okay. 22/1226 subtests failed, 98.21%
okay.
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------------------
-------
t/t05dbase.t 255 65280 13 23 176.92% 2-13
t/t60unlog.t 255 65280 9 3 33.33% 8-9
t/t91udts.t 255 65280 16 14 87.50% 10-16
t/t93lvarchar.t 1 256 7 1 14.29% 1
2 tests skipped.
make: 1254-004 The error code from the last command is 11.
Stop.
failed on general testing at
/usr/opt/perl5/lib/site_perl/5.6.1/aix/DBD/Informix/TechSupport.pm line
235.
#
# Doing selective testing
+ sh test.one.sh t/t60unlog.t t/t91udts.t t/t92rows.t t/t93lvarchar.t
# Test DBI->connect('dbi:Informix:.DEFAULT.')
1..9
ok 1
# Create unlogged database dbd_ix_db
# Test: do('create database dbd_ix_db'):
ok 2
ok 3
# Passed 1 row(s) as expected with no failures
ok 4
# Test: do('close database'):
ok 5
ok 6
# Test DBI->connect('dbi:Informix:dbd_ix_db',...,{AutoCommit=>0})
!! Terminating Test !!
DBD::Informix::TestHarness::stmt_fail called at t/t60unlog.t
line 73
# Connection failed - which is the correct response
ok 7
not ok 8
# Error Message:
# SQL: -256: Transaction not available.
# SQLSTATE =
# Driver Information
# Name: Informix
# Version: 2003.04
# Product: INFORMIX-ESQL Version 9.50.UC1
# Product Version: 950
# Connect to: adsl_results
# IUS data types can be tested!
1..16
# drop table dbd_ix_udts
# Error Message:
# SQL: -206: The specified table (dbd_ix_udts) is not in the database.
# ISAM: -111: ISAM error: no record found.
# SQLSTATE = 42000
# drop type dbd_ix_distofi8 restrict
# drop type dbd_ix_distofbool restrict
# drop type dbd_ix_distoflvc restrict
# drop type dbd_ix_distofnamed restrict
# drop row type dbd_ix_udts_named restrict
# Test: do('create row type dbd_ix_udts_named (i int)'):
ok 1
# Test: do('create distinct type dbd_ix_distofi8 as int8'):
ok 2
# Test: do('create distinct type dbd_ix_distofbool as boolean'):
ok 3
# Test: do('create distinct type dbd_ix_distoflvc as lvarchar'):
ok 4
# Test: do('create distinct type dbd_ix_distofnamed as
dbd_ix_udts_named'):
ok 5
# Test: do('
# create table dbd_ix_udts
# (s8 serial8,
# i8 int8,
# b boolean,
# lvc lvarchar,
# unnamed row(i int, l lvarchar),
# named dbd_ix_udts_named,
# sint set(int not null),
# lunnamed list(row(i int, c char(10)) not null),
# mnamed multiset(dbd_ix_udts_named not null),
# di8 dbd_ix_distofi8,
# db dbd_ix_distofbool,
# dlvc dbd_ix_distoflvc,
# dnamed dbd_ix_distofnamed, cl clob) put cl in (sbspace)'):
ok 6
# Test: do('
# insert into dbd_ix_udts values
# (1, 1, 't',
'12345678901234567890123456789012345678901234567890123456789012345678901
234567890123456789012345678901234567890123456789012345678901234567890123
456789012345678901234567890123456789012345678901234567890123456789012345
678901234567890123456789012345678901234567890123456789012345678901234567
8901234567890', row(1,
'12345678901234567890123456789012345678901234567890123456789012345678901
234567890123456789012345678901234567890123456789012345678901234567890123
456789012345678901234567890123456789012345678901234567890123456789012345
678901234567890123456789012345678901234567890123456789012345678901234567
8901234567890'), row(1)::dbd_ix_udts_named,
# set{1, 10, 100}, list{row(1, 'one')},
multiset{row(1)::dbd_ix_udts_named},
# '1', 't',
'12345678901234567890123456789012345678901234567890123456789012345678901
234567890123456789012345678901234567890123456789012345678901234567890123
456789012345678901234567890123456789012345678901234567890123456789012345
678901234567890123456789012345678901234567890123456789012345678901234567
8901234567890', row(1)::dbd_ix_distofnamed , filetoclob('t/t91udts.t',
'client'))
# '):
ok 7
# PREPARE: insert into dbd_ix_udts values (?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ? , filetoclob(?, 'client'))
ok 8
ok 9
# inserted nulls OK
DBD::Informix::st execute failed: SQL: -9602: Illegal attempt to convert
a collection type into another type. at t/t91udts.t line 130.
Died at t/t91udts.t line 130.
# Driver Information
# Name: Informix
# Version: 2003.04
# Product: INFORMIX-ESQL Version 9.50.UC1
# Product Version: 950
# Connect to: adsl_results
# IUS data types can be tested!
1..11
# drop table dbd_ix_rows
# Error Message:
# SQL: -206: The specified table (dbd_ix_rows) is not in the database.
# ISAM: -111: ISAM error: no record found.
# SQLSTATE = 42000
# drop row type dbd_ix_udts_named restrict
# Error Message:
# SQL: -9990: Cannot drop named row type (dbd_ix_udts_named): still in
use.
# SQLSTATE = IX000
# create row type dbd_ix_udts_named (i int)
DBD::Informix::db do failed: SQL: -9991: Named row type
(dbd_ix_udts_named) already exists in database. at t/t92rows.t line 27.
# Error Message:
# SQL: -9991: Named row type (dbd_ix_udts_named) already exists in
database.
# SQLSTATE = IX000
#
create temp table dbd_ix_rows
(rownum serial not null primary key,
unnamed row(i int, l lvarchar),
named dbd_ix_udts_named
)
# Test: do(' insert into dbd_ix_rows values (0, row(1,
'12345678901234567890123456789012345678901234567890123456789012345678901
234567890123456789012345678901234567890123456789012345678901234567890123
456789012345678901234567890123456789012345678901234567890123456789012345
678901234567890123456789012345678901234567890123456789012345678901234567
8901234567890'), row(1)::dbd_ix_udts_named); '):
ok 1
# PREPARE: insert into dbd_ix_rows values (?, ?, ?)
ok 2
ok 3
# inserted nulls OK
# inserted 3
# PREPARE: select rownum, unnamed, named from dbd_ix_rows
ok 4
# ROW-1: 1 ROW(1
,'1234567890123456789012345678901234567890123456789012345678901234567890
123456789012345678901234567890123456789012345678901234567890123456789012
345678901234567890123456789012345678901234567890123456789012345678901234
5678901234567890123456789 ROW(1 )
# ROW-2: 2 . .
# ROW-3: 3 ROW(3 ,'three') ROW(3 )
# fetched 3
# PREPARE: update dbd_ix_rows set unnamed = ?, named = ? where rownum =
? and unnamed = ? and named = ?
ok 5
# EXECUTE
# updated 1
ok 6
# PREPARE: delete from dbd_ix_rows where rownum = ? and unnamed = ? and
named = ?
ok 7
# EXECUTE
ok 8
# deleted 1
ok 9
DBD::Informix::db do failed: SQL: -9990: Cannot drop named row type
(dbd_ix_udts_named): still in use. at t/t92rows.t line 133.
ok 10
ok 11
# *** Testing of DBD::Informix complete ***
# *** You appear to be normal! ***
# Driver Information
# Name: Informix
# Version: 2003.04
# Product: INFORMIX-ESQL Version 9.50.UC1
# Product Version: 950
# Connect to: adsl_results
# IUS data types can be tested!
1..7
# drop table dbd_ix_lvarchar
# Error Message:
# SQL: -206: The specified table (dbd_ix_lvarchar) is not in the
database.
# ISAM: -111: ISAM error: no record found.
# SQLSTATE = 42000
# drop type dbd_ix_distoflvc restrict
# Error Message:
# SQL: -9630: Cannot drop type (dbd_ix_distoflvc): still in use.
# SQLSTATE = IX000
# Test: do('create distinct type dbd_ix_distoflvc as lvarchar'):
DBD::Informix::db do failed: SQL: -9996: Distinct type
(root.dbd_ix_distoflvc) already exists in database. at
blib/lib/DBD/Informix/TestHarness.pm line 336.
not ok 1
# Test: do('
# create table dbd_ix_lvarchar (s serial, lvc lvarchar, dlvc
dbd_ix_distoflvc)'):
ok 2
# Test: do('insert into dbd_ix_lvarchar values (10203040,
'12345678901234567890123456789012345678901234567890',
'12345678901234567890123456789012345678901234567890')'):
ok 3
# PREPARE: insert into dbd_ix_lvarchar values (?, ?, ?)
ok 4
ok 5
# inserted nulls OK
# PREPARE: select s, lvc from dbd_ix_lvarchar order by s
# ROW-1: 10203040 12345678901234567890123456789012345678901234567890
# ROW-2: 11213141 12345678901234567890123456789012345678901234567890
# ROW-3: 12223242 .
# fetched 3 rows
# PREPARE: select s, lvc, dlvc from dbd_ix_lvarchar order by s
# ROW-1: 10203040 12345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890
# ROW-2: 11213141 12345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890
# ROW-3: 12223242 . .
# fetched 3 rows
# PREPARE: select s, lvc, dlvc, 'abc'::lvarchar from dbd_ix_lvarchar
order by s
# ROW-1: 10203040 12345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890 abc
# ROW-2: 11213141 12345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890 abc
# ROW-3: 12223242 . . abc
# fetched 3 rows
# PREPARE: select s, lvc, dlvc, 'abc'::lvarchar, lvc as lvc_2 from
dbd_ix_lvarchar order by s
# ROW-1: 10203040 12345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890 abc
12345678901234567890123456789012345678901234567890
# ROW-2: 11213141 12345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890 abc
12345678901234567890123456789012345678901234567890
# ROW-3: 12223242 . . abc .
# fetched 3 rows
# PREPARE: select s, lvc, dlvc, 'abc'::lvarchar, lvc as lvc_2, dlvc as
dlvc_2 from dbd_ix_lvarchar order by s
# ROW-1: 10203040 12345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890 abc
12345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890
# ROW-2: 11213141 12345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890 abc
12345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890
# ROW-3: 12223242 . . abc . .
# fetched 3 rows
DBD::Informix::db do failed: SQL: -9630: Cannot drop type
(dbd_ix_distoflvc): still in use. at t/t93lvarchar.t line 119.
ok 6
ok 7
# *** Testing of DBD::Informix complete ***
# *** There appear to be some problems! ***
# End of Bug Report
Todd E. O'Dell
Network Services ( DATA )
Room 1118
500 E. 8th
Kansas City, MO 64106
Office: (816)275-3626
Alpha Page: [EMAIL PROTECTED]
[EMAIL PROTECTED]
Rigidity and inflexibility are forever the enemy of ingenuity and
creativity. -- Teodor Zlatanov
