Issue Details (XML | Word | Printable)

Key: CORE-4515
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Pavel Zotov
Votes: 0
Watchers: 1

If you were logged in you would be able to see more operations.
Firebird Core

Regression in 3.0: trace reports UPDATES in statistics when doing INSERT into <some_table>

Created: 11/Aug/14 12:12 PM   Updated: 23/Sep/15 11:28 AM
Component/s: Engine
Affects Version/s: 3.0 Alpha 2
Fix Version/s: 3.0 Beta 1

File Attachments: 1. Zip Archive trace-screen-in-FB_3.0-when-INSERT-into-T-select-from-MON$.zip (20 kB)

QA Status: Cannot be tested

 Description  « Hide
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

(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:
                (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
0 records fetched
      0 ms, 11 fetch(es), 4 mark(s)

Table Natural Index Update Insert Delete Backout Purge Expunge

Why it reports one UPDATE in statistics ?

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pavel Zotov added a comment - 11/Aug/14 12:16 PM
PS. Unfortunatelly, I could not show statistics in proper format like FIXED. Please see screenshot in attach.