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.