[
https://issues.apache.org/jira/browse/TRAFODION-2605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15995837#comment-15995837
]
David Wayne Birdsall commented on TRAFODION-2605:
-------------------------------------------------
The fix for JIRA TRAFODION-2294 closed a security hole in Explain processing.
It did so by not caching the query plan of the query text specified on the
EXPLAIN statement.
One flaw in that fix is that the act of caching a query plan may actually
change the plan! This is because caching replaces constants with parameters,
which alters selectivity. This shows up in regression test executor/TEST140,
where input values no longer appear in the explain plan text.
A better fix would treat the query plan as if it were going to be cached, but
then not cache it. That fix will be done under this JIRA.
> Rework fix to JIRA Trafodion 2294
> ---------------------------------
>
> Key: TRAFODION-2605
> URL: https://issues.apache.org/jira/browse/TRAFODION-2605
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.2-incubating
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
