Re: [firebird-support] Can merge return AffecterRows?

 

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@iblogmanager.com [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@noveltte.jp  ///////////////////////////////////////////////ﾉﾍﾞﾙｯﾄ/////  

__._,_.___

---

Posted by: =?UTF-8?B?5rih6L66?= <watanove@noveltte.jp>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 5

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___