Yes, that works fine.
How is the type supported in mapi? Is it a VarChar(36)?
Installed version information is at the end.
Doug
sql>select sys.uuid();
+----------------------------------------------------------------------------------------------------------------------+
|
uuid
|
+======================================================================================================================+
|
772fd36b-f7d2-48cf-aaac-31261fd8ef46
|
+----------------------------------------------------------------------------------------------------------------------+
1 tuple (0.726ms)
sql>select sys.uuid();
+----------------------------------------------------------------------------------------------------------------------+
|
uuid
|
+======================================================================================================================+
|
5e2ae37b-8bd8-48ac-b35b-fc96fe760931
|
+----------------------------------------------------------------------------------------------------------------------+
1 tuple (0.774ms)
sql>
Versions Installed
ii libmonetdb-client-dev 11.21.5
amd64 MonetDB client/server interface library development files
ii libmonetdb-client7 11.21.5
amd64 MonetDB client/server interface library
ii libmonetdb-stream6 11.19.15-20150603
amd64 MonetDB stream library
ii libmonetdb-stream7 11.21.5
amd64 MonetDB stream library
ii libmonetdb11 11.19.15-20150603
amd64 MonetDB core library
ii libmonetdb12 11.21.5
amd64 MonetDB core library
ii monetdb-client 11.21.5
amd64 MonetDB database client
ii monetdb-client-tools 11.21.5
amd64 MonetDB database client
ii monetdb5-server 11.21.5
amd64 MonetDB database server version 5
ii monetdb5-server-hugeint 11.21.5
amd64 MonetDB - 128-bit integer support for MonetDB5-server
ii monetdb5-sql 11.21.5
amd64 MonetDB SQL support for monetdb5
On Wed, Sep 30, 2015 at 2:38 PM, Niels Nes
On Wed, Sep 30, 2015 at 02:26:40PM +0000, Doug Service wrote:
The documentation at https://www.monetdb.org/Documentation/Manuals/ SQLreference/UUItype indicates that a UUID type is supported in MonetDB and gives the example
select uuid(); +--------------------------------------+ | uuid | +======================================+ | 65950c76-a2f6-4543-660a-b849cf5f2453 | +--------------------------------------+
which appears to output from mclient. When I try the same with mclient I receive
auto commit mode: on sql>select uuid(); SELECT: no such operator 'uuid' This works fine in the default and stable versions. Maybe your in the wrong schema, ie does select sys.uuid(); work?
Niels
mapi.h only shows support for the following types
#define MAPI_AUTO 0 /* automatic type detection */ #define MAPI_TINY 1 #define MAPI_UTINY 2 #define MAPI_SHORT 3 #define MAPI_USHORT 4 #define MAPI_INT 5 #define MAPI_UINT 6 #define MAPI_LONG 7 #define MAPI_ULONG 8 #define MAPI_LONGLONG 9 #define MAPI_ULONGLONG 10 #define MAPI_CHAR 11 #define MAPI_VARCHAR 12 #define MAPI_FLOAT 13 #define MAPI_DOUBLE 14 #define MAPI_DATE 15 #define MAPI_TIME 16 #define MAPI_DATETIME 17 #define MAPI_NUMERIC 18
Is it possible to get MonetDB to generate UUIDs and how is the type supported in mapi.
Thanks
Doug Service
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: https://www.cwi.nl/people/niels e-mail: Niels.Nes@cwi.nl _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list