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

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0
• Component/s: sql
• Labels: calcite2-required calcite3-required ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Maksim Zhuravkov
• Reporter: Iurii Gerzhedovich
• Created: 26/Apr/24 09:53
• Updated: 04/Sep/24 16:08
• Resolved: 23/May/24 07:22

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
• links to: GitHub Pull Request #3782