Date: 2018-07-19 15:58:50 +0200
From: @yzchang
To: SQL devs <>
Version: 11.29.3 (Mar2018)
CC: @PedroTadim

Last updated: 2018-08-31 13:23:27 +0200

Comment 26558

Date: 2018-07-19 15:58:50 +0200
From: @yzchang

See the following outputs, the second CREATE TABLE IF NOT EXISTS shouldn't returns an error:

sql>create table if not exists test (i int);
operation successful
sql>create table if not exists test (i int);
42000!

Comment 26559

Date: 2018-07-19 16:37:12 +0200
From: MonetDB Mercurial Repository <>

Changeset d0ccbcf6ba07 made by Ying Zhang y.zhang@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=d0ccbcf6ba07

Changeset description:

Added test for Bug #6629

Comment 26562

Date: 2018-07-19 17:33:40 +0200
From: MonetDB Mercurial Repository <>

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

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=d76c8980d34d

Changeset description:

Fixes for bug #6629, ie create an empty PSM relation when a table or schema already exists on a "IF NOT EXISTS" query.

Comment 26563

Date: 2018-07-20 10:10:18 +0200
From: @sjoerdmullender

It was fixed in the Mar2018 branch.