Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
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.
Attachments
Issue Links
- is related to
-
CALCITE-4408 Implement Oracle SUBSTR function
- Closed
-
CALCITE-6211 SUBSTRING with Integer.MIN_VALUE as a second parameter raise unexpected exception
- Closed