COPY INTO from .. LOCKED doubles input data

[monetdb-team]

Date: 2018-12-06 18:35:16 +0100
From: Anton Kravchenko <<kravchenko.anton86>>
To: SQL devs <>
Version: 11.29.3 (Mar2018)

Last updated: 2019-01-14 17:29:06 +0100

Comment 26715

Date: 2018-12-06 18:35:16 +0100
From: Anton Kravchenko <<kravchenko.anton86>>

User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.80 Safari/537.36
Build Identifier:

After dropping ordered indexes "COPY INTO from .. LOCKED" doubles input data

Reproducible: Always

Steps to Reproduce:

1.create table t1(v1 int);
2.create ordered index "t1_v1" on "sys"."t1"("v1");
3.drop index "t1_v1";
4.copy into t1 from '/apath/t1.txt' LOCKED;
5.select count(*) from t1;

Actual Results:

doubled counts

Expected Results:

original counts

Comment 26716

Date: 2018-12-07 10:56:35 +0100
From: MonetDB Mercurial Repository <>

Changeset 6ff72f0982f1 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=6ff72f0982f1

Changeset description:

Added test for bug #6666.

Comment 26726

Date: 2018-12-12 16:42:41 +0100
From: MonetDB Mercurial Repository <>

Changeset 5855d4ced37b made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

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

Changeset description:

Fix for bug #6666.
Because rel2bin_insert goes down a level if the UPD_COMP flag is set,
we need to copy the UPD_LOCKED flag down to that level.