Skip to Content.
Sympa Menu

freetds - Re: [freetds] "Fix affected rows after insert with prepared query" side effect

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: John Kendall <john AT capps.com>
  • To: FreeTDS Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] "Fix affected rows after insert with prepared query" side effect
  • Date: Fri, 22 Apr 2016 00:03:04 +0000

Thu, 21 Apr 2016 11:04:54 +0100 Frediano Ziglio <freddy77 AT gmail.com>

> 2016-04-21 8:00 GMT+01:00 John Kendall <john AT capps.com>:
>> On Oct 19, 2015 this patch was applied to ct.c:
>>
>> "Fix affected rows after insert with prepared query"
>>
>> This patch has the side-effect of a 'rows affected' being displayed for
>> every select statement within a ASE stored procedure. For example,
>> sp_help returns 136 extra 'rows affected' lines. See below. Backing out
>> this patch stops this from happening. I only tested this on sp_help, but
>> I figured that was enough. FYI, this patch does not have this effect on
>> MS SQL 2008's sp_help sproc.
>>
>> John
>>
>
> I'm not sure if this is a regression or an improvement. I have to
> check what's the original CT-Library behaviour.
>
> Frediano

Hi, Frediano.

I compiled sqsh against Sybase 16 libs and it does not return all those 'rows
affected' lines.
I could be reading it wrong, but in the archives, it appears the patch
applied was not the one requested by Dave Nichols.

https://lists.ibiblio.org/sympa/arc/freetds/2015q4/029631.html

Could we remove that patch?

Thanks,
John



>>
>> sqsh> sp_help Movetype
>> (1 row affected)
>> Name Owner Object_type
>> -------------------------------- --------------------
>> ----------------------------------------
>> Movetype dbo user table
>>
>> Column_name Type Length
>> Pre
>> ------------------------------------------------ ----------------
>> ------------------------ ---
>> movetype char 2
>> NUL
>> move_desc char 20
>> NUL
>> move_revenue bit 1
>> NUL
>>
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (0 rows affected)
>> (1 row affected)
>> (0 rows affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> Object has the following indexes
>>
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (0 rows affected)
>> (8 rows affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (1 row affected)
>> (0 rows affected)
>> ... etc
>> <snip>
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS AT lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>





Archive powered by MHonArc 2.6.24.

Top of Page