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
fixed bug #2823 MAL exeption on SQL query with subquery in the where part
We shouldn't have select statements in the semijoin join expression list.
(transplanted from 7ec5c5f4f8c7d73d0c63e801dd7b70429ecbd0a1)
Date: 2011-06-14 18:18:48 +0200
From: Simon Brodt <<simon.brodt>>
To: SQL devs <>
Version: 11.3.3 (Apr2011-SP1) [obsolete]
Last updated: 2011-07-29 10:52:36 +0200
Comment 15847
Date: 2011-06-14 18:18:48 +0200
From: Simon Brodt <<simon.brodt>>
This query throws an MAL exception:
SELECT * FROM (SELECT 0 AS "value") AS row WHERE row.value = (SELECT 0) AND row.value = 0;
TypeException:user.s1_2[15]:'bat.reverse' undefined in: _22:any := bat.reverse(_21:bte)
TypeException:user.s1_2[29]:'algebra.join' undefined in: _38:any := algebra.join(_37:bat[:oid,:void], _22:any)
SQLException:SQLengine:Program contains errors
This equivalent query performs correctly:
SELECT * FROM (SELECT 0 AS "value") AS row WHERE row.value = 0 AND row.value =(SELECT 0);
Comment 15848
Date: 2011-06-17 14:27:53 +0200
From: @njnes
Changeset 7ec5c5f4f8c7 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=7ec5c5f4f8c7
Changeset description:
Comment 15849
Date: 2011-06-17 15:57:32 +0200
From: @njnes
Changeset dbe413ad56aa made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=dbe413ad56aa
Changeset description:
Comment 15850
Date: 2011-06-17 16:00:23 +0200
From: @grobian
You can use tonight's nightly installer to verify the issue has been fixed for you. Thanks!
Comment 15956
Date: 2011-07-17 15:19:15 +0200
From: @drstmane
Changeset 21d0c851f315 made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=21d0c851f315
Changeset description:
Comment 15992
Date: 2011-07-29 10:52:36 +0200
From: @sjoerdmullender
The Apr2011-SP2 bugfix release is out.
The text was updated successfully, but these errors were encountered: