Re: "Fix affected rows after insert with prepared query" side effect

Frediano Ziglio <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAHt6W4cHiKkQecH7_fjFCGDOhyFYrkGAa27xP8=-SCukCQCZVw@mail.gmail.com>
2016-05-10 22:31 GMT+01:00 John Kendall <[email protected]>:
> It appears the patch for this ("fix ct-library rows count") has broken compute in ctlib:
>
>
>    select col=1 into #tbl insert #tbl values (2) select * from #tbl compute sum(col)
>    (1 row affected)
>    (1 row affected)
>     col
>     -----------
>               1
>               2
>               2
>
>    (3 rows affected)
>
> dblib (and ctlib RC1) does the expected:
>
>    select col=1 into #tbl insert #tbl values (2) select * from #tbl compute sum(col)
>    (1 row affected)
>    (1 row affected)
>     col
>     -----------
>               1
>               2
>     sum
>     ===========
>               3
>
>    (3 rows affected)
>
>
> Sorry to keep finding things!
>
> John
>
>

Can you put some more detailed examples? Which program did you use?

Frediano
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.