Re: DBD::Informix test failure for lvarchar

In reply to a recent inquiry about my post...

I have not resolved the issue. There is no resolution yet from the
Guardian of DBD::Informix.


Here is what I have learned on my own... (in all cases, this is using
Informix IDS 10.00 on a remote host, and the client is on Solaris 8,
DBI is 1.47)


DBD-Informix-2007.0226 + CSDK-2.70.UC3 --> 91udts fails

so I updated my CSDK:
DBD-Informix-2007.0226 + CSDK-2.90.UC4 --> 93lvarchar fails (these
are the latest clients, and so I made my bug report based on these)

so I went retro on the Perl client:
DBD-Informix-2007.0225 + CSDK-2.90.UC4 --> 93lvarchar fails

so I went double-retro on the Perl client:
DBD-Informix-2005.02 + CSDK-2.90.UC4 --> complete success

But, it looks like the only reason that 2005.02 did *not* fail is
because it does *not* perform the same tests on "LVARCHAR NOT NULL"
that the 2007.0225 and .0226 clients perform.

For now, I am using 2007.0226 (as in my bug report). Since we
currently have no LVARCHAR columns in our data base, and we have no
intention in the near term of using such, we have decided just to use
this latest version. I asked the CPAN shell to do a force install.

I hope this information proves useful.
--
Mark Abajian




On Jun 1, 2007, at 2:38 AM, a colleague wrote:
> Hi Mark,
>
>
> I saw your recent question on the above, after a web search that I
> made
>
> with the aim of resolving the same problem which I am also having!
>
>
> If you were able to settle it, or work round it without too much fuss,
>
> I'd be very interested in the details.
>
>
> If not, I'm afraid I have little to offer you for now, because
> obviously
>
> I am in the same boat. But if you like I'll gladly share any
> information
>
> I can unearth, not that I've had much luck so far.
>
>
> Anyway, I look forward to hearing from you if you get a chance to
> reply.
>
> Cheers


On May 14, 2007, at 10:18 PM, Mark Abajian wrote:

> [This is my second attempt to post. First was refused for overly-
> long attachment.]
>
>
> Hello.
>
> I hope I have enough information here for someone to assist with a
> DBD::Informix problem.
>
>
> I am installing DBD::Informix on a Solaris 8 host. We have a 32-
> bit Perl 5.8.6, compiled with gcc 3.4.3. The Informix Client SDK
> is 2.90UC4 (32-bit SPARC).
>
> The Informix server, on a Solaris 9 host, is IDS 10.00.FC4 (64-bit
> SPARC).
>
> I ran into a problem with test t/t93lvarchar.t. It appears that
> the script is failing to retrieve values for columns of type
> "lvarchar not null". Otherwise, the build and tests seem just fine.
>
>
> What is the status of this anomaly? (I saw similar postings dating
> from 2002-2005.)
> Is this anything to be concerned about if I have no columns of type
> "lvarchar not null"?
> Any recommendations?
>
> A bug report for "D t/t93lvarchar.t" is attached.
>
> Thank you for your assistance.
> --
> Mark Abajian
>
>
>