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
function
sys.isauuid(str) return boolean
can be used to test whether the string argument represents a valid UUID string.
However it reports a GDK error if the str argument is not a valid UUID string!
Expected to return false instead of an error as it is a test function, similar to sys.isaurl(str).
Reproducible: Always
Steps to Reproduce:
-- examples which return errors, but should have returned false
select isauuid('this is not a uuid');
-- returns: GDK reported error: Syntax error in UUID. expected false
select isauuid('');
-- returns: GDK reported error: Syntax error in UUID. expected false
select isauuid(4);
-- returns: GDK reported error: Syntax error in UUID. expected false
select isauuid('XYZaee1a538-aca1-381b-d9f4-8c29ef3f5');
-- returns: GDK reported error: Syntax error in UUID. expected false
-- some tests which return correct output
select isauuid(uuid());
-- returns true
select isauuid('aee1a538-aca1-381b-d9f4-8c29ef3f5f34');
-- returns true
select isauuid('AEE1A538-ACA1-381B-D9F4-8C29EF3F5F34');
-- returns true
select isauuid(null);
-- returns false
select cast('aee1a538-aca1-381b-d9f4-8c29ef3f5f34' as uuid);
select cast('AEE1A538-ACA1-381B-D9F4-8C29EF3F5F34' as uuid);
-- test which correctly returns an error
select cast('XYZaee1a538-aca1-381b-d9f4-8c29ef3f5' as uuid);
-- returns: Not a UUID
Actual Results:
sql>-- examples which return errors, but should have returned false
sql>select isauuid('this is not a uuid');
GDK reported error: Syntax error in UUID.
sql>-- returns: GDK reported error: Syntax error in UUID. expected false
sql>select isauuid('');
GDK reported error: Syntax error in UUID.
sql>-- returns: GDK reported error: Syntax error in UUID. expected false
sql>select isauuid(4);
GDK reported error: Syntax error in UUID.
sql>-- returns: GDK reported error: Syntax error in UUID. expected false
sql>select isauuid('XYZaee1a538-aca1-381b-d9f4-8c29ef3f5');
GDK reported error: Syntax error in UUID.
sql>-- returns: GDK reported error: Syntax error in UUID. expected false
sql>
sql>-- some tests which return correct output
sql>select isauuid(uuid());
+-------+
| L2 |
+=======+
| true |
+-------+
1 tuple
sql>-- returns true
sql>select isauuid('aee1a538-aca1-381b-d9f4-8c29ef3f5f34');
+-------+
| L2 |
+=======+
| true |
+-------+
1 tuple
sql>-- returns true
sql>select isauuid('AEE1A538-ACA1-381B-D9F4-8C29EF3F5F34');
+-------+
| L2 |
+=======+
| true |
+-------+
1 tuple
sql>-- returns true
sql>select isauuid(null);
+-------+
| L2 |
+=======+
| false |
+-------+
1 tuple
sql>-- returns false
sql>select cast('aee1a538-aca1-381b-d9f4-8c29ef3f5f34' as uuid);
+--------------------------------------+
| L2 |
+======================================+
| aee1a538-aca1-381b-d9f4-8c29ef3f5f34 |
+--------------------------------------+
1 tuple
sql>select cast('AEE1A538-ACA1-381B-D9F4-8C29EF3F5F34' as uuid);
+--------------------------------------+
| L2 |
+======================================+
| aee1a538-aca1-381b-d9f4-8c29ef3f5f34 |
+--------------------------------------+
1 tuple
sql>
sql>-- test which correctly returns an error
sql>select cast('XYZaee1a538-aca1-381b-d9f4-8c29ef3f5' as uuid);
Not a UUID
sql>-- returns: Not a UUID
sql>
Expected Results:
first 4 queries should have returned "false" instead of "GDK reported error: Syntax error in UUID."
Date: 2019-11-06 16:48:41 +0100
From: Martin van Dinther <<martin.van.dinther>>
To: SQL devs <>
Version: 11.33.3 (Apr2019)
CC: @kutsurak
Last updated: 2019-11-28 10:00:05 +0100
Comment 27397
Date: 2019-11-06 16:48:41 +0100
From: Martin van Dinther <<martin.van.dinther>>
User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:69.0) Gecko/20100101 Firefox/69.0
Build Identifier:
function
sys.isauuid(str) return boolean
can be used to test whether the string argument represents a valid UUID string.
However it reports a GDK error if the str argument is not a valid UUID string!
Expected to return false instead of an error as it is a test function, similar to sys.isaurl(str).
Reproducible: Always
Steps to Reproduce:
-- examples which return errors, but should have returned false
select isauuid('this is not a uuid');
-- returns: GDK reported error: Syntax error in UUID. expected false
select isauuid('');
-- returns: GDK reported error: Syntax error in UUID. expected false
select isauuid(4);
-- returns: GDK reported error: Syntax error in UUID. expected false
select isauuid('XYZaee1a538-aca1-381b-d9f4-8c29ef3f5');
-- returns: GDK reported error: Syntax error in UUID. expected false
-- some tests which return correct output
select isauuid(uuid());
-- returns true
select isauuid('aee1a538-aca1-381b-d9f4-8c29ef3f5f34');
-- returns true
select isauuid('AEE1A538-ACA1-381B-D9F4-8C29EF3F5F34');
-- returns true
select isauuid(null);
-- returns false
select cast('aee1a538-aca1-381b-d9f4-8c29ef3f5f34' as uuid);
select cast('AEE1A538-ACA1-381B-D9F4-8C29EF3F5F34' as uuid);
-- test which correctly returns an error
select cast('XYZaee1a538-aca1-381b-d9f4-8c29ef3f5' as uuid);
-- returns: Not a UUID
Actual Results:
sql>-- examples which return errors, but should have returned false
sql>select isauuid('this is not a uuid');
GDK reported error: Syntax error in UUID.
sql>-- returns: GDK reported error: Syntax error in UUID. expected false
sql>select isauuid('');
GDK reported error: Syntax error in UUID.
sql>-- returns: GDK reported error: Syntax error in UUID. expected false
sql>select isauuid(4);
GDK reported error: Syntax error in UUID.
sql>-- returns: GDK reported error: Syntax error in UUID. expected false
sql>select isauuid('XYZaee1a538-aca1-381b-d9f4-8c29ef3f5');
GDK reported error: Syntax error in UUID.
sql>-- returns: GDK reported error: Syntax error in UUID. expected false
sql>
sql>-- some tests which return correct output
sql>select isauuid(uuid());
+-------+
| L2 |
+=======+
| true |
+-------+
1 tuple
sql>-- returns true
sql>select isauuid('aee1a538-aca1-381b-d9f4-8c29ef3f5f34');
+-------+
| L2 |
+=======+
| true |
+-------+
1 tuple
sql>-- returns true
sql>select isauuid('AEE1A538-ACA1-381B-D9F4-8C29EF3F5F34');
+-------+
| L2 |
+=======+
| true |
+-------+
1 tuple
sql>-- returns true
sql>select isauuid(null);
+-------+
| L2 |
+=======+
| false |
+-------+
1 tuple
sql>-- returns false
sql>select cast('aee1a538-aca1-381b-d9f4-8c29ef3f5f34' as uuid);
+--------------------------------------+
| L2 |
+======================================+
| aee1a538-aca1-381b-d9f4-8c29ef3f5f34 |
+--------------------------------------+
1 tuple
sql>select cast('AEE1A538-ACA1-381B-D9F4-8C29EF3F5F34' as uuid);
+--------------------------------------+
| L2 |
+======================================+
| aee1a538-aca1-381b-d9f4-8c29ef3f5f34 |
+--------------------------------------+
1 tuple
sql>
sql>-- test which correctly returns an error
sql>select cast('XYZaee1a538-aca1-381b-d9f4-8c29ef3f5' as uuid);
Not a UUID
sql>-- returns: Not a UUID
sql>
Expected Results:
first 4 queries should have returned "false" instead of "GDK reported error: Syntax error in UUID."
Comment 27405
Date: 2019-11-12 13:20:15 +0100
From: MonetDB Mercurial Repository <>
Changeset ed5e115fce8c made by Panagiotis Koutsourakis kutsurak@monetdbsolutions.com in the MonetDB repo, refers to this bug.
For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=ed5e115fce8c
Changeset description:
Comment 27406
Date: 2019-11-12 13:20:19 +0100
From: MonetDB Mercurial Repository <>
Changeset 0f82f07884db made by Panagiotis Koutsourakis kutsurak@monetdbsolutions.com in the MonetDB repo, refers to this bug.
For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=0f82f07884db
Changeset description:
The text was updated successfully, but these errors were encountered: