Re: MERGE TABLE - CANNOT DROP PARTITION

Hi Ariel, An ALTER TABLE cubm_201909 DROP TABLE cub8_20190901; command does not drop the table cub8_20190901 itself, only removes the partition table from a MERGE TABLE set. To drop the cub8_20190901 itself use: DROP TABLE cub8_20190901; See also: https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/DataPartitioning However running multiple "ALTER TABLE cubm_201909 DROP TABLE cub8_20190901;" commands sequentially should definitely give an error from the second one onwards. If not, that is a bug. Try reproducing the issue in a clean new test schema or test database. If reproducable, log it in Bugzilla. If not reproducable, potentially your current data dictionary / database is corrupted. Make a dump of the database asap and recreate a second database using the dump. Regards, Martin On 10/23/19 6:42 PM, Ariel Abadi wrote:

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 mailto: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 mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

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