Date: 2015-12-18 17:40:21 +0100
From: Kaijiang <>
To: SQL devs <>
Version: 11.21.11 (Jul2015-SP1)
CC: @njnes

Last updated: 2016-03-25 09:59:25 +0100

Comment 21676

Date: 2015-12-18 17:40:21 +0100
From: Kaijiang <>

User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.106 Safari/537.36
Build Identifier:

create a table and insert some integers; execute sql with window function; then mserver5 process is gone.

Reproducible: Always

Steps to Reproduce:

1. create table t3 (f1 int, f2 int);
2. insert into t3 values (1,1), (2,2), (3,3), (4,4), (5,5);
3. select f1,f2, avg(f1) over (order by f2 rows between 2 PRECEDING AND CURRENT ROW) from t3;

Actual Results:

mserver5 process gone

Expected Results:

gives sql result

Comment 21713

Date: 2016-01-06 08:05:09 +0100
From: Kaijiang <>

also crashes if I use RANGE clause:
select f1,f2, avg(f1) over (order by f2 range between 2 PRECEDING AND CURRENT ROW) from t3;

Comment 21898

Date: 2016-03-14 09:07:58 +0100
From: MonetDB Mercurial Repository <>

Changeset b195a709fce8 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=b195a709fce8

Changeset description:

remove bogus (debug) assert, fixes bug #3891 (well the crash only, as
window functions with aggregation (avg,sum etc) isn't supported).

Comment 21899

Date: 2016-03-14 09:08:28 +0100
From: @njnes

Crash is fixed (window functions with aggregation aren't supported at the moment)

Comment 21965

Date: 2016-03-25 09:59:25 +0100
From: @sjoerdmullender

Jul2015-SP3 has been released.