[
https://issues.apache.org/jira/browse/DERBY-4204?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12708019#action_12708019
]
Knut Anders Hatlen commented on DERBY-4204:
-------------------------------------------
Good idea, Bryan. I tested it in ij and saw that re-execution of a prepared
insert statement resulted in only one row in SYSXPLAIN_STATEMENTS, whereas
re-execution of a prepared select statement resulted in one row per execution,
so it should be possible to test this bug with the XPLAIN tables too.
> Runtime statistics not collected on re-execution of statement
> -------------------------------------------------------------
>
> Key: DERBY-4204
> URL: https://issues.apache.org/jira/browse/DERBY-4204
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.3.1.4
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Priority: Minor
> Attachments: repro.sql, test.diff
>
>
> Runtime statistics are only collected the first time an insert/update/delete
> statement is executed. The behaviour changed between Derby 10.2.2.0 and Derby
> 10.3.1.4, so this was likely introduced by DERBY-827.
> Reported on derby-dev:
> http://mail-archives.apache.org/mod_mbox/db-derby-dev/200904.mbox/%[email protected]%3e
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
