|Subject||Re: [ib-support] Firebird RC1|
> From: Claudio Valderrama C.....
> Unfortunately, as Jason knows well, if I insert into V, IB (not FB) says inFirst I thought I do understand this, but now if I tried it I realized I do not.
> this case that you inserted three records. If you delete from V, IB will say
> that you deleted three records and on update, you will appear as updating
> three records. Now, do the same on W as above and you might get higher
> values. The reason is that IB has flawed logic, counting every loop over ...
I created Table, Updatable-view, Non-updatable-view-made-updatable-by-triggers.
If I insert one row into any of these objects (by INSERT INTO t VALUES(...)),
I get "one row inserted" answer (isc_info_sql_records, isc_info_req_insert_count, ... etc.).
If I insert 5 rows (by INSERT INTO t SELECT * FROM t2),
I get "five rows inserted, five rows selected" answer.
I tried it with IB5.1 and IB188.8.131.527.
So, under which circumstances do I get "three records inserted" ?