The steps are very simple...

1) I have created the MERGE TABLE
CREATE MERGE TABLE cubm_201909 AS (SELECT * FROM cub) WITH NO DATA;
2) I have attached the table:
ALTER TABLE cubm_201909 ADD TABLE cub8_20190901; 
3) Wanted to REMOVE the table:
ALTER TABLE cubm_201909 DROP TABLE cub8_20190901; 

This new MERGE table has inside 30 tables attached, none of them were removed.

We are using MonetDB v11.31.7 (Aug2018)

Thks 
Ariel



 


On Wed, Oct 23, 2019 at 1:32 PM ferreira <pedro.ferreira@monetdbsolutions.com> wrote:

Hello Ariel, this looks like a bug. Can you send the reproducible steps?

Best regards,

Pedro

On 10/23/19 6:16 PM, Ariel Abadi wrote:
Hi!
Can someone help me? 
Im trying to REMOVE a table from a merge table, when I run the command, it states "operation successful", but the table is NOT removed. 
Here you can see an example... I have run it several times, but the table is still there :(

image.png






_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list