crash on seeming incorrect SQL query

[monetdb-team]

Date: 2013-08-12 13:17:19 +0200
From: @grobian
To: SQL devs <>
Version: 11.15.11 (Feb2013-SP3)
CC: @njnes

Last updated: 2019-01-09 11:49:53 +0100

Comment 18989

Date: 2013-08-12 13:17:19 +0200
From: @grobian

sql>select "function", (sum(fv.claim_tb) - sum(fv.used_tb)) * 100 / toc.total_overcapacity from sys.filer_volumes as fv, (select sum(claim_tb) - sum(used_tb) as total_overcapacity from sys.filer_volumes) as toc group by fv."function" order by fv."function";
MAPI = (monetdb) /tmp/.s.monetdb.52100
ACTION= read_line
QUERY = select "function", (sum(fv.claim_tb) - sum(fv.used_tb)) * 100 / toc.total_overcapacity from sys.filer_volumes as fv, (select sum(claim_tb) - sum(used_tb) as total_overcapacity from sys.filer_volumes) as toc group by fv."function" order by fv."function";
ERROR = !Connection terminated

Welcome to mclient, the MonetDB/SQL interactive terminal (Feb2013-c94f47b62764)
Database: MonetDB v11.15.8 (Feb2013-c94f47b62764), 'mapi:monetdb://gaia.local:52100/filerdata'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>\d sys.filer_volumes
CREATE TABLE "sys"."filer_volumes" (
"filer" VARCHAR(256) NOT NULL,
"volume" VARCHAR(256) NOT NULL,
"claim_tb" INTEGER,
"used_tb" INTEGER,
"used_perc" SMALLINT,
"function" VARCHAR(24),
CONSTRAINT "filer_volumes_filer_volume_pkey" PRIMARY KEY ("filer", "volume")
);
sql>

merovingian.log:
2013-08-12 09:20:04 MSG filerdata[74564]: arguments: /Users/fgroffen/develop/Mon
etDB/Feb2013/program-x86_64/bin/mserver5 --dbpath=/Users/fgroffen/develop/MonetD
B/monetdb-dbfarms/Feb2013-52100/filerdata --set merovingian_uri=mapi:monetdb://g
aia.local:52100/filerdata --set mapi_open=false --set mapi_port=0 --set mapi_uso
ck=/Users/fgroffen/develop/MonetDB/monetdb-dbfarms/Feb2013-52100/filerdata/.mapi
.sock --set monet_vault_key=/Users/fgroffen/develop/MonetDB/monetdb-dbfarms/Feb2
013-52100/filerdata/.vaultkey --set gdk_nr_threads=4 --set max_clients=64 --set
sql_optimizer=default_pipe --set monet_daemon=yes
2013-08-12 09:20:04 MSG filerdata[74564]: MonetDB 5 server v11.15.8 "Feb2013-c
94f47b62764"
2013-08-12 09:20:04 MSG filerdata[74564]: Serving database 'filerdata', using
4 threads
2013-08-12 09:20:04 MSG filerdata[74564]: Compiled for x86_64-apple-darwin11/6
4bit with 64bit OIDs dynamically linked
2013-08-12 09:20:04 MSG filerdata[74564]: Found 8.000 GiB available main-memor
y.
2013-08-12 09:20:04 MSG filerdata[74564]: Copyright (c) 1993-July 2008 CWI.
2013-08-12 09:20:04 MSG filerdata[74564]: Copyright (c) August 2008-2013 Monet
DB B.V., all rights reserved
2013-08-12 09:20:04 MSG filerdata[74564]: Visit http://www.monetdb.org/ for further information
2013-08-12 09:20:04 MSG filerdata[74564]: Listening for UNIX domain connection requests on mapi:monetdb:///Users/fgroffen/develop/MonetDB/monetdb-dbfarms/Feb2013-52100/filerdata/.mapi.sock
2013-08-12 09:20:04 MSG filerdata[74564]: MonetDB/JAQL module loaded
2013-08-12 09:20:04 MSG filerdata[74564]: MonetDB/SQL module loaded
2013-08-12 13:09:13 ERR filerdata[74564]: Assertion failed: (0), function rel2bin_project, file /Users/fgroffen/develop/MonetDB/Feb2013/hgrepo/sql/backends/monet5/rel_bin.c, line 2310.
2013-08-12 13:09:13 MSG filerdata[74564]: could not find toc.total_overcapacity
2013-08-12 13:09:13 MSG filerdata[74564]: fv.function
2013-08-12 13:09:13 MSG filerdata[74564]: fv.L3
2013-08-12 13:09:13 MSG filerdata[74564]: fv.L4
2013-08-12 13:09:13 MSG filerdata[74564]: fv.function
2013-08-12 13:09:18 MSG merovingian[74552]: database 'filerdata' (74564) was killed by signal SIGABRT

It's really toy data:
sql>select count(*) from sys.filer_volumes;
+------+
| L1 |
+======+
| 192 |
+------+
1 tuple (0.882ms)
sql>select * from sys.filer_volumes limit 4;
+----------------+-----------+----------+---------+-----------+----------+
| filer | volume | claim_tb | used_tb | used_perc | function |
+================+===========+==========+=========+===========+==========+
| filer-1 | X/ | 63 | 62 | 99 | size |
| filer-2 | Y/ | 62 | 62 | 99 | size |
| filer-3 | A/ | 61 | 23 | 38 | size |
| filer-4 | B/ | 28 | 23 | 83 | size |
+----------------+-----------+----------+---------+-----------+----------+
4 tuples (1.864ms)

Comment 18999

Date: 2013-08-14 20:56:19 +0200
From: MonetDB Mercurial Repository <>

Changeset 3e860a8ce292 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=3e860a8ce292

Changeset description:

fixed bug #3340. Cannot use non-groupby columns after groupby.

Comment 19000

Date: 2013-08-14 21:16:54 +0200
From: @njnes

fixed. You cannot use columns (of the inner query) after the groupby.

Comment 26783

Date: 2019-01-09 11:49:53 +0100
From: MonetDB Mercurial Repository <>

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

Changeset description:

We will approve bug #6608 error messages (same issue as in bug #3340).