[jira] [Created] (CALCITE-5950) Default column constraint is erroneously processed.

[Evgeny Stanilovsky (Jira)]

Evgeny Stanilovsky created CALCITE-5950:
-------------------------------------------

             Summary: 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


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)