You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
CREATE TABLE x(a1 string);
INSERT INTO x VALUES ('aa'),('bb'),('cc'),('aa');
CREATE VIEW y AS SELECT row_number() OVER(ORDER BY a1) AS a1, a1 AS a2 FROM (SELECT a1 FROM x GROUP BY a1) AS t;
Date: 2015-12-18 15:18:56 +0100
From: @swingbit
To: SQL devs <>
Version: 11.21.11 (Jul2015-SP1)
CC: @njnes
Last updated: 2016-03-25 09:59:57 +0100
Comment 21675
Date: 2015-12-18 15:18:56 +0100
From: @swingbit
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.80 Safari/537.36
Build Identifier:
(Possibly related to https://www.monetdb.org/bugzilla/show_bug.cgi?id=3705)
CREATE TABLE x(a1 string);
INSERT INTO x VALUES ('aa'),('bb'),('cc'),('aa');
CREATE VIEW y AS SELECT row_number() OVER(ORDER BY a1) AS a1, a1 AS a2 FROM (SELECT a1 FROM x GROUP BY a1) AS t;
Gives:
2015-12-18 15:09:57 MSG trec2[17004]: could not find t.a1
2015-12-18 15:09:57 MSG trec2[17004]: x.a1
2015-12-18 15:09:57 ERR trec2[17004]: mserver5: /opt/monetdb/Jul2015_optimized/MonetDB.Spinque_Jul2015/src/sql/backends/monet5/rel_bin.c:2378: rel2bin_project: Assertion `0' failed.
The query works if I remove either the window function or the group by in the subselect.
Reproducible: Always
MonetDB 5 server v11.21.12 (64-bit, 64-bit oids, 128-bit integers)
This is an unreleased version
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Found 31.4GiB available memory, 8 available cpu cores
Libraries:
libpcre: 8.37 2015-04-28 (compiled with 8.37)
openssl: OpenSSL 1.0.1k 8 Jan 2015 (compiled with OpenSSL 1.0.1k-fips 8 Jan 2015)
libxml2: 2.9.2 (compiled with 2.9.2)
Compiled by: roberto@spinque02.spinque.com (x86_64-unknown-linux-gnu)
Compilation: gcc -O3 -pipe -Werror -Wall -Wextra -W -Werror-implicit-function-declaration -Wpointer-arith -Wdeclaration-after-statement -Wundef -Wformat=2 -Wno-format-nonliteral -Winit-self -Winvalid-pch -Wmissing-declarations -Wmissing-format-attribute -Wmissing-prototypes -Wold-style-definition -Wpacked -Wunknown-pragmas -Wvariadic-macros -fstack-protector-all -Wstack-protector -Wpacked-bitfield-compat -Wsync-nand -Wjump-misses-init -Wmissing-include-dirs -Wlogical-op -Wunreachable-code -D_FORTIFY_SOURCE=2
Linking : /usr/bin/ld -m elf_x86_64
Comment 21895
Date: 2016-03-14 08:55:51 +0100
From: MonetDB Mercurial Repository <>
Changeset 98cdca21a670 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=98cdca21a670
Changeset description:
Comment 21896
Date: 2016-03-14 09:02:48 +0100
From: MonetDB Mercurial Repository <>
Changeset ab01ce4fa677 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=ab01ce4fa677
Changeset description:
Comment 21897
Date: 2016-03-14 09:03:14 +0100
From: @njnes
fixed in 2015 branch (default has a new implementation for window functions, ie didn't have this bug)
Comment 21981
Date: 2016-03-25 09:59:57 +0100
From: @sjoerdmullender
Jul2015-SP3 has been released.
The text was updated successfully, but these errors were encountered: