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

Certains comparisons between UUID produce a MAL error #3827

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

Certains comparisons between UUID produce a MAL error #3827

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

Comments

@monetdb-team
Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

Date: 2015-10-20 15:46:49 +0200
From: Frédéric Jolliton <<frederic.jolliton+monetdb>>
To: SQL devs <>
Version: 11.21.5 (Jul2015)

Last updated: 2015-11-03 10:18:23 +0100

Comment 21358

Date: 2015-10-20 15:46:49 +0200
From: Frédéric Jolliton <<frederic.jolliton+monetdb>>

User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:40.0) Gecko/20100101 Firefox/40.0
Build Identifier:

It seems that only equality is implemented on UUID.

We were trying to do:

 SELECT * FROM some_table WHERE uuid_a <> uuid_b;

But we get:

 TypeException:user.s19_1[17]:'calc.!=' undefined in:     calc.!=(X_797:uuid,X_799:uuid);
 program contains errors

We were expecting either an SQL error, or the test to be available.

While the following query is working fine:

 SELECT * FROM some_table WHERE uuid_a = uuid_b;

unfortunately, we can't use that to workaround the limitation by doing:

 SELECT * FROM some_table WHERE NOT (uuid_a = uuid_b);

because the optimization pass translate that to the query shown at the beginning.

We found an ugly workaround:

 SELECT * FROM some_table WHERE NOT (uuid_a = uuid_b AND TRUE);

(Likewise for other comparison such as < or <=, but that doesn't make sense anyway on UUID, so not a problem per se.)

Reproducible: Always

Comment 21359

Date: 2015-10-21 10:14:46 +0200
From: MonetDB Mercurial Repository <>

Changeset cba5bc5237d6 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=cba5bc5237d6

Changeset description:

Added comparison functions for UUID type.
This fixes bug #3827.

Comment 21441

Date: 2015-11-03 10:18:23 +0100
From: @sjoerdmullender

Jul2015 SP1 has been released.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant