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
Operations

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
************************************************************************
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 ?

 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.

Pavel Zotov made changes - 11/Aug/14 12:16 PM
Field Original Value New Value
Attachment trace-screen-in-FB_3.0-when-INSERT-into-T-select-from-MON$.zip [ 12570 ]
Dmitry Yemanov made changes - 11/Aug/14 01:59 PM
Assignee Dmitry Yemanov [ dimitr ]
Dmitry Yemanov made changes - 11/Aug/14 02:01 PM
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>
Component/s Engine [ 10000 ]
Dmitry Yemanov made changes - 11/Aug/14 02:02 PM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 3.0 Beta 1 [ 10332 ]
Resolution Fixed [ 1 ]
Pavel Zotov made changes - 02/Jun/15 05:30 AM
Status Resolved [ 5 ] Resolved [ 5 ]
QA Status Cannot be tested
Pavel Cisar made changes - 23/Sep/15 11:28 AM
Status Resolved [ 5 ] Closed [ 6 ]