[
https://issues.apache.org/jira/browse/CALCITE-6192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Nuyanzin closed CALCITE-6192.
------------------------------------
Resolved in release 1.37.0 (2024-05-06)
> DEFAULT expression with NULL value throws unexpected exception
> --------------------------------------------------------------
>
> Key: CALCITE-6192
> URL: https://issues.apache.org/jira/browse/CALCITE-6192
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.36.0
> Reporter: Evgeny Stanilovsky
> Assignee: Evgeny Stanilovsky
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.37.0
>
>
> Processing of DEFAULT expression was improved in scope of [1] but seems there
> is one case with NULL as value is not covered and processed erroneously.
> {code:java}
> create table tdef1 (i int not null, col1 int default null);
> insert into tdef1(i, col1) values (1, DEFAULT);
> {code}
> throws :
> {code:java}
> Error while executing SQL "insert into tdef1(i, col1) values (1, DEFAULT)":
> class org.apache.calcite.sql.SqlLiteral: NULL
> {code}
> [1] https://issues.apache.org/jira/browse/CALCITE-5950
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
