Suresh Subbiah created TRAFODION-2147:
-----------------------------------------
Summary: showshape and CQS do not work for TMUDFs
Key: TRAFODION-2147
URL: https://issues.apache.org/jira/browse/TRAFODION-2147
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Affects Versions: 2.0-incubating
Reporter: Suresh Subbiah
Assignee: Suresh Subbiah
Fix For: 2.0-incubating
SHOWSHAPE statement on a query that has a TMUDF raises this error.
*** ERROR[2006] Internal error: assertion failure (Unknown error returned while
retrieving metadata) in file ../sqlcomp/CmpDescribe.cpp at line 1077.
SHOWSHAPE with scalar UDFs work fine.
To reproduce please use regress/udr/TEST001 to create a library and a TMUDF.
Then any statement like the one below will show the problem.
showshape select *
from UDF(fibonacci_java(1,10)) XO
order by 1;+>+>
*** ERROR[2006] Internal error: assertion failure (Unknown error returned while
retrieving metadata) in file ../sqlcomp/CmpDescribe.cpp at line 1077.
--- SQL operation failed with errors.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
