[TRAFODION-2578] Internal error 2235 with UDFs and subquery unnesting

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.3-incubating
• Component/s: sql-cmp
• Assignee: Hans Zeller
• Reporter: Hans Zeller
• Created: 05/Apr/17 17:40
• Updated: 10/Oct/17 15:12

Description

I've seen this error when compiling query plans with TMUDFs:

• • • ERROR[2235] Compiler Internal Error: An unknown error, originated from file ../optimizer/RelRoutine.cpp at line 465.

The issue is in method RelExpr::getMoreOutputsIfPossible(), which is used during semantic query optimization to get additional key columns from RelExprs. This calls TableMappingUDF::getPotentialOutputValuesAsVEGs(), which is stubbed out with an assert.

We either need to make RelExpr::getMoreOutputsIfPossible() virtual and override it for TableMappingUDF, or implement TableMappingUDF::getPotentialOutputValuesAsVEGs(). Right now I'm leaning towards the former.