[TRAFODION-2966] New MDAM costing code does not always respect CQS forcing MDAM

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.3
• Fix Version/s: 2.3
• Component/s: sql-cmp
• Assignee: Dave Birdsall
• Reporter: Dave Birdsall
• Created: 21/Feb/18 18:16
• Updated: 13/Aug/18 22:27
• Resolved: 28/Feb/18 16:54

Description

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.

Issue Links

• links to: GitHub Pull Request #1456