ZheHu created CALCITE-6755:
------------------------------
Summary: Add SUBSTRING function(enabled in MSSQL library)
Key: CALCITE-6755
URL: https://issues.apache.org/jira/browse/CALCITE-6755
Project: Calcite
Issue Type: Improvement
Components: core
Affects Versions: 1.38.0
Reporter: ZheHu
Assignee: ZheHu
SUBSTRING function in SQL Server behaves almost like what in Calcite.
The only slight difference is the number of arguments. For example, the
following expression will throw "The substring function requires 3
argument(s)." in SQL Server, but succeed in Calcite, which means
substringLength argument is required for SQL Server.
{code:java}
SELECT substring('abcdef', 1)
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
