[
https://issues.apache.org/jira/browse/CALCITE-5950?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759152#comment-17759152
]
Julian Hyde commented on CALCITE-5950:
--------------------------------------
I've reviewed. When you've fixed the issues, please get someone else to do a
second review.
> Default column constraint is erroneously processed.
> ---------------------------------------------------
>
> Key: CALCITE-5950
> URL: https://issues.apache.org/jira/browse/CALCITE-5950
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.35.0
> Reporter: Evgeny Stanilovsky
> Assignee: Evgeny Stanilovsky
> Priority: Major
> Labels: pull-request-available
>
> II change table.iq a bit and found a problem with processing default column
> constraint:
> {code:java}
> create table tdef (i int not null, j int default 100);
> (0 rows modified)
> !update
> insert into tdef values (1, DEFAULT);
> (1 row modified)
> !update
> insert into tdef(i) values (2);
> (1 row modified)
> !update
> select * from tdef order by i;
> +---+-----+
> | I | J |
> +---+-----+
> | 1 | 100 |
> | 2 | 100 |
> +---+-----+
> (2 rows)
> !ok
> but obtain from calcite:
> +---+-----+
> | I | J |
> +---+-----+
> | 1 | |
> | 2 | 100 |
> +---+-----+
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
