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: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] "Fix affected rows after insert with prepared query" side effect
  • Date: Thu, 21 Apr 2016 11:04:54 +0100

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

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