[
https://issues.apache.org/jira/browse/TRAFODION-2966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16379489#comment-16379489
]
ASF GitHub Bot commented on TRAFODION-2966:
-------------------------------------------
GitHub user DaveBirdsall opened a pull request:
https://github.com/apache/trafodion/pull/1456
[TRAFODION-2966] Fix new MDAM costing code to respect CQS forces
The new MDAM costing code was not respecting CONTROL QUERY SHAPE directives
to force MDAM. This has been fixed.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/DaveBirdsall/trafodion Trafodion2966
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1456.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1456
----
commit 5711693cc353dd3bf6c7a26bd538a3298202b2f3
Author: Dave Birdsall <dbirdsall@...>
Date: 2018-02-27T23:37:17Z
[TRAFODION-2966] Fix new MDAM costing code to respect CQS forces
----
> New MDAM costing code does not always respect CQS forcing MDAM
> --------------------------------------------------------------
>
> Key: TRAFODION-2966
> URL: https://issues.apache.org/jira/browse/TRAFODION-2966
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.3
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
> Priority: Major
>
> I ran the full regression suite but with CQD MDAM_COSTING_REWRITE set to 'ON'
> in the system defaults table. The suite passed except for test
> seabase/TEST010. There, several queries switched from MDAM plans to single
> subset scans. They did so in spite of the presence of CONTROL QUERY SHAPE
> statements that force an MDAM plan. So there is a bug in the new costing code
> where it is not respecting these CQS statements.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
