[jira] [Resolved] (TRAFODION-2147) showshape and CQS do not work for TMUDFs

["Hans Zeller (JIRA)" <ji...@apache.org>]

     [ 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)