[IGNITE-18965] Sql. CREATE TABLE fails when a column with DEFAULT constraint NULL is present.

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 3.0
• Component/s: sql
• Labels: calcite2-required ignite-3
• Assignee: Maksim Zhuravkov
• Reporter: Maksim Zhuravkov
• Created: 06/Mar/23 08:49
• Updated: 04/Sep/24 16:11
• Resolved: 25/Aug/23 07:25

Description

Default constraint with value = NULL causes an error.

CREATE TABLE tbl(id int PRIMARY KEY, val INTEGER DEFAULT NULL)

Caused by: java.lang.ClassCastException: Cannot cast org.apache.calcite.rel.metadata.NullSentinel$1 to java.lang.Integer
	at java.base/java.lang.Class.cast(Class.java:3605)
	at org.apache.calcite.sql.SqlLiteral.getValueAs(SqlLiteral.java:288)
	at org.apache.ignite.internal.sql.engine.prepare.ddl.DdlSqlToCommandConverter.fromLiteral(DdlSqlToCommandConverter.java:799)

Issue Links

• links to: GitHub Pull Request #2489