Hi.
I am using FireBird2.5.3,and a dataBase is updated from 2.2, and the database
was updated from 1.5.
The database have about 150 tables and just one Foreign key.
The Foreign key is from "hachu"table to "parts"table.
This is a part of definition of the Tables.
(ISQL showed these informati
Thank you !!! Mark !!
Resolved!
One procedure referenced the Index;
The procedure uses "Plan Sort(Hachu Index(FKHACHUTOPARTS))"
in Select SQL.
I create other Index HachuP on Hachu(partsid).
And I alter the procedure ,not to use plan the FKHACHUTOPARTS
to use plan with new Index HachuP.
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
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' t...@iblogmanager.com
[firebird-support] wrote:
> hi,I am Nobuo Watanabe.
> I use FireBird 2.5.6 and FireBird2.5