Date: 2020-07-28 21:07:07 +0200
From: Martin van Dinther <<martin.van.dinther>>
To: SQL devs <>
Version: 11.37.7 (Jun2020)
CC: @PedroTadim

Last updated: 2020-10-19 11:06:21 +0200

Comment 27950

Date: 2020-07-28 21:07:07 +0200
From: Martin van Dinther <<martin.van.dinther>>

User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:78.0) Gecko/20100101 Firefox/78.0
Build Identifier:

Following queries show errors in optimizer multiplex:
select profiler.getlimit();
select wlc.clock();
select wlc.tick();
select wlr.clock();
select wlr.tick();
Expected to get a (default) value returned.

Reproducible: Always

Steps to Reproduce:

select profiler.getlimit();
select wlc.clock();
select wlc.tick();
select wlr.clock();
select wlr.tick();

Actual Results:

sql>select profiler.getlimit();
Error in optimizer multiplex: TypeException:user.s6_0[11]:'profiler.getlimit' undefined in: profiler.getlimit(X_46:int);
sql>select wlc.clock();
Error in optimizer multiplex: TypeException:user.s8_0[10]:'wlc.getclock' undefined in: wlc.getclock(X_45:int);
sql>select wlc.tick();
Error in optimizer multiplex: TypeException:user.s10_0[11]:'wlc.gettick' undefined in: wlc.gettick(X_46:int);
sql>select wlr.clock();
Error in optimizer multiplex: TypeException:user.s12_0[10]:'wlr.getclock' undefined in: wlr.getclock(X_45:int);
sql>select wlr.tick();
Error in optimizer multiplex: TypeException:user.s14_0[11]:'wlr.gettick' undefined in: wlr.gettick(X_46:int);
sql>

Expected Results:

No errors reported but values returned

Comment 28062

Date: 2020-09-10 16:46:41 +0200
From: MonetDB Mercurial Repository <>

Changeset 5b90753397b1 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=5b90753397b1

Changeset description:

Add missing stable out and err files for bug #6939

Comment 28087

Date: 2020-09-15 13:58:42 +0200
From: MonetDB Mercurial Repository <>

Changeset 2de5428c21ec 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=2de5428c21ec

Changeset description:

Fix for bug #6939, ie push left first column only if the cardinality is not atomic, otherwise is not required but the side-effect function will be called only once.

Also updated mvc_get_value and mvc_next_value error messages to pair with the bulk counterparts (This was uncovered while running tests).

Comment 28088

Date: 2020-09-15 14:06:06 +0200
From: MonetDB Mercurial Repository <>

Changeset 0618001bca38 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=0618001bca38

Changeset description:

Queries similar to bug #6939 ending in MAL undefined errors

Comment 28090

Date: 2020-09-16 12:42:08 +0200
From: MonetDB Mercurial Repository <>

Changeset 6814048557bd 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=6814048557bd

Changeset description:

We cannot assume every function with side effects and no arguments have a correspondent with 1 argument. Test for it. The 'rand' function is the exception. This fixes bug #6939

Comment 28112

Date: 2020-09-23 15:23:52 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

Backported bug #6939 fix into Jun2020