Make ISQL do not count records that in fact are not deleted from
mon$attachments due to mon$system_flag=1 (Cache Writer & Garbage Collector)
--------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-4958
URL: http://tracker.firebirdsql.org/browse/CORE-4958
Project: Firebird Core
Issue Type: Improvement
Components: ISQL
Reporter: Pavel Zotov
Priority: Trivial
Sample (SuperServer, single attachment from SYSDBA):
===
SQL> set list on;
SQL> select mon$attachment_id, mon$user, mon$remote_protocol,
mon$remote_process, mon$system_flag from mon$attachments where
mon$attachment_id <> current_connection;
MON$ATTACHMENT_ID 132
MON$USER Cache Writer
MON$REMOTE_PROTOCOL <null>
MON$REMOTE_PROCESS <null>
MON$SYSTEM_FLAG 1
MON$ATTACHMENT_ID 133
MON$USER Garbage Collector
MON$REMOTE_PROTOCOL <null>
MON$REMOTE_PROCESS <null>
MON$SYSTEM_FLAG 1
SQL> set count on;
SQL> delete from mon$attachments where mon$attachment_id <> current_connection;
Records affected: 2 -------------------------------------------------- [ 1 ]
SQL> commit;
SQL> select mon$attachment_id, mon$user, mon$remote_protocol,
mon$remote_process, mon$system_flag from mon$attachments where
mon$attachment_id <> current_connection;
MON$ATTACHMENT_ID 132
MON$USER Cache Writer
MON$REMOTE_PROTOCOL <null>
MON$REMOTE_PROCESS <null>
MON$SYSTEM_FLAG 1
MON$ATTACHMENT_ID 133
MON$USER Garbage Collector
MON$REMOTE_PROTOCOL <null>
MON$REMOTE_PROCESS <null>
MON$SYSTEM_FLAG 1
Records affected: 2
===
What does ISQL mean in line marked "[1]" ? In fact, NO rows has been deleted
from mon$attachments because they have system_flag = 1.
It will be nice if ISQL do not count them and show correct number in 'Records
affected'.
--
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
