ISQL doesn`t show number of affected rows for "MERGE ... WHEN MATCHING" in case
when this number surely > 0
-----------------------------------------------------------------------------------------------------------
Key: CORE-4817
URL: http://tracker.firebirdsql.org/browse/CORE-4817
Project: Firebird Core
Issue Type: Bug
Components: ISQL
Affects Versions: 3.0 Beta 2, 2.5.5
Reporter: Pavel Zotov
Tested on WI-T3.0.0.31844, result in WI-V2.5.5.26871 is similar (just change
row_number() to create sequence + gen_id).
SQL> recreate table s(id int, x int);
SQL> commit;
SQL> insert into s(id, x) select row_number()over(), 2 * row_number()over()
from rdb$types rows 5;
SQL> commit;
SQL> select * from s;
ID X
============ ============
1 2
2 4
3 6
4 8
5 10
SQL> recreate table t(id int primary key, x int);
SQL> commit;
SQL> set count on;
SQL> merge into t using s on s.id = t.id when not matched then insert
values(s.id, s.x);
Records affected: 5
SQL> select * from t;
ID X
============ ============
1 2
2 4
3 6
4 8
5 10
Records affected: 5
SQL> merge into t using s on s.id = t.id when matched then update set t.x = - 3
* s.x;
Records affected: 0 -- <<<<<<<<<<<<<<< ??? <<<<<<<<<<<<
-- Verify that last merge really changed target table:
SQL> select * from t;
ID X
============ ============
1 -6
2 -12
3 -18
4 -24
5 -30
Records affected: 5
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
