Date: 2017-03-22 15:32:26 +0100
From: @mlkersten
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2018-03-29 15:39:24 +0200

Comment 25170

Date: 2017-03-22 15:32:26 +0100
From: @mlkersten

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:51.0) Gecko/20100101 Firefox/51.0
Build Identifier:

According to the SQL standard DEFAULT is a valid expression in the context of inserts and updates. It is currently not supported.

Reproducible: Always

Comment 25398

Date: 2017-06-28 11:20:55 +0200
From: MonetDB Mercurial Repository <>

Changeset 24d1f738cf7c made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=24d1f738cf7c

Changeset description:

INSERT INTO and UPDATE statements with default values of columns. Fixes bug #6249

Comment 25417

Date: 2017-07-05 22:25:29 +0200
From: @njnes

thanks pedro for fixing this issue.

Comment 25418

Date: 2017-07-05 23:51:56 +0200
From: @sjoerdmullender

(In reply to Niels Nes from comment 2)

thanks pedro for fixing this issue.

Indeed.

But can somebody please add a blurb in the sql/ChangeLog file (using the appropriate tools).

Comment 26324

Date: 2018-03-29 15:39:24 +0200
From: @sjoerdmullender

The Mar2018 version has been released.