[
https://issues.apache.org/jira/browse/IGNITE-22120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Iurii Gerzhedovich updated IGNITE-22120:
----------------------------------------
Description:
Syntax Rules of paragraph 6.1 of Sql Standard says: The value of a <length>
shall be greater than 0 (zero).
However, we can set zero length for CHAR type
{code:java}
CREATE TABLE t_zero(c1 CHAR(0), c2 VARCHAR(0)); -- no error{code}
Require to fix it.
was:
Syntax Rules of paragraph 6.1 of Sql Standard says: The value of a <length>
shall be greater than 0 (zero).
However, we can set zero length for CHAR type
{code:java}
CREATE TABLE t_zero(c1 CHAR(0)); -- no error{code}
Require to fix it.
> Sql. Possibility set zero length for character string type
> ----------------------------------------------------------
>
> Key: IGNITE-22120
> URL: https://issues.apache.org/jira/browse/IGNITE-22120
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Iurii Gerzhedovich
> Priority: Major
> Labels: calcite2-required, calcite3-required, ignite-3
>
> Syntax Rules of paragraph 6.1 of Sql Standard says: The value of a <length>
> shall be greater than 0 (zero).
> However, we can set zero length for CHAR type
> {code:java}
> CREATE TABLE t_zero(c1 CHAR(0), c2 VARCHAR(0)); -- no error{code}
> Require to fix it.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
