[freetds] News about this bug?
Stefano Coletta
s.coletta at uni.it
Fri Jan 23 07:09:04 EST 2004
Hi Bill,
if you look back into the archives (not so far back) of this mailing
list you have a trace log of the problem and the comments from any
person who tried to give an interpretation of this behaviour. I have a
test bed of this and I can try to apply your patches if it needs. I've
even explain how to prepare a test bed without real servers.
Just search for my name as the sender.
And yes, Merge is the Multimaster replication of SQL Server.
Stefano Coletta
Unidata S.p.a.
Via Portuense, 1555 - 00050 Roma ( Ponte Galeria )
Tel +39 06650951
Fax +39 0665095002
E-mail s.coletta at uni.it
Thompson, Bill D (London) wrote:
>Thanks Freddy,
>
>I'll put this on my TODO.
>
>I've lost any memory I had of this issue/bug .
>
>Do we have a test case / program or a more detailed description of the issue
>?
>
>merge publication seems to be something to do with replication ?
>
>Bill
>
>
>
>
>
>>-----Original Message-----
>>From: ZIGLIO, Frediano, VF-IT [SMTP:Frediano.Ziglio at vodafone.com]
>>Sent: 23 January 2004 11:00
>>To: FreeTDS Development Group
>>Subject: RE: [freetds] News about this bug?
>>
>>
>>
>>>>Update/delete returns -1 instead of correct affected rows on Merge
>>>>Publication on MSSQL 2000 SP3a.
>>>>
>>>>Any news?
>>>>Thanks.
>>>>
>>>>
>>>>
>>>If you refer to ctlib problem with triggers nothing changed.
>>>We still do
>>>not know if this is a bug...
>>>
>>>ciao,
>>> freddy77
>>>
>>>
>>Well, from ct_res_info help:
>>
>>Retrieving the command number for the current result set
>>
>> * To determine the number of the command that generated the current
>>result set, call ct_res_info with result_typeas CS_CMD_NUMBER.
>>
>> * Client-Library keeps track of the command number by counting the
>>number of times ct_results returns CS_CMD_DONE.
>>
>>....
>>
>>Inside stored procedure or transactions, only select statements cause
>>the command number to be incremented. If a stored procedure or
>>transaction contains seven SQL commands, three of which are select
>>statements, the command number that ct_res_info returns can be any
>>integer from 1 to 3, depending on which select statement generated the
>>current result set.
>>
>>...
>>
>>If the command is one that executes a stored procedure or transaction,
>>for example a Transact-SQL exec language command or a remote procedure
>>call, ct_res_info returns either the number of rows returned by the
>>latest select statement executed by the stored procedure or transaction,
>>or CS_NO_COUNT if the stored procedure or transaction does not execute
>>any select statements. A stored procedure or transaction that does not
>>contain a select statement can execute a select by calling another
>>stored procedure or transaction that contains a select.
>>
>>
>>So it seem that even CTLib should ignore TDS_DONEIN_PROC is no columns
>>are present...
>>
>>freddy77
>>_______________________________________________
>>FreeTDS mailing list
>>FreeTDS at lists.ibiblio.org
>>http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>>
>
>_______________________________________________
>FreeTDS mailing list
>FreeTDS at lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>
>
More information about the FreeTDS
mailing list