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
