Bug 6971 - Parsing table returning function on remote server fails
Summary: Parsing table returning function on remote server fails
Alias: None
Product: SQL
Classification: Unclassified
Component: all (show other bugs)
Version: 11.37.11 (Jun2020-SP1)
Hardware: x86_64 (amd64/em64t) Linux
: Normal minor
Assignee: SQL devs
Depends on:
Reported: 2020-09-18 11:09 CEST by Pedro Ferreira
Modified: 2020-10-19 21:17 CEST (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
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