| Subject | Re: [firebird-support] Can merge return AffecterRows? |
|---|---|
| Author | 渡辺 |
| Post date | 2016-09-29T01:11:06Z |
Thank you ,Thomas!
The count is right.I feel easy.
I didn't think there was other ticket.
I hope Reference will be changed.
Sincerely.
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 <http://tracker.firebirdsql.org/browse/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 http://tracker.firebirdsql.org/browse/CORE-4817 fixed in 2.5.6 and 3.0
--
With regards,
Thomas Steinmaurer
http://www.upscene.com
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
-- /////ﾉﾍﾞﾙｯﾄ/////////////////////////////////////////////// 株式会社 ノベルット ソフトウェア インダストリー 代表取締役 渡辺 伸雄 〒144-0043 東京都 大田区 羽田２－１２－３ Tel:03-5705-2595 Fax:03-6423-9505 mobile-phone:080-3430-2595 070-5582-6540 Email:watanove@... ///////////////////////////////////////////////ﾉﾍﾞﾙｯﾄ/////