[jira] [Updated] (IGNITE-29021) SQL Calcite: UDF with BigDecimal argument fails

[Kirill Tkalenko (Jira)]

     [ 
https://issues.apache.org/jira/browse/IGNITE-29021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Kirill Tkalenko updated IGNITE-29021:
-------------------------------------
    Description: 
{{UDF with a BigDecimal argument fails in the Calcite engine.}}
{code:java}
@QuerySqlFunction  
public static Duration numtodsinterval(BigDecimal value, String units) {        
    return Duration.ofDays(value.longValue());
}

SELECT numtodsinterval(5, 'day'); -- fails{code}

  was:
{{{}UDF with a BigDecimal argument fails in the Calcite engine.{}}}{{{}{}}}
{{}}
{code:java}
@QuerySqlFunction  
public static Duration numtodsinterval(BigDecimal value, String units) {        
return Duration.ofDays(value.longValue());
}

SELECT numtodsinterval(5, 'day'); -- fails{code}


> SQL Calcite: UDF with BigDecimal argument fails
> -----------------------------------------------
>
>                 Key: IGNITE-29021
>                 URL: https://issues.apache.org/jira/browse/IGNITE-29021
>             Project: Ignite
>          Issue Type: Bug
>            Reporter: Kirill Tkalenko
>            Assignee: Kirill Tkalenko
>            Priority: Major
>              Labels: ignite-2
>
> {{UDF with a BigDecimal argument fails in the Calcite engine.}}
> {code:java}
> @QuerySqlFunction  
> public static Duration numtodsinterval(BigDecimal value, String units) {      
>   
>     return Duration.ofDays(value.longValue());
> }
> SELECT numtodsinterval(5, 'day'); -- fails{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)