Date: 2018-04-11 00:53:41 +0200
From: Anton Kravchenko <<kravchenko.anton86>>
To: SQL devs <>
Version: 11.29.3 (Mar2018)
CC: @njnes

Last updated: 2018-06-20 11:02:08 +0200

Comment 26355

Date: 2018-04-11 00:53:41 +0200
From: Anton Kravchenko <<kravchenko.anton86>>

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

crash when creating a table from query with ordered index

Reproducible: Always

Steps to Reproduce:

create table t1(v0 int, v1 char(1));
insert into t1 values (1,'a'),(2,'b'),(3,'c');
create ordered index index_t1_v1 on t1(v1);

create table t2(v1 char(1));
insert into t2 values ('a');

create temp table t3 as
(select t1.v0 from t1
where
exists(select * from t2 where t2.v1=t1.v1))
with data on commit preserve rows;

Actual Results:

2018-04-10 15:38:49 ERR db1[31908]: could not find t1.%index_t1_v1
2018-04-10 15:38:49 ERR db1[31908]: t1.v0
2018-04-10 15:38:49 ERR db1[31908]: t1.v1
2018-04-10 15:38:49 ERR db1[31908]: t1.%TID%
2018-04-10 15:38:49 ERR db1[31908]: t1.v0
2018-04-10 15:38:49 ERR db1[31908]: t1.v1
2018-04-10 15:38:49 ERR db1[31908]: t1.%TID%
2018-04-10 15:38:49 ERR db1[31908]: mserver5: /home/akravchenko/MonetDB-Mar2018/MonetDB-11.29.3/sql/backends/monet5/rel_bin.c:576: exp_bin: Assertion `s' failed.
2018-04-10 15:38:52 MSG merovingian[26313]: database 'db1' (31908) has crashed (dumped core)

Expected Results:

It works as expected when no table is created:
select t1.v0 from t1
where
exists(select * from t2 where t2.v1=t1.v1);

MonetDB 5 server v11.29.3 "Mar2018" (64-bit, 128-bit integers)
Copyright (c) 1993 - July 2008 CWI
Copyright (c) August 2008 - 2018 MonetDB B.V., all rights reserved
Visit https://www.monetdb.org/ for further information
Found 31.3GiB available memory, 4 available cpu cores
Libraries:
libpcre: 8.32 2012-11-30 (compiled with 8.32)
openssl: OpenSSL 1.0.2k 26 Jan 2017 (compiled with OpenSSL 1.0.2l 25 May 2017)
libxml2: 2.9.1 (compiled with 2.9.1)
Compiled by: akravchenko@cent7-1 (x86_64-pc-linux-gnu)
Compilation: gcc -std=gnu99 -g
Linking : /usr/bin/ld -m elf_x86_64 -Wl,-Bsymbolic-functions

Comment 26358

Date: 2018-04-11 16:20:15 +0200
From: MonetDB Mercurial Repository <>

Changeset 885e050fdec6 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=885e050fdec6

Changeset description:

fixes for bugs 6572, 6573 and 6574
also fix select -2*50 cast problem, fix type of function in rewriter.

6572/6574 fixed in dead code optimizer

6573 fixed problem in 'IN' handling with constants

Comment 26363

Date: 2018-04-12 10:12:55 +0200
From: MonetDB Mercurial Repository <>

Changeset 780897b729df 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=780897b729df

Changeset description:

Added tests for bugs 6574 and 6576