[firebird-support] Can merge return AffecterRows?

[渡辺 [e-mail] [firebird-support]]

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?

sincerly.
--
////////////////////////////////////////////////////
　株匏䌚瀟　ノベルット　゜フトりェア　むンダストリヌ
　　代衚取締圹　枡蟺 䌞雄
　〒144-0043　東京郜 倧田区 矜田
　Tel:[phone]
　Fax:[phone]
　mobile-phone:[phone]
Email:***@noveltte.jp
////////////////////////////////////////////////////

['Thomas Steinmaurer' [e-mail] [firebird-support]]

Post by 渡辺 ***@noveltte.jp [firebird-support]
hi,I am Nobuo Watanabe.
I use FireBird 2.5.6 and FireBird2.5.3.
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.

[渡辺 [e-mail] [firebird-support]]

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.

Post by 'Thomas Steinmaurer' ***@iblogmanager.com [firebird-support]

Post by 渡辺 ***@noveltte.jp [firebird-support]
hi,I am Nobuo Watanabe.
I use FireBird 2.5.6 and FireBird2.5.3.
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:[phone]
　Fax:[phone]
　mobile-phone:[phone]
Email:***@noveltte.jp
////////////////////////////////////////////////////