[
https://issues.apache.org/jira/browse/TRAFODION-2147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hans Zeller resolved TRAFODION-2147.
------------------------------------
Resolution: Fixed
Fix Version/s: (was: 2.0-incubating)
2.1-incubating
Fix committed on 8/31/2016.
> 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: Hans Zeller
> Fix For: 2.1-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)