- developers-list - monetdb.org

[Monetdb-developers] select data type to store variable length string
by kss ram 12 Apr '10

12 Apr '10

Hello, Thank you everyone for being supportive! I have a brief query about the data types, according to the documentation http://monetdb.cwi.nl/SQL/Documentation/Data-Types.html, for storing string/char type date, we have following options 1.CHAR[ACTER] (L) - character string with length L 2.VARCHAR (L) | CHARACTER VARYING (L) - string with atmost length L CLOB | CHARACTER LARGE OBJECT BLOB | BINARY LARGE OBJECT DECIMAL(P,S) | NUMERIC(P,S) My question is would CLOB would be the right choice to store variable length/ dynamic string/char data, varchar(L) is out of the picture as i wont know the length of the string. Thank you for your time and help!

2 1

[Monetdb-developers] regarding debug output in query execution
by anshul gangwar 12 Apr '10

12 Apr '10

hello Is there a cluster(column consists of many clusters) based joining. If so than is there different algo used for each cluster also. What is the difference between (b=tmp_2607) and b=tmpr_2610 Is there any big differece between them. And any time real BAT ids of (id given at time of creation) columns are passed to BAT_fetchjoin i.e algos or the bat id passed are only of the clusters. In which file we can find the code where mil code(generated physical plan from pf) code given as input and algo finding process starts Send free SMS to your Friends on Mobile from your Yahoo! Messenger. Download Now! http://messenger.yahoo.com/download.php

2 1

[Monetdb-developers] Fw: regarding debug output in query execution
by anshul gangwar 12 Apr '10

12 Apr '10

Does anybody have any idea about our problem as asked before hello Is there a cluster(column consists of many clusters) based joining. If so than is there different algo used for each cluster also. What is the difference between (b=tmp_2607) and b=tmpr_2610 Is there any big differece between them. And any time real BAT ids of (id given at time of creation) columns are passed to BAT_fetchjoin i.e algos or the bat id passed are only of the clusters. In which file we can find the code where mil code(generated physical plan from pf) code given as input and algo finding process starts Send free SMS to your Friends on Mobile from your Yahoo! Messenger. Download Now! http://messenger.yahoo.com/download.php -----Inline Attachment Follows----- ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev -----Inline Attachment Follows----- _______________________________________________ Monetdb-developers mailing list Monetdb-developers(a)lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers Send free SMS to your Friends on Mobile from your Yahoo! Messenger. Download Now! http://messenger.yahoo.com/download.php

1 0

[Monetdb-developers] regarding monetdb data type
by Tomas Lopez 12 Apr '10

12 Apr '10

Hi, i installed MonetDB server and client. it works fine with console to create table and insert data. but if insert data larger than 512 byte, i can not get the whole data back to excel. can someone tell me what are the things that may be going wrong. thank u.

3 2

[Monetdb-developers] How to get BLOB data from ODBC?
by Xiao Lei 12 Apr '10

12 Apr '10

Hi guys, I tried to insert and get BLOB data from ODBC with Monet. But I always get the error message as, ERROR [07006] [MonetDB][ODBC Driver 1.0]Restricted data type attribute violation Can anyone tell me what's the problem? Thx. -- Best Regards, Xiao Lei

1 0

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB/src/gdk gdk_bat.mx, , 1.241, 1.242
by Niels Nes 11 Apr '10

11 Apr '10

On Sun, Apr 11, 2010 at 11:47:41AM +0200, Sjoerd Mullender wrote: > Should this have been changed on the Feb2010 branch? not sure, the problem of performance problems and leaking hash files was reported on the Head. I'll check the code in stable. Niels > > On 2010-04-11 11:30, Niels Nes wrote: > > Update of /cvsroot/monetdb/MonetDB/src/gdk > > In directory sfp-cvsdas-4.v30.ch3.sourceforge.com:/tmp/cvs-serv4560 > > > > Modified Files: > > gdk_bat.mx > > Log Message: > > make sure we use the correct hash file (use views bat id for hhash/thash) > > > > > > Index: gdk_bat.mx > > =================================================================== > > RCS file: /cvsroot/monetdb/MonetDB/src/gdk/gdk_bat.mx,v > > retrieving revision 1.241 > > retrieving revision 1.242 > > diff -u -d -r1.241 -r1.242 > > --- gdk_bat.mx 22 Feb 2010 10:10:48 -0000 1.241 > > +++ gdk_bat.mx 11 Apr 2010 09:30:13 -0000 1.242 > > @@ -3355,7 +3355,7 @@ > > > > hp->filename = GDKmalloc(strlen(nme) + 12); > > if (hp->filename != NULL) > > - sprintf(hp->filename, "%s.%chash", nme, b->batCacheid > 0 ? 'h' : 't'); > > + sprintf(hp->filename, "%s.%chash", nme, bv->batCacheid > 0 ? 'h' : 't'); > > if (hp->filename == NULL || > > (bv->H->hash = HASHnew(hp, tpe, yy + lim, HASHmask(lim))) == NULL) { > > GDKfree(hp->filename); > > > > > > ------------------------------------------------------------------------------ > > Download Intel® Parallel Studio Eval > > Try the new software tools for yourself. Speed compiling, find bugs > > proactively, and fine-tune applications for parallel performance. > > See why Intel Parallel Studio got high marks during beta. > > http://p.sf.net/sfu/intel-sw-dev > > _______________________________________________ > > Monetdb-checkins mailing list > > Monetdb-checkins(a)lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins > > > -- > Sjoerd Mullender > > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins -- Niels Nes, 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: http://www.cwi.nl/~niels e-mail: Niels.Nes(a)cwi.nl

