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...
I have created the MERGE TABLE
CREATE MERGE TABLE cubm_201909 AS (SELECT * FROM cub) WITH NO DATA;
I have attached the table:
ALTER TABLE cubm_201909 ADD TABLE cub8_20190901;
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 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