[CALCITE-5950] DEFAULT expression is ignored during INSERT

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.35.0
• Fix Version/s: 1.36.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Evgeny Stanilovsky
• Reporter: Evgeny Stanilovsky
• Created: 22/Aug/23 13:34
• Updated: 10/Nov/23 11:34
• Resolved: 14/Oct/23 01:31

Description

II change table.iq a bit and found a problem with processing default column expression:

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 |
+---+-----+

Issue Links

• links to: GitHub Pull Request #3393