1 0

Re: [Monetdb-developers] Compiler Mapi.h on windows
by Ken Kao 11 Apr '10

11 Apr '10

Sorry, I confuse it . Mapi.h only includes stdio.h. ( Mapi.c does indeed include more headers.) My version is latest Feb2010-SP1 release of MonetDB. The really problem for me is that I can not Compiler my code on windows after include Mapi.c . There are many headers include in Mapi.c. (ex: monet_utils.h, stream.h, stream_socket.h) I Find them in < MonetDB-1.36.3\src\common > . I try to include them in my code as well. Unfortunately, the first problem is that I have to extended to include unistd.h in stream.h. I have no ideal to sovle it because unistd.h is a linux header. My compiler enviroment is visual studio 2008 . Could you give some guides to create a correct compiler enviroment for Mapi.c ? I does not understand that How can I create a similar build enviroment for my code as MonetDB on Windows .Could you give some suggestion ? I really hope to be able to compile Mapi.c on Windows myself. I also try to use static link to libmapi.dll to achieve my purpose . But I need libmapi.lib can be successfully. If I only have mapi.h and libmapi.dll . Can I successfully complete such a way ? If No. Can I have any way to get libmapi.lib ? I really need it to achieve the second method. Thank you very mch!!

1 0

[Monetdb-developers] help regarding installtion after changes
by anshul gangwar 10 Apr '10

10 Apr '10

hello If the installation fails , how to remove the changes that installation has done. We are doing the changes to file gdk_relop.c and its .mx one and then using supertar ball we are trying to install it. Is it also possible that it doesn't install fully and still say installed successfully as earlier we have installed mserver separately from synaptic manager in ubuntu and it says succesfullly installed Send free SMS to your Friends on Mobile from your Yahoo! Messenger. Download Now! http://messenger.yahoo.com/download.php

3 2

[Monetdb-developers] Mapi query parameter constness
by Isidor Zeuner 09 Apr '10

09 Apr '10

Dear MonetDB developers, as I have been working on interfacing Mapi to C++ in a manner as lightweight as possible, I have noticed that the parameter binding interface does not interface to STL strings as seamlessly as it probably could. Similar considerations might well apply to other C-based string APIs: The STL string API provides accessor functions to the string's char data and its size. To ensure secure programming, the pointer to the char data has to be const. Yet, the Mapi interface for passing string parameters expects a writable char pointer. I'm not sure how future plans for Mapi look like, but currently thsi doesn't seem necessary to me. I have attached a patch to have Mapi treat the data as const, which works well for me. I also noticed that Mapi expects the string size parameter to be passed by reference. Is this necessary? Having an interface which supports pass-by-value would facilitate string API integration even more. Best regards, Isidor

1 0

Re: [Monetdb-developers] [Monetdb-checkins] clients/src Makefile.ag, , 1.17, 1.18
by Stefan Manegold 09 Apr '10

09 Apr '10

On Fri, Apr 09, 2010 at 10:28:06AM +0000, Fabian wrote: > Update of /cvsroot/monetdb/clients/src > In directory sfp-cvsdas-4.v30.ch3.sourceforge.com:/tmp/cvs-serv15735/src > > Modified Files: > Makefile.ag > Log Message: > don't try to compile ODBC if configure already concluded it won't fly, or if the user actually requested it not to be built Am I right that on system where configure is not available (read: Windows), we'll now have to set HAVE_UNIXODBC (provided we do have ODBC) "by hand" to have odbc compiled on such system(s)? Stefan > Index: Makefile.ag > =================================================================== > RCS file: /cvsroot/monetdb/clients/src/Makefile.ag,v > retrieving revision 1.17 > retrieving revision 1.18 > diff -u -d -r1.17 -r1.18 > --- Makefile.ag 7 Jan 2010 15:24:16 -0000 1.17 > +++ Makefile.ag 9 Apr 2010 10:28:04 -0000 1.18 > @@ -15,4 +15,4 @@ > # Copyright August 2008-2010 MonetDB B.V. > # All Rights Reserved. > > -SUBDIRS = mapilib mapiclient odbc HAVE_PERL?perl php HAVE_PYTHON?python HAVE_RUBYGEM?ruby examples HAVE_MAPILITE?mapilite > +SUBDIRS = mapilib mapiclient HAVE_UNIXODBC?odbc HAVE_PERL?perl php HAVE_PYTHON?python HAVE_RUBYGEM?ruby examples HAVE_MAPILITE?mapilite > > > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins > > > > > > > -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |

2 1