Date: 2015-11-16 14:41:33 +0100
From: @rkoopmanschap
To: SQL devs <>
Version: 11.21.11 (Jul2015-SP1)
CC: @yzchang

Last updated: 2018-11-07 17:08:03 +0100

Comment 21525

Date: 2015-11-16 14:41:33 +0100
From: @rkoopmanschap

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

Entering the information below, which utilize window functions cause the database connection to be lost.

Reproducible: Always

Steps to Reproduce:

Problem 1

CREATE TABLE foo (
test1 VARCHAR(48),
test2 VARCHAR(65535) DEFAULT '',
test3 VARCHAR(32),
test4 INTEGER,
test5 INTEGER
);

ALTER TABLE foo ADD COLUMN test6 BOOLEAN;
ALTER TABLE foo ADD COLUMN test7 BOOLEAN;
ALTER TABLE foo ADD COLUMN test8 BOOLEAN;

UPDATE foo SET test5 = ROW_NUMBER() OVER (
PARTITION BY test1
ORDER BY test4 ASC,
test6 DESC,
test8 DESC,
test7 ASC,
test3 ASC);

Problem 2

CREATE TABLE foo (col INTEGER);
UPDATE foo SET col = ROW_NUMBER() OVER (ORDER BY col);

Actual Results:

Both cause a bug

Expected Results:

0 affected rows (5.368ms)

This bug has already been fixed.

Comment 21534

Date: 2015-11-17 11:16:32 +0100
From: MonetDB Mercurial Repository <>

Changeset b948d3410112 made by Richard Koopmanschap richard.koopmanschap@monetdbsolutions.com in the MonetDB repo, refers to this bug.

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

Changeset description:

Added test for fixed bug #3861

Comment 21536

Date: 2015-11-17 13:05:11 +0100
From: @yzchang

Just to keep the info. This bug is fixed by Changeset: e922ae6a3178

Comment 26666

Date: 2018-11-06 16:25:38 +0100
From: MonetDB Mercurial Repository <>

Changeset a3adc35abffc made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.

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

Changeset description:

Fix for failing window_function_crash.Bug-3861 test.

However this makes some update statements fail in other tests.

Comment 26674

Date: 2018-11-07 17:08:03 +0100
From: MonetDB Mercurial Repository <>

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

Changeset description:

fix for window_function_crash.Bug-3861