[ https://issues.apache.org/jira/browse/CALCITE-5950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Evgeny Stanilovsky updated CALCITE-5950: ---------------------------------------- Fix Version/s: 1.36.0 > 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 > Fix For: 1.36.0 > > > 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)