[ https://issues.apache.org/jira/browse/CALCITE-4427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17245499#comment-17245499 ]
Haisheng Yuan commented on CALCITE-4427: ---------------------------------------- +1 to comply with ISO standard SQL. > Make SUBSTRING operator comply with ISO standard SQL > ---------------------------------------------------- > > Key: CALCITE-4427 > URL: https://issues.apache.org/jira/browse/CALCITE-4427 > Project: Calcite > Issue Type: Bug > Reporter: Julian Hyde > Priority: Major > > Make {{SUBSTRING}} operator comply with ISO standard SQL. It currently > complies with BigQuery standard SQL, which gives different behavior when > start is negative. See discussion in CALCITE-4408. > Add an option to get the BigQuery behavior, for those who want it. -- This message was sent by Atlassian Jira (v8.3.4#803005)