| From: | "CAMPBELL, BRIAN D (BRIAN)" <campbelb [...] lucent.com> |
| To: | "'Jonathan Leffler'" <jleffler [...] us.ibm.com>, dbd.informix [...] gmail.com, "'bug-DBD-Informix [...] rt.cpan.org'" <bug-DBD-Informix [...] rt.cpan.org> |
| Subject: | RE: ANNOUNCE: IBM Informix Database Driver for Perl DBI Version 2 005.02 (2005-07-29) released |
| Date: | Wed, 10 Aug 2005 13:01:56 -0500 |
Jonathan,
Please reply to confirm that you received this email and acknowledge it's content. Let me know if you need any other information.
Please consider this email in lieu of "ItWorks" and "BugReport". I'm not clear to me what these scripts do exactly, but as you can see, they do not work on my Windows platform (nor any Windows platform I suspect, given the symptom shown):
D:\build\DBD\DBD-Informix-2005.02>perl ItWorks
The getpwuid function is unimplemented at C:/Perl/site/lib/DBD/Informix/TechSupport.pm line 234.
D:\build\DBD\DBD-Informix-2005.02>perl BugReport
The getpwuid function is unimplemented at C:/Perl/site/lib/DBD/Informix/TechSupport.pm line 59.
"It Works"
==========
Monday, I successfully built and tested the Informix DBD 2005.02 on Windows, which I briefly mentioned in my post to dbi-users@perl.org then.
Platform:
- Windows 2000 [Version 5.00.2195] SP4
- ActiveState Perl v5.8.7 built for MSWin32-x86-multi-thread, Binary build 813 [148120]
- DBI: 1.48
- ESQL: IBM Informix CSDK Version 2.90, IBM Informix-ESQL Version 2.90.TC1
- Microsoft Visual C++ 6.0
- Connection to Informix DB server 9.21.FC4 on an Alpha box running Compaq Tru64 Unix.
However, I did get two test failures. Please look at the test results near the end of this email and give me your thoughts on those.
Does this format help? I saw it in the Working.Versions file.
<WORKING_VERSION VERSION="1.00">
<DBD_INFORMIX> 2005.02 </DBD_INFORMIX>
<DBI> 1.48 </DBI>
<INFORMIX_ESQLC> IBM Informix CSDK Version 2.90, IBM Informix-ESQL Version 2.90.TC1 </INFORMIX_ESQLC>
<INFORMIX_SERVER> 9.21.FC4 </INFORMIX_SERVER>
<PERL> ActiveState Perl v5.8.7 built for MSWin32-x86-multi-thread </PERL>
<SYSTEM> Windows 2000 [Version 5.00.2195] SP4 </SYSTEM>
<SYS_COMPILER> Microsoft Visual C++ 6.0 </SYS_COMPILER>
<SYS_LOADER> Microsoft Visual C++ 6.0 </SYS_LOADER>
<WHEN> 2005-08-08 </WHEN>
<WHO> Brian Campbell <campbelb@lucent.com> </WHO>
<Z_NOTES> Two tests failed: t\t08fork.t t\t91udts.t </Z_NOTES>
</WORKING_VERSION>
"BugReport"
===========
During the build process I encountered 9 problems that I believe are attributable to the Informix DBD release. It took me a couple of days to analyze and resolve these problems and complete the build. They include 3 source problems and 6 problems with Makefile.pl. One of the source problems was also present in 2003.04. Most and perhaps all are due to porting to Windows.
I plan to send you a report in a separate email that details these problems. I also intend to post the report to the DBI users mailing list, so any other Windows/Informix users can benefit from my efforts.
Note: I have also built the 2003.04 version successfully, which I reported to you early last year. However I do not find that listed in the Working.Versions document. Details of problems encountered in that build are provided at: http://www.mail-archive.com/dbi-users@perl.org/msg19771.html. Perhaps less than half of the points listed were attributable to the Informix DBD distribution.
Regarding my previous build, does this help?
<WORKING_VERSION VERSION="1.00">
<DBD_INFORMIX> 2003.04 </DBD_INFORMIX>
<DBI> 1.14 (??) </DBI>
<INFORMIX_ESQLC> IBM Informix CSDK Version 2.81, IBM Informix-ESQL Version 9.53.TC1 </INFORMIX_ESQLC>
<INFORMIX_SERVER> 9.21.FC4 </INFORMIX_SERVER>
<PERL> ActiveState Perl v5.8 built for MSWin32-x86-multi-thread </PERL>
<SYSTEM> Windows 2000 [Version 5.00.2195] SP3 </SYSTEM>
<SYS_COMPILER> Microsoft Visual C++ 6.0 </SYS_COMPILER>
<SYS_LOADER> Microsoft Visual C++ 6.0 </SYS_LOADER>
<WHEN> 2003-11-12 </WHEN>
<WHO> Brian Campbell <campbelb@lucent.com> </WHO>
<Z_NOTES> All tests passed </Z_NOTES>
</WORKING_VERSION>
Test Results
============
Env Vars used:
SET INFORMIXSERVER=production
SET DBI_DBNAME=brian
SET DBD_INFORMIX_DATABASE=brian
SET DBD_INFORMIX_USERNAME=campbelb
SET DBD_INFORMIX_PASSWORD=xxxxxxxx
SET DBD_INFORMIX_DEBUG_ESQLTEST=1
SET GL_DATE=%%Y-%%m-%%d
SET DBD_INFORMIX_NO_SBSPACE=1
Results of both test failures:
---------------------------------------------------------------------------------
1..2
# DBI->connect('dbi:Informix:brian', 'campbelb', 'XXXXXXXX');
# Connect Attribute: ChopBlanks => 1
# Connect Attribute: PrintError => 0
ok 1
Informix has no driver CLONE() function so is unsafe threaded
DBD::Informix::db prepare failed: handle 2 is owned by thread 15e6014 not curren
t thread 214b68c (handles can't be shared between threads and your driver may ne
ed a CLONE method added) at t\t08fork.t line 32.
not ok 2
# Error Message:
# <<no error string>>
# SQLSTATE =
!! Terminating Test !!
at D:\build\DBD\DBD-Informix-2005.02\blib\lib/DBD/Informix/TestHarness.pm line
305
DBD::Informix::TestHarness::stmt_fail() called at t\t08fork.t line 25
---------------------------------------------------------------------------------
# Driver Information
# Name: Informix
# Version: 2005.02
# Product: IBM Informix CSDK Version 2.90, IBM Informix-ESQL V
ersion 2.90.TC1
# Product Version: 290
# Connect to: brian
# IUS data types can be tested!
1..16
# drop table dbd_ix_udts
# Error Message:
# SQL: -9628: Type () not found.
# SQLSTATE = IX000
# drop type dbd_ix_distofi8 restrict
# Error Message:
# SQL: -9630: Cannot drop type (dbd_ix_distofi8): still in use.
# SQLSTATE = IX000
# drop type dbd_ix_distofbool restrict
# Error Message:
# SQL: -9630: Cannot drop type (dbd_ix_distofbool): still in use.
# SQLSTATE = IX000
# drop type dbd_ix_distoflvc restrict
# Error Message:
# SQL: -9630: Cannot drop type (dbd_ix_distoflvc): still in use.
# SQLSTATE = IX000
# drop type dbd_ix_distofnamed restrict
# Error Message:
# SQL: -9630: Cannot drop type (dbd_ix_distofnamed): still in use.
# SQLSTATE = IX000
# 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
# Test: do('create row type dbd_ix_udts_named (i int)'):
DBD::Informix::db do failed: SQL: -9991: Named row type (dbd_ix_udts_named) alre
ady exists in database. at D:\build\DBD\DBD-Informix-2005.02\blib\lib/DBD/Inform
ix/TestHarness.pm line 347.
not ok 1
# Test: do('create distinct type dbd_ix_distofi8 as int8'):
DBD::Informix::db do failed: SQL: -9996: Distinct type (campbelb.dbd_ix_distofi8
) already exists in database. at D:\build\DBD\DBD-Informix-2005.02\blib\lib/DBD/
Informix/TestHarness.pm line 347.
not ok 2
# Test: do('create distinct type dbd_ix_distofbool as boolean'):
DBD::Informix::db do failed: SQL: -9996: Distinct type (campbelb.dbd_ix_distofbo
ol) already exists in database. at D:\build\DBD\DBD-Informix-2005.02\blib\lib/DB
D/Informix/TestHarness.pm line 347.
not ok 3
# Test: do('create distinct type dbd_ix_distoflvc as lvarchar'):
DBD::Informix::db do failed: SQL: -9996: Distinct type (campbelb.dbd_ix_distoflv
c) already exists in database. at D:\build\DBD\DBD-Informix-2005.02\blib\lib/DBD
/Informix/TestHarness.pm line 347.
not ok 4
# Test: do('create distinct type dbd_ix_distofnamed as dbd_ix_udts_named'):
DBD::Informix::db do failed: SQL: -9996: Distinct type (campbelb.dbd_ix_distofna
med) already exists in database. at D:\build\DBD\DBD-Informix-2005.02\blib\lib/D
BD/Informix/TestHarness.pm line 347.
not 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)'):
DBD::Informix::db do failed: SQL: -310: Table (campbelb.dbd_ix_udts) already exi
sts in database. at D:\build\DBD\DBD-Informix-2005.02\blib\lib/DBD/Informix/Test
Harness.pm line 347.
not ok 6
# Test: do('
# insert into dbd_ix_udts values
# (1, 1, 't', '123456789012345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890123456789012345678901234567890
', row(1, '123456789012345678901234567890123456789012345678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890123456789
01234567890123456789012345678901234567890123456789012345678901234567890'), row(1
)::dbd_ix_udts_named,
# set{1, 10, 100}, list{row(1, 'one')}, multiset{row(1)::dbd_ix_udts_named
},
# '1', 't', '1234567890123456789012345678901234567890123456789012345678901
23456789012345678901234567890123456789012345678901234567890123456789012345678901
23456789012345678901234567890123456789012345678901234567890123456789012345678901
2345678901234567890123456789012345678901234567890123456789012345678901234567890'
, row(1)::dbd_ix_distofnamed )
# '):
DBD::Informix::db do failed: SQL: -9628: Type () not found. at D:\build\DBD\DBD-
Informix-2005.02\blib\lib/DBD/Informix/TestHarness.pm line 347.
not ok 7
# PREPARE: insert into dbd_ix_udts values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
? )
DBD::Informix::db prepare failed: SQL: -9628: Type () not found. at t\t91udts.t
line 94.
ok 8
Can't call method "execute" on an undefined value at t\t91udts.t line 105.
Show quoted text
-----Original Message-----
From: Jonathan Leffler [mailto:jleffler@us.ibm.com]
Sent: Friday, July 29, 2005 11:26 AM
To: dbi-announce@perl.org; dbi-dev@perl.org; dbi-users@perl.org;
informix-list@iiug.org
Cc: dbd.informix@gmail.com
Subject: ANNOUNCE: IBM Informix Database Driver for Perl DBI Version
2005.02 (2005-07-29) released
IBM Informix Database Driver for Perl DBI Version 2005.02 (2005-07-29) has
been uploaded to CPAN.
[snipped]
Support email address:
* This release is supported by Jonathan Leffler <dbd.informix@gmail.com>.
* You may also report your bugs via the CPAN resolution tracking system:
http://rt.cpan.org/
* Such bug reports can be sent by email to bug-DBD-Informix@rt.cpan.org;
they also get sent to dbd.informix@gmail.com, etc.
As always, see the ChangeLog file for details about what has changed.
Jonathan Leffler (jleffler@us.ibm.com, jleffler@earthlink.net)
@(#)$Id: Announce,v 2005.3 2005/07/29 00:19:34 jleffler Exp $
Message body not shown because it is not plain text.