Date: 2018-12-20 13:27:15 +0100
From: @joerivanruth
To: SQL devs <>
Version: 11.31.11 (Aug2018-SP1)
CC: @njnes

Last updated: 2019-04-30 12:36:00 +0200

Comment 26738

Date: 2018-12-20 13:27:15 +0100
From: @joerivanruth

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:65.0) Gecko/20100101 Firefox/65.0
Build Identifier:

In the reproducer shell script attached below we have a FUNCTION histo which accesses a MERGE TABLE containing a part that is a REMOTE TABLE.

If the part is not remote (second last line of the script), it returns the correct result, a single value which happens to be NULL.

If the part is remote (last line of the script), we get an error: Function 'calc.int' not defined.

Reproducible: Always

Steps to Reproduce:

Run the attached demo.sh with pre.sql, master.sql, slave.sql and post.sql present. This script kills ALL running mserver5's and starts its own mservers on ports 5501 and 5502.

Actual Results:

Function 'calc.int' not defined

Expected Results:

+------+
| L2 |
+======+
| null |
+------+

Comment 26739

Date: 2018-12-20 13:29:59 +0100
From: @joerivanruth

Created attachment 611
Tar file containing demo.sh, pre.sql, master.sql, slave.sql and post.sql

Attached file: q07.tar.gz (application/x-gzip, 746 bytes)
Description: Tar file containing demo.sh, pre.sql, master.sql, slave.sql and post.sql

Comment 26879

Date: 2019-02-06 14:48:03 +0100
From: MonetDB Mercurial Repository <>

Changeset 73905a09f51b made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=73905a09f51b

Changeset description:

fixes for bug #6671

Comment 26880

Date: 2019-02-06 14:48:42 +0100
From: @njnes

handle table results from a remote query (which are single values)