suibianwanwan created CALCITE-6523:
--------------------------------------
Summary: Oracle SUBSTR semantics different from Calcite
Key: CALCITE-6523
URL: https://issues.apache.org/jira/browse/CALCITE-6523
Project: Calcite
Issue Type: Bug
Components: core
Reporter: suibianwanwan
Oracle's `SUBSTR` has very different semantics. For example, if the length of
the character is less than the second argument, null is returned.
I tested Spark sql, presto, mysql all return empty string, same in calcite.
Should we do something about this in RelToSqlConverter?
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
