Hi,
I have 2 class D problems when testing DBD::Informix.
I can build DBD::Informix, to use with IDS 7.31.FD4, but 2 of the tests
fail.
I will include the ouput requested by the bug.reports file, but I want to
point
out first that the t35cursor.t program has a table identifier that is longer
than the 18-byte restriction stated in the IDS 7.3 SQL Reference. I think
that
I must be missing something here because I doubt that the test program would
be coded to violate an Informix sql restriction. The problem is in the
following source lines from this file:
my ($table) = "dbd_ix_cursor_state";
# Create table for testing
stmt_test $dbh, qq{
CREATE TEMP TABLE $table
(
Col01 SERIAL(1000) NOT NULL,
Col02 CHAR(20) NOT NULL,
Col03 INTEGER NOT NULL,
Col04 DATETIME YEAR TO FRACTION(5) NOT NULL,
Col05 DECIMAL NOT NULL
)
where dbd_ix_cursor_state is longer than 18 characters.
NOTE: as demonstrated below, if I shorten the table identifier to 18 chars,
all of the tests in t35cursor.t run OK.
If there is someway to have sql identifier lengths > 18, please let me know
because we would like to use DBD::Informix and the Informix engine for the
backend to Perl and PHP scripts that form the HORDE/IMP Webmail package.
Also, I have shown what happens below with my 2nd problem, which is a
separate
issue from this identifier length issue. Is my version of Perl (5.6.1 ??)
OK?
Below is the info requested in the bug.reports file for proper tech support.
Thanks in advance for your help.
Sincerely,
Jim Cramer
Data Base Administrator
Computer Systems Support,
College of Engineering,
University of Iowa
1252 SC
Iowa City, Iowa 52242
(319)335-5757
(319)384-0549 (fax)
OK, here goes the necessary support info:
1. Full details of which version of Informix ESQL/C and Perl you're using.
perl -V
Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
Platform:
osname=hpux, osvers=11.11, archname=PA-RISC2.0
uname='hp-ux server14 b.11.11 u 9000785 2015264083 unlimited-user
license '
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 +z', ccflags
='-D_HPUX_SOURCE -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BIT
S=64 -Ae',
optimize='-O',
cppflags='-D_HPUX_SOURCE -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OF
FSET_BITS=64 -Ae'
ccversion='B.11.11.28706.GP', gccversion='', gccosandvers=''
ntsize=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=8
alignbytes=8, usemymalloc=n, prototype=define
Linker and Libraries:
ld='ld', ldflags =' -Wl,+vnocompatwarnings -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
libs=-lnsl -lnm -lndbm -lmalloc -ldld -lm -lc -lndir -lcrypt -lsec -liconv
perllibs=-lnsl -lnm -lmalloc -ldld -lm -lc -lndir -lcrypt -lsec -liconv
libc=/lib/libc.sl, so=sl, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_hpux.xs, dlext=sl, d_dlsymun=undef,
ccdlflags='-Wl,-E -Wl,-B,deferred '
cccdlflags='+z', lddlflags='-b +vnocompatwarnings -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under hpux
Compiled at Jun 23 2003 14:12:13
@INC:
/usr/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0
/usr/local/opt/perl-5.6.1/lib/5.6.1
/usr/local/opt/perl-5.6.1/lib/site_perl/5.6.1/PA-RISC2.0
/usr/local/opt/perl-5.6.1/lib/site_perl/5.6.1
/usr/local/opt/perl-5.6.1/lib/site_perl
esql -V
IBM Informix CSDK Version 2.81, IBM Informix-ESQL Version 9.53.HC1
Software Serial Number RDS#N000000
server08$ onstat -V
Informix Dynamic Server Version 7.31.FD4 Software Serial Number
AAD#J332450
server08$ cat $INFORMIXSQLHOSTS
ids onsoctcp 128.255.17.48 sqlids
****************************************************************************
****************************
2. A complete, sorted dump of your environment:
server14$ env | sort
CCOPTS=+e
COLUMNS=132
DBD_INFORMIX_DATABASE=webmail
DBD_INFORMIX_PASSWORD=XXXXXXXX
DBD_INFORMIX_USERNAME=jcramer
DBI_DBNAME=webmail
EDITOR=vi
ENV=${START[ (_$- = 1) + ( _ = 0 ) - ( _$- != _${-%%*i*} ) ]}
ERASE=^H
HISTFILE=/user/sys/root/.sh_history
HOME=/user/sys/root
INFORMIXDIR=/usr/local/opt/informixclientsdk-2.81.HC1
INFORMIXSERVER=ids
KRB5CCNAME=FILE:/tmp/krb5cc_0_l11690
LD_LIBRARY_PATH=/usr/local/opt/informixclientsdk-2.81.HC1/lib:/usr/local/opt
/informixclientsdk-2.81.HC1/lib/esql:/usr/lib
LINES=51
[EMAIL PROTECTED]:[EMAIL PROTECTED]:
[EMAIL PROTECTED]
LOGNAME=jim_r
MAIL=/var/mail/root
MANPATH=/opt/mpi/share/man:/usr/share/man/%L:/usr/share/man:/usr/contrib/man
/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/upgrade/share/man
/%L:/opt/upgrade/share/man:/usr/dt/share/man:/opt/samba/man:/opt/pd/share/ma
n/%L:/opt/pd/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/pd/share/
man/%L:/opt/pd/share/man:/opt/resmon/share/man:/opt/graphics/phigs/share/man
:/opt/hparray/share/man/%L:/opt/hparray/share/man:/opt/graphics/common/man:/
/opt/perl/man:/opt/scr/share/man:/opt/OpenSource/man:/opt/videoout/share/man
:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/ldapux/share/man:/opt/l
dapux/ypldapd/man:/opt/aCC/share/man/%L:/opt/aCC/share/man:/opt/audio/share/
man:/opt/ansic/share/man/%L:/opt/ansic/share/man:/opt/langtools/share/man/%L
:/opt/langtools/share/man:/opt/perf/man/%L:/opt/perf/man:/opt/image/share/ma
n:/opt/imake/man:/opt/ipf/man
NODENAME=server14
NODETYPE=9000/785
ODBCINI=/usr/local/etc/odbc.ini
PAGER=more
PATH=/usr/local/opt/informixclientsdk-2.81.HC1/bin:/usr/sbin:/usr/bin:/usr/c
cs/bin:/usr/contrib/bin:/opt/mpi/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt
/upgrade/bin:/opt/fcms/bin:/opt/netscape:/usr/local/bin:/usr/contrib/bin:/us
r/bin/X11:/usr/contrib/bin/X11:/opt/pd/bin:/opt/resmon/bin:/opt/graphics/phi
gs/bin:/opt/graphics/common/bin:/opt/scr/bin:/usr/sbin/diag/contrib:/opt/Ope
nSource/bin:/opt/aCC/bin:/opt/ansic/bin:/opt/langtools/bin:/opt/perf/bin:/op
t/imake/bin:/opt/ignite/bin:/opt/ipf/bin:/sbin:/home/root
PS1=server14$
PWD=/usr/local/opt/DBD-Informix-1.04.PC1/src/DBD-Informix-1.04.PC1
SHELL=/bin/ksh
SSH_CLIENT=128.255.17.32 49852 22
SSH_TTY=/dev/pts/5
START=/etc/kshrc
SYSTEMTYPE=HP-UX
TERM=vt100
TZ=CST6CDT
USER=jim_r
VISUAL=/usr/local/bin/dxvi
_=/usr/bin/env
****************************************************************************
**********************************
3. A log of a complete build:
for A,B,C,D
server14$ make realclean
server14$ perl Makefile.PL
Configuring Informix Database Driver for Perl Version 1.04.PC1 (2002-11-21)
(aka DBD::Informix)
You are using DBI version 1.37 and Perl version 5.006001
Remember to actually read the README file!
Perl: perl5.006001 PA-RISC2.0 dl_hpux.xs
System: hp-ux server14 b.11.11 u 9000785 2015264083 unlimited-user license
Compiler: cc
+z -O -D_HPUX_SOURCE -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET
_BITS=64 -Ae
Loader: ld
Using IBM Informix CSDK Version 2.81, IBM Informix-ESQL Version 9.53.HC1
from /usr/local/opt/informixclientsdk-2.81.HC1
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...
ESQLTEST Program Running:
@(#)$Id: esqltest.ec,v 100.3 2002/02/08 22:49:23 jleffler Exp $
$INFORMIXDIR is set to '/usr/local/opt/informixclientsdk-2.81.HC1'.
$INFORMIXSERVER is set to 'ids'.
$DBI_DBNAME set to 'webmail'.
$DBD_INFORMIX_DATABASE set to 'webmail'.
$DBD_INFORMIX_DATABASE2 unset - defaulting to 'webmail'.
$DBD_INFORMIX_USERNAME is set to 'jcramer'.
$DBD_INFORMIX_USERNAME2 is unset - defaulting to 'jcramer'.
$DBD_INFORMIX_PASSWORD is set.
$DBD_INFORMIX_PASSWORD2 is unset - defaulting to
$DBD_INFORMIX_PASSWORD.
Testing connection to webmail
CONNECT TO 'webmail' with user info
Testing concurrent connection to webmail
CONNECT TO 'webmail' 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!
... Removing reference to -lcl (override with DBD_INFORMIX_HPUX_USELIBCL)
... We are going to use the library list:
-lifsql -lifasf -lifgen -lifos -lifgls -lnsl_s -lm -lsec -lnsl_s
/usr/local/opt/informixclientsdk-2.81.HC1/lib/esql/checkapi.o -lifglx
Checking if your kit is complete...
Looks good
Using DBI 1.37 installed in
/usr/local/opt/perl-5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI
Writing Makefile for DBD::Informix
server14$
****************************************************************************
*******************************
For B, C, D failures:
server14$ make
cp lib/DBD/Informix/TechSupport.pm blib/lib/DBD/Informix/TechSupport.pm
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/Configuration.pm blib/lib/DBD/Informix/Configuration.pm
cp lib/Bundle/DBD/Informix.pm blib/lib/Bundle/DBD/Informix.pm
cp Informix.pm blib/lib/DBD/Informix.pm
/bin/sh -c true
/bin/sh -c true
/usr/local/bin/perl -p -e "s/~DRIVER~/Informix/g" <
/usr/local/opt/perl-5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI/Driver.xst
> Informix.xsi
/usr/local/bin/perl -I/usr/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0 -I/usr/
local/opt/perl-5.6.1/lib/5.6.1
/usr/local/opt/perl-5.6.1/lib/5.6.1/ExtUtils/xsubpp -typemap
/usr/local/opt/perl-5.6.1/lib/5.6.1/ExtUtils/typemap Informix.xs >
Informix.xsc && mv Informix.xsc Informix.c
Warning: duplicate function definition 'data_sources' detected in
Informix.xs, line 107
cc
+z -c -I/usr/local/opt/informixclientsdk-2.81.HC1/incl/esql -I/usr/local/opt
/perl-5.6.1/lib/5.6.1/PA-RISC2.0/auto/DBI -I/usr/local/opt/perl-5.6.1/lib/si
te_perl/5.6.1/PA-RISC2.0/auto/DBI -I/auto/DBI -I/usr/local/opt/perl-5.6.1/li
b/site_perl/5.6.1/PA-RISC2.0/auto/DBI -D_HPUX_SOURCE -I/usr/local/include -D
_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae -O -DVERSION=\"1.04.PC1\" -
DXS_VERSION=\"1.04.PC1\"
+z -I/usr/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/CORE -DESQLC_VERSION=953
-DNDEBUG Informix.c
cc: "/usr/include/sys/socket.h", line 504: warning 562: Redeclaration of
"sendfile" with a different storage class specifier: "sendfile" will have
internal linkage.
cc: "/usr/include/sys/socket.h", line 505: warning 562: Redeclaration of
"sendpath" with a different storage class specifier: "sendpath" will have
internal linkage.
INFORMIXC="/usr/local/bin/perl esqlcc" ESQLCC="cc +z"
esql -c -shared -I/usr/local/opt/informixclientsdk-2.81.HC1/incl/esql -I/us
r/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/auto/DBI -I/usr/local/opt/perl-5
.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI -I/auto/DBI -I/usr/local/opt/pe
rl-5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI -D_HPUX_SOURCE -I/usr/loca
l/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae -O -DVERSION=\"
1.04.PC1\" -DXS_VERSION=\"1.04.PC1\"
+z -I/usr/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/CORE -DESQLC_VERSION=953
-DNDEBUG dbdimp.ec
cc: "/usr/include/sys/socket.h", line 504: warning 562: Redeclaration of
"sendfile" with a different storage class specifier: "sendfile" will have
internal linkage.
cc: "/usr/include/sys/socket.h", line 505: warning 562: Redeclaration of
"sendpath" with a different storage class specifier: "sendpath" will have
internal linkage.
rm -f dbdimp.c
INFORMIXC="/usr/local/bin/perl esqlcc" ESQLCC="cc +z"
esql -c -shared -I/usr/local/opt/informixclientsdk-2.81.HC1/incl/esql -I/us
r/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/auto/DBI -I/usr/local/opt/perl-5
.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI -I/auto/DBI -I/usr/local/opt/pe
rl-5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI -D_HPUX_SOURCE -I/usr/loca
l/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae -O -DVERSION=\"
1.04.PC1\" -DXS_VERSION=\"1.04.PC1\"
+z -I/usr/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/CORE -DESQLC_VERSION=953
-DNDEBUG dbdattr.ec
cc: "/usr/include/sys/socket.h", line 504: warning 562: Redeclaration of
"sendfile" with a different storage class specifier: "sendfile" will have
internal linkage.
cc: "/usr/include/sys/socket.h", line 505: warning 562: Redeclaration of
"sendpath" with a different storage class specifier: "sendpath" will have
internal linkage.
rm -f dbdattr.c
cc
+z -c -I/usr/local/opt/informixclientsdk-2.81.HC1/incl/esql -I/usr/local/opt
/perl-5.6.1/lib/5.6.1/PA-RISC2.0/auto/DBI -I/usr/local/opt/perl-5.6.1/lib/si
te_perl/5.6.1/PA-RISC2.0/auto/DBI -I/auto/DBI -I/usr/local/opt/perl-5.6.1/li
b/site_perl/5.6.1/PA-RISC2.0/auto/DBI -D_HPUX_SOURCE -I/usr/local/include -D
_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae -O -DVERSION=\"1.04.PC1\" -
DXS_VERSION=\"1.04.PC1\"
+z -I/usr/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/CORE -DESQLC_VERSION=953
-DNDEBUG sqltoken.c
INFORMIXC="/usr/local/bin/perl esqlcc" ESQLCC="cc +z"
esql -c -shared -I/usr/local/opt/informixclientsdk-2.81.HC1/incl/esql -I/us
r/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/auto/DBI -I/usr/local/opt/perl-5
.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI -I/auto/DBI -I/usr/local/opt/pe
rl-5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI -D_HPUX_SOURCE -I/usr/loca
l/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae -O -DVERSION=\"
1.04.PC1\" -DXS_VERSION=\"1.04.PC1\"
+z -I/usr/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/CORE -DESQLC_VERSION=953
-DNDEBUG sqltype.ec
rm -f sqltype.c
INFORMIXC="/usr/local/bin/perl esqlcc" ESQLCC="cc +z"
esql -c -shared -I/usr/local/opt/informixclientsdk-2.81.HC1/incl/esql -I/us
r/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/auto/DBI -I/usr/local/opt/perl-5
.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI -I/auto/DBI -I/usr/local/opt/pe
rl-5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI -D_HPUX_SOURCE -I/usr/loca
l/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae -O -DVERSION=\"
1.04.PC1\" -DXS_VERSION=\"1.04.PC1\"
+z -I/usr/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/CORE -DESQLC_VERSION=953
-DNDEBUG ixblob.ec
rm -f ixblob.c
cc
+z -c -I/usr/local/opt/informixclientsdk-2.81.HC1/incl/esql -I/usr/local/opt
/perl-5.6.1/lib/5.6.1/PA-RISC2.0/auto/DBI -I/usr/local/opt/perl-5.6.1/lib/si
te_perl/5.6.1/PA-RISC2.0/auto/DBI -I/auto/DBI -I/usr/local/opt/perl-5.6.1/li
b/site_perl/5.6.1/PA-RISC2.0/auto/DBI -D_HPUX_SOURCE -I/usr/local/include -D
_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae -O -DVERSION=\"1.04.PC1\" -
DXS_VERSION=\"1.04.PC1\"
+z -I/usr/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/CORE -DESQLC_VERSION=953
-DNDEBUG decsci.c
cc
+z -c -I/usr/local/opt/informixclientsdk-2.81.HC1/incl/esql -I/usr/local/opt
/perl-5.6.1/lib/5.6.1/PA-RISC2.0/auto/DBI -I/usr/local/opt/perl-5.6.1/lib/si
te_perl/5.6.1/PA-RISC2.0/auto/DBI -I/auto/DBI -I/usr/local/opt/perl-5.6.1/li
b/site_perl/5.6.1/PA-RISC2.0/auto/DBI -D_HPUX_SOURCE -I/usr/local/include -D
_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae -O -DVERSION=\"1.04.PC1\" -
DXS_VERSION=\"1.04.PC1\"
+z -I/usr/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/CORE -DESQLC_VERSION=953
-DNDEBUG odbctype.c
cc
+z -c -I/usr/local/opt/informixclientsdk-2.81.HC1/incl/esql -I/usr/local/opt
/perl-5.6.1/lib/5.6.1/PA-RISC2.0/auto/DBI -I/usr/local/opt/perl-5.6.1/lib/si
te_perl/5.6.1/PA-RISC2.0/auto/DBI -I/auto/DBI -I/usr/local/opt/perl-5.6.1/li
b/site_perl/5.6.1/PA-RISC2.0/auto/DBI -D_HPUX_SOURCE -I/usr/local/include -D
_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae -O -DVERSION=\"1.04.PC1\" -
DXS_VERSION=\"1.04.PC1\"
+z -I/usr/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/CORE -DESQLC_VERSION=953
-DNDEBUG link.c
cc: "/usr/include/sys/socket.h", line 504: warning 562: Redeclaration of
"sendfile" with a different storage class specifier: "sendfile" will have
internal linkage.
cc: "/usr/include/sys/socket.h", line 505: warning 562: Redeclaration of
"sendpath" with a different storage class specifier: "sendpath" will have
internal linkage.
INFORMIXC="/usr/local/bin/perl esqlcc" ESQLCC="cc +z"
esql -c -shared -I/usr/local/opt/informixclientsdk-2.81.HC1/incl/esql -I/us
r/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/auto/DBI -I/usr/local/opt/perl-5
.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI -I/auto/DBI -I/usr/local/opt/pe
rl-5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI -D_HPUX_SOURCE -I/usr/loca
l/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae -O -DVERSION=\"
1.04.PC1\" -DXS_VERSION=\"1.04.PC1\"
+z -I/usr/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/CORE -DESQLC_VERSION=953
-DNDEBUG esqlcver.ec
rm -f esqlcver.c
INFORMIXC="/usr/local/bin/perl esqlcc" ESQLCC="cc +z"
esql -c -shared -I/usr/local/opt/informixclientsdk-2.81.HC1/incl/esql -I/us
r/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/auto/DBI -I/usr/local/opt/perl-5
.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI -I/auto/DBI -I/usr/local/opt/pe
rl-5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI -D_HPUX_SOURCE -I/usr/loca
l/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae -O -DVERSION=\"
1.04.PC1\" -DXS_VERSION=\"1.04.PC1\"
+z -I/usr/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/CORE -DESQLC_VERSION=953
-DNDEBUG esqlc_v6.ec
rm -f esqlc_v6.c
Running Mkbootstrap for DBD::Informix ()
chmod 644 Informix.bs
rm -f blib/arch/auto/DBD/Informix/Informix.sl
LD_RUN_PATH="" ld -b +vnocompatwarnings -L/usr/local/lib 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/local/opt/informixclientsdk-2.81.HC1/lib -L/usr/local/opt/
informixclientsdk-2.81.HC1/lib/esql -lifsql -lifasf -lifgen -lifos -lifgls -
lnsl_s -lm -lsec -lnsl_s
/usr/local/opt/informixclientsdk-2.81.HC1/lib/esql/checkapi.o -lifglx -o
blib/arch/auto/DBD/Informix/Informix.sl
chmod 755 blib/arch/auto/DBD/Informix/Informix.sl
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 -I/usr/local/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0 -I/usr/
local/opt/perl-5.6.1/lib/5.6.1 -MExtUtils::MakeMaker -e "MY->fixin(shift)"
blib/script/InformixTechSupport
Manifying blib/man3/DBD::Informix::TechSupport.3
Manifying blib/man3/DBD::Informix::TestHarness.3
Manifying blib/man3/DBD::Informix::Summary.3
Manifying blib/man3/DBD::Informix::Defaults.3
Manifying blib/man1/InformixTechSupport.1
Manifying blib/man3/Bundle::DBD::Informix.3
Manifying blib/man3/DBD::Informix.3
****************************************************************************
**********************
For D class failures:
FAILURE 1, mentioned at start of email:
WITH THE 19-char table identifier:
server14$ ./test.one.sh t/t35cursor.t
# DBI->connect('dbi:Informix:webmail', 'jcramer', '');
1..17
ok 1
# Test: do('
# CREATE TEMP TABLE dbd_ix_cursor_state
# (
# Col01 SERIAL(1000) NOT NULL,
# Col02 CHAR(20) NOT NULL,
# Col03 INTEGER NOT NULL,
# Col04 DATETIME YEAR TO FRACTION(5) NOT NULL,
# Col05 DECIMAL NOT NULL
# )
# '):
not ok 2
# Error Message:
# <<no error string>>
# SQLSTATE =
!! Terminating Test !!
server14$
AFTER SHORTENING THE IDENTIFIER:
server14$ ./test.one.sh t/t2
# DBI->connect('dbi:Informix:webmail', 'jcramer', '');
1..17
ok 1
# Test: do('
# CREATE TABLE dbd_ix_cursor_stat
# (
# Col01 SERIAL(1000) NOT NULL,
# Col02 CHAR(20) NOT NULL,
# Col03 INTEGER NOT NULL,
# Col04 DATETIME YEAR TO FRACTION(5) NOT NULL,
# Col05 DECIMAL NOT NULL
# )
# '):
ok 2
ok 3
ok 4
# SELECT * FROM dbd_ix_cursor_stat ORDER BY Col01
# 1000 :: Another value :: 987654321 :: 2002-02-28 00:11:22.55555 ::
2.718281828459045E+00
# 1001 :: Different data :: 88888888 :: 1900-01-01 00:00:00.00000 ::
0.000000000000000E+00
# 1002 :: Some other data :: 88888888 :: 1900-01-01 00:00:00.00000 ::
3.141593000000000E+00
# 1003 :: Some other data :: 123456789 :: 2000-02-29 23:59:59.99999 ::
3.141593000000000E+00
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
# *** Testing of DBD::Informix complete ***
# *** You appear to be normal! ***
server14$
MY FAILURE 2:
server14$ ./test.one.sh t/t20error.t
# DBI->connect('dbi:Informix:webmail', 'jcramer', '');
1..5
ok 1
# Test: do('
# CREATE TEMP TABLE dbd_ix_err01
# (
# Col01 SERIAL NOT NULL PRIMARY KEY,
# Col02 CHAR(20) NOT NULL
# )
# '):
ok 2
# Test: do(' CREATE UNIQUE INDEX pk_dbd_ix_err01 ON dbd_ix_err01(Col02) '):
ok 3
not ok 4
# Error Message:
# <<no error string>>
# SQLSTATE =
!! Terminating Test !!
NOTE: I have run this script in the perl -d debugger and the problem is with
the
statement:
$SIG{__WARN__} = sub { $msg = $_[0]; };
$msg is not getting set.
If I create the table without the TEMP keyword, and single step through what
the
test is doing, I can see that everything up to this statement gets done
right:
- the table gets created
- the unique index on col2 gets created
- the first execute inserts the row into the table
- the 2nd execute of the same prepared stmt fails with error codes -239
and -100.
However, the check that it failed properly:
&stmt_fail() unless ($msg && $msg =~ /-100:/ && $msg =~ /-239:/);
fails because $msg is undefined.
If I comment out this check, the test runs to completion OK:
server14$ ./test.one.sh t/t
# DBI->connect('dbi:Informix:webmail', 'jcramer', '');
1..5
ok 1
# Test: do('
# CREATE TABLE dbd_ix_err01
# (
# Col01 SERIAL NOT NULL PRIMARY KEY,
# Col02 CHAR(20) NOT NULL
# )
# '):
ok 2
# Test: do(' CREATE UNIQUE INDEX pk_dbd_ix_err01 ON dbd_ix_err01(Col02) '):
ok 3
# SQL = -239; ISAM = -100
# DBI::state:
Use of uninitialized value in concatenation (.) or string at t/t line 55.
# DBI::err:
Use of uninitialized value in concatenation (.) or string at t/t line 56.
# DBI::errstr:
ok 4
# SELECT * FROM dbd_ix_err01
# 1 :: Gee Whizz!
ok 5
# *** Testing of DBD::Informix complete ***
# *** You appear to be normal! ***
THAT IS IT. THANKS AGAIN FOR THE HELP.
