Regression in 3.0: trace reports UPDATES in statistics when doing INSERT into <some_table> select . . . from MON$xxx --------------------------------------------------------------------------------------------------------------------
Key: CORE-4515 URL: http://tracker.firebirdsql.org/browse/CORE-4515 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Alpha 2 Reporter: Pavel Zotov 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 ? -- 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