The issue is the relation read code doesn't handle table returning functions. I'm adding it.

Best regards,

Pedro

Hi Ioannis!

This is a great reproducer. I tried it on Oct2020 and I see the same behaviour.

Could you file it as a new bug at https://www.monetdb.org/bugzilla/? If you prefer I can do it on your behalf.

Best regards,

Joeri

On 9/17/20 1:40 PM, Ioannis Foufoulas wrote:

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 <johnfouf@di.uoa.gr> 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

_______________________________________________
users-list mailing list
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