Subject Re: [firebird-support] Can merge return AffecterRows?
Author 渡辺

Thank you ,Thomas!

The count is right.I feel easy.

I didn't think there was other ticket.

I hope Reference will be changed.


On 2016/09/28 22:16, 'Thomas Steinmaurer' ts@... [firebird-support] wrote:

> hi,I am Nobuo Watanabe.
> I use FireBird 2.5.6 and FireBird2.5.3.
> Firebird2.5Language Reference about 'merge command' says:
> Currently, the ROW_COUNT variable returns the value 1, even if more than one
> record is modified or inserted. For details and progress, refer to Tracker
> ticket CORE-4400 <>.
> I use ISQL,and set count on;
> When I use 'merge' on ISQL2.5.3,then return 1 always.
> but when I use 'merge' on ISQL2.5.6,then affected row count return.
> Is this right count?or is there any condition to get right row_count?

Sounds a bit like fixed in 2.5.6 and 3.0

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

 株式会社 ノベルット ソフトウェア インダストリー
  代表取締役 渡辺 伸雄
 〒144-0043 東京都 大田区 羽田2-12-3
 mobile-phone:080-3430-2595 070-5582-6540