Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ordered index Error in optimizer garbageCollector #6572

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

ordered index Error in optimizer garbageCollector #6572

monetdb-team opened this issue Nov 30, 2020 · 0 comments

Comments

@monetdb-team
Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

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

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

Comment 26348

Date: 2018-04-07 00:08:50 +0200
From: Anton Kravchenko <<kravchenko.anton86>>

Here is a reproducible example.

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,t2 where trim(t2.v1)=t1.v1)
on commit preserve rows;

  1. --enable-assert=no
    mclient gives "Error in optimizer garbageCollector"
    merver5 gives "could not find t1.%index_t1_v1
    t1.v0
    t1.v1
    t1.%TID%
    t1.v0
    t1.v1
    t1.%TID%"

  2. --enable-assert=yes
    merver5 crashed "could not find t1.%index_t1_v1
    t1.v0
    t1.v1
    t1.%TID%
    t1.v0
    t1.v1
    t1.%TID%
    mserver5: /home/akravchenko/MonetDB-Mar2018/MonetDB-11.29.3/sql/backends/monet5/rel_bin.c:576: exp_bin: Assertion `s' failed.
    Aborted (core dumped)

I am using the latest MonetDB version:
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 )
libxml2: 2.9.1 (compiled with 2.9.1)
Compiled by: mockbuild@ (x86_64-redhat-linux-gnu)
Compilation: gcc -std=gnu99 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic
Linking : /usr/bin/ld -m elf_x86_64 -Wl,-z,relro -Wl,-Bsymbolic-functions

Comment 26353

Date: 2018-04-09 10:46:29 +0200
From: MonetDB Mercurial Repository <>

Changeset 799859bfffd7 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=799859bfffd7

Changeset description:

Added tests for bugs 6572 and 6573

Comment 26356

Date: 2018-04-11 16:20:11 +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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant