COPY INTO with incorrect number columns

[monetdb-team]

Date: 2015-08-27 08:16:32 +0200
From: @mlkersten
To: SQL devs <>
Version: 11.17.13 (Jan2014-SP1)

Last updated: 2015-11-03 10:18:02 +0100

Comment 21167

Date: 2015-08-27 08:16:32 +0200
From: @mlkersten

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

Lines with an incorrect number of columns should simply be skipped and added to the rejects table. It currently stops the best effort sequence when insufficient columns are provided.
A test has been added.

Reproducible: Always

Comment 21171

Date: 2015-08-27 22:36:41 +0200
From: MonetDB Mercurial Repository <>

Changeset 1e216af13eec made by Martin Kersten mk@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

Add test for bug #3797

Comment 21172

Date: 2015-08-27 22:38:31 +0200
From: @mlkersten

• ignore lines with less/more values then needed
• provide proper error messages
• fix post error fixing in the columns returned

Comment 21433

Date: 2015-11-03 10:18:02 +0100
From: @sjoerdmullender

Jul2015 SP1 has been released.