Bug 6971

Summary: Parsing table returning function on remote server fails
Product: SQL Reporter: Pedro Ferreira <pedrotadim>
Component: allAssignee: SQL devs <bugs-sql>
Status: RESOLVED FIXED    
Severity: minor    
Priority: Normal    
Version: 11.37.11 (Jun2020-SP1)   
Hardware: x86_64 (amd64/em64t)   
OS: Linux   

Description Pedro Ferreira 2020-09-18 11:09:04 CEST
User-Agent:       Mozilla/5.0 (X11; Fedora; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36
Build Identifier: 

Using a remote table under a table returning function fails.

Reproducible: Always

Steps to Reproduce:
1. Create a table udf.
2. Create a remote table.
3. Do: select * from table_udf((select * from remote_table));
Actual Results:  
select * from table_udf((select * from remote_table));
(mapi:monetdb://user@host/dbfarm) Table: missing ‘)'

Expected Results:  
The desired output from the table udf.

I already have a fix. I'm making the bug report
Comment 1 MonetDB Mercurial Repository cwiconfidential 2020-09-18 11:20:32 CEST
Changeset 7f2af1be69a6, made by Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> in the MonetDB repo, refers to this bug.

For complete details, see https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7f2af1be69a6

Changeset description:

	Added test and fix for bug 6971, ie add table udf support at rel_read