[jira] [Comment Edited] (CALCITE-3748) Exception while executing table function

["ssss (Jira)" <ji...@apache.org>]

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

ssss edited comment on CALCITE-3748 at 1/20/20 11:35 AM:
---------------------------------------------------------

It is already in the TableFunctionTest.java.

  @Test public void testUserDefinedTableFunction() {
    final String q = "select *\n"
        + "from table(\"s\".\"multiplication\"(2, 3, 100))\n";
    with().query(q)
        .returnsUnordered(
            "row_name=row 0; c1=101; c2=102",
            "row_name=row 1; c1=102; c2=104",
            "row_name=row 2; c1=103; c2=106");
  }


was (Author: swathi858):
It is already in the TableFunctionTest.java.

> Exception while executing table function
> ----------------------------------------
>
>                 Key: CALCITE-3748
>                 URL: https://issues.apache.org/jira/browse/CALCITE-3748
>             Project: Calcite
>          Issue Type: New Feature
>          Components: core
>    Affects Versions: 1.21.0
>         Environment: we are using windows7 os and we are using command prompt and running this queries through sqlline
>            Reporter: ssss
>            Priority: Major
>              Labels: beginner
>             Fix For: 1.21.0
>
>         Attachments: WhatsApp Image 2020-01-20 at 11.11.47 AM.jpeg
>
>
> I have referred the table function test and i have run the query
> select * from table(s.multiplication(5,6,5)); 
> But i am getting the exception as "no match found for function signature multiplication ((numeric),(numeric),(numeric))".Is there any different calcite connection to run this query.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)