You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/08/30 22:26:20 UTC

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

    [ https://issues.apache.org/jira/browse/TRAFODION-2147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15450322#comment-15450322 ] 

ASF GitHub Bot commented on TRAFODION-2147:
-------------------------------------------

GitHub user zellerh opened a pull request:

    https://github.com/apache/incubator-trafodion/pull/681

    [TRAFODION-2147] showshape does not work for TMUDFs

    The JIRA talks about both showshape and CQS. The CQS part
    was fixed with TRAFODION-2190, this is the fix for showshape.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/zellerh/incubator-trafodion bug/fix

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-trafodion/pull/681.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #681
    
----
commit 53e87aca8931f4066bcd9643a867ad17f4ba9447
Author: Hans Zeller <hz...@apache.org>
Date:   2016-08-30T22:22:45Z

    [TRAFODION-2147] showshape does not work for TMUDFs
    
    The JIRA talks about both showshape and CQS. The CQS part
    was fixed with TRAFODION-2190, this is the fix for showshape.

----


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