[jira] [Updated] (DRILL-8210) Add substring convertlet

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

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

James Turton updated DRILL-8210:
--------------------------------
    Fix Version/s: 2.0.0

> Add substring convertlet
> ------------------------
>
>                 Key: DRILL-8210
>                 URL: https://issues.apache.org/jira/browse/DRILL-8210
>             Project: Apache Drill
>          Issue Type: Sub-task
>    Affects Versions: 2.0.0
>            Reporter: Vova Vysotskyi
>            Assignee: Vova Vysotskyi
>            Priority: Major
>             Fix For: 2.0.0
>
>
> Newer Calcite requires adding convertlet for substring to prevent using ReflectiveConvertletTable, so queries that use substring will fail with 
> {noformat}
> Caused by: java.lang.IllegalArgumentException: argument type mismatch
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:498)
> 	at org.apache.calcite.sql2rel.ReflectiveConvertletTable.lambda$registerOpTypeMethod$3(ReflectiveConvertletTable.java:140)
> 	at org.apache.calcite.sql2rel.SqlNodeToRexConverterImpl.convertCall(SqlNodeToRexConverterImpl.java:62)
> 	at org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:5352)
> 	at org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:4547)
> 	at org.apache.calcite.sql.SqlCall.accept(SqlCall.java:161)
> 	at org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.convertExpression(SqlToRelConverter.java:5180)
> {noformat}



--
This message was sent by Atlassian Jira
(v8.20.7#820007)