Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MAL exeption on SQL query with subquery in the where part #2823

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

MAL exeption on SQL query with subquery in the where part #2823

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
bug Something isn't working major SQL

Comments

@monetdb-team
Copy link

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:

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.

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:

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)

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:

added test for bug #2823

Comment 15992

Date: 2011-07-29 10:52:36 +0200
From: @sjoerdmullender

The Apr2011-SP2 bugfix release is out.

@monetdb-team monetdb-team added bug Something isn't working major SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Nov 9, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working major SQL
Projects
None yet
Development

No branches or pull requests

2 participants