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

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

Vova Vysotskyi created DRILL-8210:
-------------------------------------

             Summary: Add substring convertlet
                 Key: DRILL-8210
                 URL: https://issues.apache.org/jira/browse/DRILL-8210
             Project: Apache Drill
          Issue Type: Sub-task
            Reporter: Vova Vysotskyi
            Assignee: Vova Vysotskyi


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)