Segvault in complex function call

[monetdb-team]

Date: 2013-08-11 15:48:27 +0200
From: @mlkersten
To: SQL devs <>
Version: 11.15.7 (Feb2013-SP2)
CC: @njnes

Last updated: 2013-11-19 10:18:37 +0100

Comment 18988

Date: 2013-08-11 15:48:27 +0200
From: @mlkersten

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

A segvault occurs
327 rel->nrcols = l->nrcols;
(gdb) where
0 0x00007f23e917b9c8 in rel_groupby (sql=0x7f23dc005470, l=0x0, groupbyexps=0x0) at /export/scratch1/mk/sciql//package/sql/server/rel_select.c:1327
1 0x00007f23e918e10a in rel_value_exp2 (sql=0x7f23dc005470, rel=0x7f23e3ffe990, se=0x7f23dc1b0090, f=2, ek=..., is_last=0x7f23e3ffe89c)
at /export/scratch1/mk/sciql//package/sql/server/rel_select.c:5456

Test file added as BugTracker-2013/Tests/pivot.Bug-*.sql

Reproducible: Always

Comment 19022

Date: 2013-08-18 16:34:57 +0200
From: MonetDB Mercurial Repository <>

Changeset 2f5e9233e51a 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=2f5e9233e51a

Changeset description:

fixed bug #3339, we do not allow multiple values /rows as arguments for table returning functions.

Comment 19023

Date: 2013-08-18 16:35:37 +0200
From: @njnes

fixed, we disallow multiple inputs into table returning funciions

Comment 19345

Date: 2013-11-19 10:18:37 +0100
From: MonetDB Mercurial Repository <>

Changeset f10e5c3dbf41 made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

pivot.Bug-3339: provided stable output; NEEDS TO BE CHECKED/FIXED

(having tests without correct/expected stable output
 IMHO does not make much sense ...)