[
https://issues.apache.org/jira/browse/CALCITE-7923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mihai Budiu reassigned CALCITE-7923:
------------------------------------
Assignee: Mihai Budiu
> SUBSTRING index may silently overflow for BINARY arguments
> ----------------------------------------------------------
>
> Key: CALCITE-7923
> URL: https://issues.apache.org/jira/browse/CALCITE-7923
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.42.0
> Reporter: Mihai Budiu
> Assignee: Mihai Budiu
> Priority: Minor
>
> Broken quidem test:
> {code:java}
> SELECT SUBSTRING(x'123456' FROM 2 FOR 2147483647) AS c;
> +------+
> | C |
> +------+
> | 3456 |
> +------+
> (1 row) {code}
> The result produced by Calcite is the empty string.
> This was fixed in [{color:#3b3b3b}CALCITE-5810] for STRING arguments.{color}
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
