Date: 2017-04-22 03:53:00 +0200
From: Roberto Nunes Mourão <>
To: SQL devs <>
Version: 11.25.15 (Dec2016-SP3)
CC: martin.van.dinther

Last updated: 2017-06-12 15:14:48 +0200

Comment 25260

Date: 2017-04-22 03:53:00 +0200
From: Roberto Nunes Mourão <>

User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:53.0) Gecko/20100101 Firefox/53.0
Build Identifier:

After executing a query that uses a function which returns a sample of a table, mclient does not show any result on the first time. Executing the same query again, mclient exits.

Function example:
CREATE FUNCTION amostra(pdate date, st char(2)) RETURNS TABLE(v decimal(7, 2))
BEGIN
RETURN SELECT value FROM payments WHERE payment_date = pdate AND state = st SAMPLE 400;
END;

Query example:
select avg(v) from amostra('2011-01-01', 'DF');

Reproducible: Always

Steps to Reproduce:

1. Create a function using the SAMPLE operator.
2. Execute a query using the function.
3. Execute the query again.

Actual Results:

First, the query returned nothing. On the second time, mclient exited and a Ubuntu crash message appeared.

Expected Results:

Show the query results.

The original CSV data to create the table uses 37GB. Despite it, the queries were working very well. There is no merovingian.log.

mserver --version:

MonetDB 5 server v11.25.15 "Dec2016-SP3" (64-bit, 128-bit integers)
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2017 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Found 15.7GiB available memory, 8 available cpu cores
Libraries:
libpcre: 8.38 2015-11-23 (compiled with 8.38)
openssl: OpenSSL 1.0.2g 1 Mar 2016 (compiled with OpenSSL 1.0.2g-fips 1 Mar 2016)
libxml2: 2.9.3 (compiled with 2.9.3)
Compiled by: pbuilder@dev.monetdb.org (x86_64-pc-linux-gnu)
Compilation: gcc -O3 -fomit-frame-pointer -pipe -g -D_FORTIFY_SOURCE=2
Linking : /usr/bin/ld -m elf_x86_64

Comment 25279

Date: 2017-04-30 23:30:02 +0200
From: MonetDB Mercurial Repository <>

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

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=e4578a201e15

Changeset description:

fixes for the bugs 6297, 6296, 6294, 6291 and 6291
problems were in various relational optimizers

Comment 25292

Date: 2017-05-11 14:10:18 +0200
From: MonetDB Mercurial Repository <>

Changeset a1ab1d2552a2 made by Martin van Dinther martin.van.dinther@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=a1ab1d2552a2

Changeset description:

Add test for Bug #6291