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:
Create a function using the SAMPLE operator.
Execute a query using the function.
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
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:
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:
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:
The text was updated successfully, but these errors were encountered: