You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Statement 121:
-------------------------------------------------------------------------------
insert into mon_log(att_id) select mon$attachment_id from mon$attachments where mon$attachment_id=current_connection
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MON$ATTACHMENTS NATURAL)
0 records fetched
0 ms, 11 fetch(es), 4 mark(s)
summary: Regression in 3.0: trace reports UPDATES in statistics when doing INSERT into <some_table> select . . . from MON$xxx => Regression in 3.0: trace reports UPDATES in statistics when doing INSERT into <some_table>
Submitted by: @pavel-zotov
Attachments:
trace-screen-in-FB_3.0-when-INSERT-into-T-select-from-MON$.zip
SQL> recreate table mon_log(att_id int); commit;
SQL> insert into mon_log(att_id) select mon$attachment_id from mon$attachments where mon$attachment_id=current_connection;
Trace in LI-V2.5.3.26788:
Table Natural Index Update Insert
************************************************************************
MON_LOG 1
(one INSERT, and, of course, this is OK).
Trace in LI-T3.0.0.31280:
2014-08-11T16:02:14.8900 (30759:0x7f3a50761c18) EXECUTE_STATEMENT_FINISH
oltp30b (ATT_21, SYSDBA:NONE, NONE, TCPv4:192.168.43.96)
C:\MIX\firebird\fb25\bin\isql.exe:3856
(TRA_142, CONCURRENCY | WAIT | READ_WRITE)
Statement 121:
-------------------------------------------------------------------------------
insert into mon_log(att_id) select mon$attachment_id from mon$attachments where mon$attachment_id=current_connection
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MON$ATTACHMENTS NATURAL)
0 records fetched
0 ms, 11 fetch(es), 4 mark(s)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
MON_LOG 1
Why it reports one UPDATE in statistics ?
The text was updated successfully, but these errors were encountered: