Re: UUIDs in MonetDB

On Wed, Sep 30, 2015 at 03:01:31PM +0000, Doug Service wrote:

Yes, that works fine. How is the type supported in mapi? Is it a VarChar(36)? Yes over the wire it should be varchar(36).

Niels

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 wrote:

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

_______________________________________________ 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