Re: DBI/DBD test fail
On Wed, 1 Nov 2000, Maria Wilson wrote: >Jonathan, > I'm hoping you can help with this DBI::DBD installation problem. >I'm really new with this module so be nice! When I run the make test - >I'm getting the following errors.... >btw - I'm on Solaris 7, Perl 5.004 DBD 1.0 DBI 1.14 Serioiusly consider upgrading to Perl 5.005_03; however, that is not the cause of your trouble. >t/t90ius............Null pointer for lvarchar at >/usr/local/lib/perl5/site_perl/DBI.pm line 1105. >ok As you see, the test passed, despite the warning. There is a patch for that which has been posted previously. See the email below. >t/t91udts...........DBD::Informix::db do failed: SQL: -9810: >Smart-large-object error. >ISAM: -12053: Smart Large Objects: No sbspace number specified. at >blib/lib/DBD/Informix/TestHarness.pm line 218. >!! Terminating Test !! >dubious > Test returned status 255 (wstat 65280, 0xff00) >DIED. FAILED tests 7-16 > Failed 10/16 tests, 37.50% okay This amounts to a bug in the test case. It assumes there will be a smart blob space available, and you don't have one. You can ignore this failure too. Basically, you're OK to go and install. >t/t99clean..........ok >Failed Test Status Wstat Total Fail Failed List of failed > >---------------------------------------------------------------- > >can you help? > >thanks! maria > >---------------------------------------------------------------- >Maria L. Wilson 757.766.8265 m.l.wilson@larc.nasa.gov >Computer Sciences Corporation - Database Administration >NASA Langley Research Center Hampton, VA 23666 >---------------------------------------------------------------- ======================================================================== Date: Mon, 13 Mar 2000 05:06:06 -0800 From: Jonathan Leffler <jleffler@earthlink.net> To: Franky Wong <fwong@seattletimes.com> Cc: Jonathan Leffler <jonathan.leffler@informix.com>, Michael Kopchenov <myk@informix.com> Subject: Re: :Informix 0..97005 lvarchar bug Franky Wong wrote: > The same bugs exist for DBD-Informix-0.97005, and could be corrected by: > > line 1911: > > /* edited by fwong, 4/30/1999 > warn("Null pointer for lvarchar"); > */ > result = ""; > > line 1928: > > /* edited by fwong, 4/30/1999 > assert(length >= 2 && result[length] == '\\0' && result[length-1] == '\\0'); > */ > if (length >= 2 && result[length-1] == '\\0' && result[length-2] == '\\0') > length -= 2; > > FYI my database server is Informix 9.20UC1 and I am building > DBD-Informix-0.97005 on Solaris 2.6 with Client SDK 2.40 UC1-1 (ESQL/C > 9.30.UC1). > > -----Original Message----- > From: Franky Wong [mailto:fwong@seattletimes.com] > Sent: Friday, April 30, 1999 2:18 PM > To: jleffler@earthlink.net > Subject: DBD::Informix 0.61_02 lvarchar bug > > Hi Jonathan, > > In addition to my last email, in line 1629 of dbdimp.ec, where you substract > 2 from the length of a lvarchar string. I found that is OK in machines with > client SDK V2.20.UC1-1 (ESQL/C 9.20.UC1). > > However, in my server machine running IUS 9.14 UC4 (ESQL/C 9.14.UC1), the > behavior is incorrect. There are no double \\0 characters at the end. > > Therefore, perhaps you should change the assert() macro in line 1628 to an > if statement. > > Hope this helps. Regards. > > -----Original Message----- > From: Franky Wong [mailto:fwong@seattletimes.com] > Sent: Wednesday, April 28, 1999 11:03 AM > To: JonathanLeffler > Subject: RE: DBD::Informix lvarchar and unload > > I tried out DBD::Informix 0.61_02 in IUS 9.14UC4. The lvarchar support is > very useful. > > FYI, line 1611 of dbdimp.ec will spit out "Null pointer for lvarchar" to > STDERR when retrieving an empty lvarchar string. And also the resulting > variable from fetch() will be undefined (i.e. same as null). > > For example: select ''::lvarchar from sometable > > The correct behavior should be a defined empty string. > > Regards. Thanks, Franky. This fix won't be in the 1.00 release (that's finalized but not released). It should get into the next one, though. Along with any other work required to get LVARCHAR fully operational. I'm sorry if you reported this previously and it didn't get into the code. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN #include <disclaimer.h>