[freetds] Null values in result record are overwritten withprevious non-null data when using a prepared query more than once
freddy77 at gmail.com
Thu Jun 18 09:11:07 EDT 2009
2009/6/18 Buurman, H.A. (Herbert) <h.a.buurman at interlogica.nl>
> > -----Original Message-----
> > From: freetds-bounces at lists.ibiblio.org
> > [mailto:freetds-bounces at lists.ibiblio.org]On Behalf Of Frediano Ziglio
> > Sent: Wednesday, 17 June, 2009 17:06
> > To: FreeTDS Development Group
> > Subject: Re: [freetds] Null values in result record are overwritten
> > withprevious non-null data when using a prepared query more than once
> > Hi,
> > I tried to reproduce problem but without success... I
> > tested from 0.82 to
> > current development but I got always right results, my environment
> > I'll try with a x86_64 machine.
> Any luck with that?
No, my Ubuntu (8.10) have an old packaged DBD::ODBC that doesn't work
on x86_64 and I had no time for upgrade it.
> > You could try to enable ODBC logging adding these settings to
> > /etc/odbcinst.ini
> > [ODBC]
> > Trace = Yes
> > TraceFile = /tmp/sql.log
> > ForceTrace = No
> > Pooling = No
> Here we go (see attached sql.log), but unfortunately
> I lack the knowledge to interpret the results.
> (DSNnames have been obscured to protect the innocent).
> Hopefully you can do anything with it.
It seems ok, yesterday I found a problem in mine (related to old DBD::ODBC).
Could you try with a sequence growing and shrinking like
Value => 1, Identifier => 1,
Value => 23, Identifier => 2,
Value => 456, Identifier => 3,
Value => 78, Identifier => 4,
Value => 9, Identifier => 5,
> Kind regards,
> H. Buurman
More information about the FreeTDS