[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