Hi Yannis!

Merge tables are allowed to contain only a single partition. For example,

sql>create table part(i int);
create table part(i int);
operation successful
sql>create merge table merg(like part);
create merge table merg(like part);
operation successful
sql>alter table merg add table part;
alter table merg add table part;
operation successful
sql>insert into part values (42);
insert into part values (42);
1 affected row
sql>select * from merg;
select * from merg;
+------+
| i    |
+======+
|   42 |
+------+
1 tuple

I've seen the kind error message you get before, it is probably related to an internal bug which mangles the query when it's sent to the remote host.

Could you create a SQL script that reproduces the bug? There is no need for data, the CREATE statements on both hosts and the SELECT query are probably enough. If so, please file a bug on the MonetDB issue tracker at https://www.monetdb.org/bugzilla/.

Best regards,

Joeri van Ruth

Hi, we encounter an error when only one table is added to a merge table definition

During a query like "select * from merge table” we get: 

“Table: missing ')'"

Probably merge tables cannot contain just one table but the returned error looks like a syntax error.

Some more info to reproduce: the table that has been added to the merge table is a remote table.

Best,

Yannis

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