[IGNITE-22120] Sql. Possibility set zero length for character string type

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: sql
• Labels: calcite2-required calcite3-required ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Iurii Gerzhedovich
• Created: 26/Apr/24 09:53
• Updated: 29/Apr/24 06:31

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

CREATE TABLE t_zero(c1 CHAR(0), c2 VARCHAR(0)); -- no error

Require to fix it.

Issue Links

• Discovered while testing: IGNITE-21953 Cover SQL E021-01(Character string types. CHARACTER data type) feature by tests