Date: 2019-11-04 09:25:16 +0100
From: @PedroTadim
To: SQL devs <>
Version: -- development

Last updated: 2020-01-02 18:04:04 +0100

Comment 27387

Date: 2019-11-04 09:25:16 +0100
From: @PedroTadim

User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.87 Safari/537.36
Build Identifier:

This bug comes from a user into users-list, create a table, then two indexes on column, then an insert, causes the server to crash.

Reproducible: Always

Steps to Reproduce:

1. Create table a(a int, b int, id bigserial);
2. Create ordered index a_pk on a(id);
3. Create index a_idx1 on a(a);
4. Insert into a(a) values(1);

Actual Results:

SIGSEV

Expected Results:

Successful insert.

Comment 27388

Date: 2019-11-04 09:28:40 +0100
From: MonetDB Mercurial Repository <>

Changeset 6fc5137b678d 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=6fc5137b678d

Changeset description:

Added test for bug #6781

Comment 27392

Date: 2019-11-05 17:00:01 +0100
From: MonetDB Mercurial Repository <>

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

Changeset description:

Added fix for bug #6781, ie, don't attempt to insert/update on indexes without delta structures

Comment 27505

Date: 2020-01-02 18:04:04 +0100
From: MonetDB Mercurial Repository <>

Changeset 5a1607486f7c made by Martin van Dinther martin.van.dinther@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=5a1607486f7c

Changeset description:

Extend index-insert-crash.Bug-6781 test also with imprints index, which also has no delta structure.