Date: 2015-06-22 15:03:50 +0200
From: 357416268
To: SQL devs <>
Version: -- development
CC: @PedroTadim

Last updated: 2019-04-30 12:36:01 +0200

Comment 20937

Date: 2015-06-22 15:03:50 +0200
From: 357416268

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

DELETE FROM: cannot delete from merge table

Reproducible: Always

Steps to Reproduce:

1.create table t1(t int); insert into t1 values(1);
2.create table t2(t int);insert into t2 values(1);
3.create merge table tt(t int);alter table tt add table t1;alter table tt add table t2;
4. delete from tt where t=1;

Actual Results:

sql>delete from tt where t=1;
DELETE FROM: cannot delete from merge table 'tt'

Expected Results:

merge table should be able to be deleted from, otherwise users need to iterate every sub table to delete, it's very complicated for users to do so if merge table has a number of sub tables.

I am using default branch, downloaded on Jun 9 2015.
mserver5 --version
MonetDB 5 server v11.20.0 (64-bit, 64-bit oids, 128-bit integers)
This is an unreleased version
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Found 251.9GiB available memory, 16 available cpu cores
Libraries:
libpcre: 8.33 2013-05-28 (compiled with 8.33)
openssl: OpenSSL 1.0.1e 11 Feb 2013 (compiled with OpenSSL 1.0.1e-fips 11 Feb 2013)
libxml2: 2.9.1 (compiled with 2.9.1)
Compiled by: mwan@stones01.scilens.private (x86_64-unknown-linux-gnu)
Compilation: gcc -O3 -pipe -Werror -Wall -Wextra -W -Werror-implicit-function-declaration -Wpointer-arith -Wdeclaration-after-statement -Wundef -Wformat=2 -Wno-format-nonliteral -Winit-self -Winvalid-pch -Wmissing-declarations -Wmissing-format-attribute -Wmissing-prototypes -Wold-style-definition -Wpacked -Wunknown-pragmas -Wvariadic-macros -fstack-protector-all -Wstack-protector -Wpacked-bitfield-compat -Wsync-nand -Wjump-misses-init -Wmissing-include-dirs -Wlogical-op -Wunreachable-code -D_FORTIFY_SOURCE=2
Linking : /usr/bin/ld -m elf_x86_64

Comment 25380

Date: 2017-06-08 17:44:45 +0200
From: MonetDB Mercurial Repository <>

Changeset 52df84bcf8ba made by Martin van Dinther martin.van.dinther@monetdbsolutions.com in the MonetDB repo, refers to this bug.

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

Changeset description:

Add test script for feature request / bug #3743

Comment 26710

Date: 2018-12-04 09:49:39 +0100
From: MonetDB Mercurial Repository <>

Changeset 00ab6503524c 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=00ab6503524c

Changeset description:

With partitioned tables handling addition, we can now support delete statements in non-partitioned tables as well. This fixes bug #3743.