Re: Null values in result record are overwritten withprevious non-null data when using a prepared query more than once
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
2009/6/18 Buurman, H.A. (Herbert) <[email protected]> > > > -----Original Message----- > > From: [email protected] > > [mailto:[email protected]]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 > Frediano _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds