FreeTDS Development Group

[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

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