Re: Merge table error with one table

17 Sep 2020

      Hi,

Some more info on this error, finally this is does not related to merge tables but to remote tables. 
Steps to reproduce:

In one server:
create table lala(sx float, sxx float, sxy float , sy float, syy float, n int);
insert into lala select 13,85,98,15,113,2;

In another remote server:
CREATE REMOTE TABLE fofo(sx FLOAT, sxx FLOAT, sxy FLOAT, sy FLOAT, syy FLOAT, n INT) on 'mapi:monetdb://88.197.53.136:9999/voc10/sys/lala';

CREATE or replace FUNCTION mudf(sx FLOAT, sxx FLOAT, sxy FLOAT, sy FLOAT, syy FLOAT, n INT) 
RETURNS TABLE(res FLOAT)
LANGUAGE PYTHON {
        return 0.5   
};

After that I am getting the following:
sql>select * from mudf((select * from fofo));
(mapi:monetdb://monetdb@88.197.53.136/voc10) Table: missing ‘)'

If I materialise the remote table into a local table, and then use the udf it runs:

sql>create table localtable as select  * from fofo;
operation successful
sql>select * from mudf((select * from localtable));
+--------------------------+
| res                      |
+==========================+
|                      0.5 |
+--------------------------+
1 tuple
sql>

Best,
Yannis
...
On 16 Sep 2020, at 3:34 PM, Ioannis Foufoulas  wrote:
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