[freetds] Null values in result record are overwritten withprevious non-null data when using a prepared query more than once

Buurman, H.A. (Herbert) h.a.buurman at interlogica.nl
Thu Jun 18 07:41:08 EDT 2009


> -----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?

> 
> 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.

Kind regards,
H. Buurman

<html>
<body>
<pre style="font-size: 7.5pt; font-family: Arial; color: black; font-style: italic; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; margin-bottom: .0001pt">&nbsp;<pre style="font-size: 7.5pt; font-family: Arial; color: black; font-style: italic; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; margin-bottom: .0001pt"><span lang="nl"><font color="#C0C0C0" style="font-size: 7pt" face="Arial"><i><b><u>Disclaimer</u>

Deze e-mail is verzonden door Interlogica B.V. De inhoud en eventuele bijlagen zijn vertrouwelijk en uitsluitend bestemd voor de
geadresseerde. Interlogica B.V. verzoekt bij onjuiste adressering direct contact met haar op te nemen (<a href="mailto:info at interlogica.nl">mailto:info at interlogica.nl</a>),
de naam van de afzender en de geadresseerde aan haar op te geven en vervolgens dit e-mailbericht uit uw systeem te verwijderen.
Interlogica B.V. is niet aansprakelijk voor het overbrengen van virussen en het is uw verantwoordelijkheid deze e-mail (en eventuele
bijlagen) te controleren. Interlogica B.V. (geregistreerd bij het Handelsregister nr. 08067177) is gevestigd te Ecofactorij 20,
NL-7325 WC Apeldoorn.

This is an e-mail from Interlogica B.V. Its contents and any attachments are confidential and intended solely for the use of the
individual to whom it is addressed. If received in error, please contact Interlogica B.V. (<a href="mailto:info at interlogica.nl">mailto:info at interlogica.nl</a>)
quoting the name of the sender and the addressee, then delete it from your system. Please note that Interlogica B.V. does not accept any
responsibility for viruses and it is your responsibility to scan the email and any attachments (if any). Interlogica B.V. 
(registered with the Chamber of Commerce no. 08067177) is resident at Ecofactorij 20, NL-7325 WC Apeldoorn, The Netherlands.
</b></i>
</font>
<p>&nbsp;</p>
</body>
</html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sql.log
Type: application/octet-stream
Size: 15021 bytes
Desc: sql.log
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20090618/ebe4d8c5/attachment.obj 


More information about the FreeTDS mailing list