Hi!
I'm still having issue dropping internal tables from the MERGE TABLE. I used to have this problem on a previous version.
I have created a new DB, imported all the data... and now I need to delete a partition (NOT a table).
I'm still facing the same problem, which is that I cannot remove it from the merge table. (as you can see below)..
Is there anything I can do?
Rgds
Ariel
Welcome to mclient, the MonetDB/SQL interactive terminal (Apr2019)
Database: MonetDB v11.33.3 (Apr2019), 'mapi:monetdb://dt-mn:54321/cli_dg'
Type \q to quit, \? for a list of available commands
auto commit mode: on
sql>ALTER TABLE sb_traf.cub15_cubo DROP TABLE sb_traf.cub8_20190801;
operation successful
sql>ALTER TABLE sb_traf.cub15_cubo DROP TABLE sb_traf.cub8_20190801;
operation successful
sql>ALTER TABLE sb_traf.cub15_cubo DROP TABLE sb_traf.cub8_20190801;
operation successful
sql>ALTER TABLE sb_traf.cub15_cubo DROP TABLE sb_traf.cub8_20190801;
operation successful
sql>ALTER TABLE sb_traf.cub15_cubo DROP TABLE sb_traf.cub8_20190801;
operation successful
sql>ALTER TABLE sb_traf.cub15_cubo DROP TABLE sb_traf.cub8_20190801;
operation successful
sql>ALTER TABLE sb_traf.cub15_cubo DROP TABLE sb_traf.cub8_20190801;
operation successful
sql>ALTER TABLE sb_traf.cub15_cubo DROP TABLE sb_traf.cub8_20190801;
operation successful