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
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
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
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:
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:
The text was updated successfully, but these errors were encountered: