Dear Arlene,
I've confirmed to my own satisfaction that the problem occurs when DBDATE
is set to a non-default value such as "Y4MD-" when the server is booted,
and no value is set for DBDATE in the client environment. This is a
legitimate setup (though not one I particularly recommend), so I need to
fix my test code so that it works OK even in this scenario.
Your build of DBD::Informix is OK - install and use it.
--
Jonathan Leffler ([EMAIL PROTECTED])
STSM, Informix Database Engineering, IBM Data Management Solutions
4100 Bohannon Drive, Menlo Park, CA 94025
Tel: +1 650-926-6921 Tie-Line: 630-6921
"I don't suffer from insanity; I enjoy every minute of it!"
|---------+---------------------------->
| | Jonathan Leffler |
| | <jleffler@earthli|
| | nk.net> |
| | |
| | 11/04/2002 09:03 |
| | PM |
| | |
|---------+---------------------------->
>---------------------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: "Gelbolingo, Arlene - MLG" <[EMAIL PROTECTED]>
|
| cc: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, Jonathan
Leffler/Menlo Park/IBM@IBMUS |
| Subject: Re: DBD::Informix Install Problem on HP-UX 11.00 & INFORMIX-ESQL
Version 9.51.HC3 |
|
|
|
|
>---------------------------------------------------------------------------------------------------------------------------------------------|
Gelbolingo, Arlene - MLG wrote:
> I ran into some problems while installing DBI on our new system. At
first
> it was a class A failure but after I changed esql's COPTS variable to "",
I
> was able to create a Makefile and run "make" and "make test". Some tests
> failed though during the "make test" run. I followed the steps on
creating
> a bug report, please see attached file.
>
> <<bugreport.zip>> Thanks,
>
> Arlene Gelbolingo
> System Administrator
> Menlo Worldwide
> (p) 503.450.8691
> (c) 503.860.5423
> (f) 503.450.8664
Dear Arlene,
Thanks for using the bugreport tool. I'm slightly surprised that you
chose to run t/t75blob.t (which is skipped) rather than t/t65updcur.t
(which failed); it makes it more difficult to diagnose the problem.
However, the vast majority of the code is working, and I'd be willing
to guess that the problem is actually a test error due to some
particular property of your environment rather than a major problem in
DBD::Informix. If the trouble had been in the main code, the failures
would have been much more spectacular.
t/t65updcur.........DBD::Informix::db do failed: SQL: -1218: String to
date conversion error at blib/lib/DBD/Informix/TestHarness.pm
line 219.
!! Terminating Test !!
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 3-13
Failed 11/13 tests, 15.38% okay
t/t72blob...........ok
t/t73blob...........ok
t/t74blob...........ok
t/t75blob...........skipped test on this platform
The error message implies that the code that tried to determine the
correct format for dates failed. Since your environment includes no
locale indicating variables (specifically, none of DBDATE,
CLIENT_LOCALE, SERVER_LOCALE, LANG, LC_ALL, LC_TIME). I'm a little
puzzled. I wonder - could your database server have been started by
someone with DBDATE set to a non-default value (not MDY4/)? That may
be tricky to determine unless you run a stored procedure which uses
the SYSTEM statement to record the environment in a temporary file:
CREATE PROCEDURE server_environment()
SYSTEM "env >/tmp/env.out";
END PROCEDURE;
EXECUTE PROCEDURE server_environment();
I have had similar errors reported once before, several years ago, and
I either never got to the bottom of the issue or have forgotten what
the resolution was. Maybe I need to be a bit more down to earth about
determining the correct date format, doing something like:
SELECT MDY(10, 20, 1930) FROM "informix".systables WHERE tabid = 1;
and analysing the string that is returned -- which is unambiguous.
Anyway, I would have very few qualms about installing DBD::Informix,
though I certainly don't like that you've run into the problem.
Please note the one FAQ on DBD::Informix at http://xmlproj.com/cgi/fom.cgi
--
Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED])
#include <disclaimer.h>
Guardian of DBD::Informix 1.00.PC2 -- http://dbi.perl.org/
