You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
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
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.
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
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)
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:
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:
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:
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:
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:
The text was updated successfully, but these errors were encountered: