Date: 2019-09-17 17:19:10 +0200
From: WARREN MASTER <<warren.master>>
To: SQL devs <>
Version: 11.33.11 (Apr2019-SP1)
CC: @njnes, @PedroTadim, warren.master, @yzchang

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

Comment 27296

Date: 2019-09-17 17:19:10 +0200
From: WARREN MASTER <<warren.master>>

User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.75 Safari/537.36
Build Identifier:

the following SQL produces error Error: Program contains errors.:(NONE).multiplex

select fundid,sum(fxcurdlttot) as fxcurdlttotfx from actual_positionmart_pfx_all_vw where asofdate='2019-09-11'
and fundid = 10 and currencyexposed <> 'TOTAL'
group by fundid

Removing and currencyexposed <> 'TOTAL' and/or changing <> to = or NOT LIKE
does not trigger the error

Reproducible: Always

Comment 27297

Date: 2019-09-17 17:38:57 +0200
From: @yzchang

Can you please give us the schema of "actual_positionmart_pfx_all_vw" and probably also some sample data? Because I can't reproduce your error with an empty table:

sql>create table actual_positionmart_pfx_all_vw (fundid int, asofdate date, currencyexposed string, fxcurdlttot int);
operation successful
sql>select fundid,sum(fxcurdlttot) as fxcurdlttotfx from actual_positionmart_pfx_all_vw where asofdate='2019-09-11' and fundid = 10 and currencyexposed <> 'TOTAL' group by fundid;
+--------+---------------+
| fundid | fxcurdlttotfx |
+========+===============+
+--------+---------------+
0 tuples

Comment 27298

Date: 2019-09-17 19:20:41 +0200
From: WARREN MASTER <<warren.master>>

Created attachment 634
here is the sql to create the table with the problem

Attached file: trg.sql (text/plain, 257960 bytes)
Description: here is the sql to create the table with the problem

Comment 27299

Date: 2019-09-17 21:06:47 +0200
From: @sjoerdmullender

The problem is the mismatch between the type of currencyexposed and the string it is compared to.
currencyexposed is declared as CHAR(3) and it is compared to the string 'TOTAL' which would be a CHAR(5).
If you change the query to contain, say, 'TOT' instead of 'TOTAL', it works.

This is not saying this is not a bug. This is just saying how you can work around it.

Comment 27300

Date: 2019-09-17 21:33:17 +0200
From: WARREN MASTER <<warren.master>>

thank you, that worked, turns out this table doesn't even have TOTAL as a value.

Comment 27301

Date: 2019-09-18 09:34:14 +0200
From: @sjoerdmullender

(In reply to WARREN MASTER from comment 4)

thank you, that worked, turns out this table doesn't even have TOTAL as a
value.

No, it couldn't. The value doesn't fit.

Comment 27302

Date: 2019-09-18 10:49:57 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

Added test for bug #6761

Comment 27306

Date: 2019-09-20 12:01:59 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

Fix for bug #6761 (.i.e. at MAL code generation, we don't need to convert between string types)

Comment 27318

Date: 2019-09-23 17:55:23 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

Rolling back changes for bug #6761 fix, it breaks many tests. I give up finding a solution for it

Comment 27322

Date: 2019-09-25 12:25:24 +0200
From: MonetDB Mercurial Repository <>

Changeset 1257b1403bce 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=1257b1403bce

Changeset description:

Updated fix for bug #6761 by setting the number of digits for the output statement out of the skipped conversion

Comment 27330

Date: 2019-09-27 14:54:08 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

fix bug #6761, ie don't push the selection bat for convert operators