Assertion in rel2bin_project

[monetdb-team]

Date: 2013-06-20 21:53:13 +0200
From: @swingbit
To: SQL devs <>
Version: 11.15.1 (Feb2013)
CC: @njnes

Last updated: 2015-05-08 10:28:53 +0200

Comment 18873

Date: 2013-06-20 21:53:13 +0200
From: @swingbit

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

The script in attachment contains a schema definition (no data) and a final EXPLAIN statement. The MAL plan generation fails with an assertion in rel2bin_project.

Reproducible: Always

Actual Results:

2013-06-20 21:47:42 ERR x[32241]: mserver5: /opt/spinque/MonetDBServer/MonetDB.Spinque_Feb2013/src/sql/backends/monet5/rel_bin.c:2390: rel2bin_project: Assertion `0' failed.
2013-06-20 21:47:42 MSG x[32241]: could not find L2.L2
2013-06-20 21:47:42 MSG x[32241]: s.prob
2013-06-20 21:47:42 MSG x[32241]: d.idstr
2013-06-20 21:47:42 MSG x[32241]: d.id
2013-06-20 21:47:42 MSG x[32241]: d.type
2013-06-20 21:47:42 MSG x[32241]: d.%TID%
2013-06-20 21:47:42 MSG x[32241]: d.%dict_id_pkey
2013-06-20 21:47:42 MSG x[32241]: L1.id
2013-06-20 21:47:42 MSG x[32241]: L1.pid
2013-06-20 21:47:42 MSG x[32241]: L1.class
2013-06-20 21:47:42 MSG x[32241]: L1.xml
2013-06-20 21:47:42 MSG x[32241]: L1.json
2013-06-20 21:47:42 MSG x[32241]: L1.prob

changeset: 47997:918b41d7564d
branch: Feb2013
parent: 47995:223fee7295a2
user: Hannes Muehleisen hannes@cwi.nl
date: Wed Jun 19 15:23:34 2013 +0200
summary: Post release build.

$ mserver5 --version
MonetDB 5 server v11.15.10 (64-bit, 64-bit oids)
This is an unreleased version
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2013 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Found 15.6GiB available memory, 8 available cpu cores
Libraries:
libpcre: 8.31 2012-07-06 (compiled with 8.31)
openssl: OpenSSL 1.0.1e 11 Feb 2013 (compiled with OpenSSL 1.0.1e-fips 11 Feb 2013)
libxml2: 2.9.1 (compiled with 2.9.1)
Compiled by: roberto@photon.spinque.com (x86_64-unknown-linux-gnu)
Compilation: gcc -g -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
Linking : /usr/bin/ld -m elf_x86_64

Comment 18874

Date: 2013-06-20 21:55:48 +0200
From: @swingbit

Created attachment 206
SQL test script

Attached file: MonetDB_BUG3313.sql (application/octet-stream, 13131 bytes)
Description: SQL test script

Comment 18876

Date: 2013-06-22 17:08:30 +0200
From: @njnes

fixed. We use hash tables to speed up the search for expressions. The expression was hashed using the 'old' expression names. Also added the test.

Comment 18879

Date: 2013-06-22 17:48:22 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

fixed bug #3313 and added test

Comment 19208

Date: 2013-09-28 18:36:35 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

test hashed_exp.Bug-3313 requires GEOM support

Comment 20855

Date: 2015-05-08 10:28:53 +0200
From: MonetDB Mercurial Repository <>

Changeset bc8ff45b95d1 made by Foteini Alvanaki foteini.alvanaki@monetdbsolutions.com in the MonetDB repo, refers to this bug.

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

Changeset description:

hashed_exp.Bug-3313 updated