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/
