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