Date: 2019-09-27 12:04:24 +0200
From: @PedroTadim
To: MonetDB5 devs <>
Version: 11.33.11 (Apr2019-SP1)

Last updated: 2019-11-28 10:00:05 +0100

Comment 27329

Date: 2019-09-27 12:04:24 +0200
From: @PedroTadim

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

Running any of the queries will trigger the warnings from the multiplex optimizer.

select s.name, seq.name, next_value_for(s.name, seq.name), seq."minvalue", seq."maxvalue", seq."increment", seq."cycle" from sys.sequences seq, sys.schemas s where s.id = seq.schema_id order by s.name, seq.name;

select s.name, seq.name, get_value_for(s.name, seq.name), seq."minvalue", seq."maxvalue", seq."increment", seq."cycle" from sys.sequences seq, sys.schemas s where s.id = seq.schema_id order by s.name, seq.name;

Reproducible: Always

Comment 27332

Date: 2019-09-30 10:00:51 +0200
From: MonetDB Mercurial Repository <>

Changeset 05cf863829ba 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=05cf863829ba

Changeset description:

Added test for Bug #6766

Comment 27366

Date: 2019-10-18 16:30:04 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

Added final missing bulk get_value and next_value mal calls, thus fixing bug #6766