July 2007 - developers-list

[Monetdb-developers] Query Timeout
by Bharani 18 Jul '07

18 Jul '07

Hi I am trying to make monetdb work with hibernate using existing mysql dialect. When i do a simple select it actually returns the value but i get an exception saying Method not supported,Sorry! for nl.cwi.monetdb.jdbc.MonetStatement.getQueryTimeout any reason why it is being thrown Thanks Bharani -- View this message in context: http://www.nabble.com/Query-Timeout-tf4102673.html#a11666902 Sent from the monetdb-developers mailing list archive at Nabble.com.

2 6

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/tools mserver5.mx.in, , 1.20, 1.21
by Stefan Manegold 17 Jul '07

17 Jul '07

On Tue, Jul 17, 2007 at 04:07:11AM +0000, Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/src/tools > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv10293/tools > > Modified Files: > mserver5.mx.in > Log Message: > My penny to cleanup the welcome message. see my change below. Stefan > Index: mserver5.mx.in > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/tools/mserver5.mx.in,v > retrieving revision 1.20 > retrieving revision 1.21 > diff -u -d -r1.20 -r1.21 > --- mserver5.mx.in 16 Jul 2007 11:51:44 -0000 1.20 > +++ mserver5.mx.in 17 Jul 2007 04:07:07 -0000 1.21 > @@ -174,15 +174,15 @@ > char *msg = mo_find_option(set, setlen, "monet_welcome"); > > if (msg && strcmp(msg, "yes") == 0) { > - printf("# MonetDB Server v" VERSION "\n"); > - printf("# based on GDK v%s\n", GDKversion()); > - printf("# Copyright (c) 1993-2007 CWI, all rights reserved\n"); > + printf("# MonetDB server v" VERSION "\n"); > + printf("# Based on kernel v%s\n", GDKversion()); > + printf("# Database serviced:%s\n", GDKgetenv("gdk_dbname")); ^^ shouldn't there be a space for sake of (human) readability? > printf("# Compiled for %s/" SZFMT "bit with " SZFMT "bit OIDs %s linked\n", HOST, (size_t) (sizeof(ptr) * 8), (size_t) (sizeof(oid) * 8), linkinfo); > #ifdef MONET_GLOBAL_DEBUG > - printf("# config:%s\n", GDKgetenv("config")); > - printf("# dbfarm:%s\n", GDKgetenv("gdk_dbfarm")); > + printf("# Configuration:%s\n", GDKgetenv("config")); ^^ shouldn't there be a space for sake of (human) readability? > + printf("# Database farm:%s\n", GDKgetenv("gdk_dbfarm")); ^^ shouldn't there be a space for sake of (human) readability? > #endif > - printf("# dbname:%s\n", GDKgetenv("gdk_dbname")); > + printf("# Copyright (c) 1993-2007 CWI, all rights reserved\n"); > printf("# Visit http://monetdb.cwi.nl/ for further information\n"); > } > } -- | 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-4312 |

2 2

Re: [Monetdb-developers] [Monetdb-checkins] clients/src/java build.properties, , 1.6, 1.7 build.xml, , 1.20, 1.21 release.txt, , 1.4, 1.5 version.sh, , 1.7, 1.8
by Stefan Manegold 16 Jul '07

16 Jul '07

On Mon, Jul 16, 2007 at 12:16:14PM +0000, Fabian wrote: > Update of /cvsroot/monetdb/clients/src/java > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv18385/src/java > > Modified Files: > build.properties build.xml release.txt version.sh > Log Message: > For ease of maintenance, make jdbcclient a versionless jar-file. > [...] > > Index: version.sh > =================================================================== > RCS file: /cvsroot/monetdb/clients/src/java/version.sh,v > retrieving revision 1.7 > retrieving revision 1.8 > diff -u -d -r1.7 -r1.8 > --- version.sh 16 Jul 2007 10:38:21 -0000 1.7 > +++ version.sh 16 Jul 2007 12:16:08 -0000 1.8 > @@ -113,13 +113,7 @@ > > for file in \ > Makefile.ag \ > - ../../../*/NT/MonetDB4-SQL/MonetDB4-Installer.vdproj \ > - ../../../*/NT/MonetDB5-SQL/MonetDB5-Installer.vdproj \ > - ../../../*/src/jdbc/tests/Tests/Test_JdbcClient.SQL.bat \ > ../../../*/src/jdbc/tests/Tests/Test.SQL.bat \ > - ../../../*/NT/MonetDB-XQuery/MonetDB-XQuery.vdproj \ > - ../../../*/NT/MonetDB4-XQuery/MonetDB4-Installer.vdproj \ ../../../*/NT/MonetDB4-SQL/MonetDB4-Installer.vdproj ../../../*/NT/MonetDB5-SQL/MonetDB5-Installer.vdproj ../../../*/NT/MonetDB-XQuery/MonetDB-XQuery.vdproj ../../../*/NT/MonetDB4-XQuery/MonetDB4-Installer.vdproj still contain "monetdb-1.6-jdbc.jar"; hence, this version number is now no longer maintained by clients/src/java/version.sh ... Stefan > - ../../../*/tests/BugTracker/Tests/JDBC_250_results.SF-1730556.XQUERY.bat \ > ; do > if [[ -f ${file} ]] ; then > for f in $FILES ; do > -- | 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-4312 |

2 1

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/mal mal_box.mx, , 1.78, 1.79
by Sjoerd Mullender 16 Jul '07

16 Jul '07

Fabian wrote: > Update of /cvsroot/monetdb/MonetDB5/src/mal > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv12770/mal > > Modified Files: > mal_box.mx > Log Message: > insertToBox copies its 2nd and 3rd arguments, so it can declare them as > const. Nevertheless we still need a cast, because char * != str. > > > Index: mal_box.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/mal/mal_box.mx,v > retrieving revision 1.78 > retrieving revision 1.79 > diff -u -d -r1.78 -r1.79 > --- mal_box.mx 12 Jun 2007 17:21:17 -0000 1.78 > +++ mal_box.mx 16 Jul 2007 12:45:25 -0000 1.79 > @@ -226,7 +226,7 @@ > mal_export int releaseAllBox(Box box); > > mal_export int depositBox(Box box, str name, ValPtr val); > -mal_export void insertToBox(Box box, str name, str val); > +mal_export void insertToBox(Box box, const str name, const str val); > mal_export int takeBox(Box box, str name, ValPtr val, int tpe); > mal_export int bindBAT(Box box, str name, str location); > mal_export int releaseBox(Box box, str name); > @@ -418,7 +418,7 @@ > } > > void > -insertToBox(Box box, str nme, str val) > +insertToBox(Box box, const str nme, const str val) > { > ValRecord vr; > > > This is actually pretty useless. You've declared val as a const, not what val point to (i.e. the chars that make up the string). Consider this: typedef char *str; void foo(const str x) { *x = 0; } this is valid code and will be accepted by both gcc and icc, but this is exactly what you try to prevent from happening when you declare a parameter const char *. In other words, val should be declared as const char *val, and then you shouldn't need the case when calling the function. -- Sjoerd Mullender

2 2

Re: [Monetdb-developers] [Monetdb-checkins] clients/src/java build.properties, , 1.5, 1.6 build.xml, , 1.19, 1.20 release.txt, , 1.3, 1.4 version.sh, , 1.5, 1.6
by Stefan Manegold 16 Jul '07

16 Jul '07

On Mon, Jul 16, 2007 at 09:42:16AM +0000, Fabian wrote: > Update of /cvsroot/monetdb/clients/src/java > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv5504 > > Modified Files: > build.properties build.xml release.txt version.sh > Log Message: > Fix for bug #1754452 > Store the given connection in the SendThread instead of ignoring it. > > Since we changed the code after the release, tag the version suffix > [...] > Index: version.sh > =================================================================== > RCS file: /cvsroot/monetdb/clients/src/java/version.sh,v > retrieving revision 1.5 > retrieving revision 1.6 > diff -u -d -r1.5 -r1.6 > --- version.sh 6 Jun 2007 12:00:55 -0000 1.5 > +++ version.sh 16 Jul 2007 09:42:12 -0000 1.6 > @@ -106,10 +106,13 @@ > > file="release.txt" > sed \ > - -e "s|version ${ESC_MAJOR}\.${ESC_MINOR} (${ESC_SUFFIX})|version ${NEW_MAJOR}.${NEW_MINOR} $${NEW_SUFFIX}$|g" \ > + -e "s|version ${ESC_MAJOR}\.${ESC_MINOR} (${ESC_SUFFIX}|version ${NEW_MAJOR}.${NEW_MINOR} \(${NEW_SUFFIX}|g" \ > + -e "s|${TYPE}-${ESC_MAJOR}\.${ESC_MINOR}|${TYPE}-${NEW_MAJOR}.${NEW_MINOR}|g" \ > -e "s|Release date: 20[0-9][0-9]-[01][0-9]-[0-3][0-9]|Release date: `date +%F`|" \ > ${file} | ${diff} ${file} - | ${patch} > > +# not found: > +# ../../../*/tests/BugTracker/Tests/JDBC_250_results.SF-1730556.XQUERY.bat \ ======== $ l */tests/BugTracker/Tests/JDBC_250_results.SF-1730556.XQUERY.bat -------- -rwxr-x--- 1 manegold ins1 376 Jun 6 14:16 pathfinder/tests/BugTracker/Tests/JDBC_250_results.SF-1730556.XQUERY.bat* ======== $ cat */tests/BugTracker/Tests/JDBC_250_results.SF-1730556.XQUERY.bat -------- @echo off set JAR="%CLIENTS_PREFIX%\share\MonetDB\lib\jdbcclient-1.6.jar" echo user=monetdb> .monetdb echo password=monetdb>> .monetdb set LANG=en_US.UTF-8 call Mlog.bat -x java -jar "%JAR%" -h %HOST% -p %MAPIPORT% -d %TSTDB% -l xquery -f "%TST%.250.xq" call Mlog.bat -x java -jar "%JAR%" -h %HOST% -p %MAPIPORT% -d %TSTDB% -l xquery -f "%TST%.251.xq" del .monetdb ======== maybe, we should find some way to use the "latest" jdbcclient.jar on both unix and windows platforms without knowing the exact version number ... Stefan > for file in \ > Makefile.ag \ > ../../../*/NT/MonetDB4-SQL/MonetDB4-Installer.vdproj \ > @@ -118,7 +121,6 @@ > ../../../*/src/jdbc/tests/Tests/Test.SQL.bat \ > ../../../*/NT/MonetDB-XQuery/MonetDB-XQuery.vdproj \ > ../../../*/NT/MonetDB4-XQuery/MonetDB4-Installer.vdproj \ > - ../../../*/tests/BugTracker/Tests/JDBC_250_results.SF-1730556.XQUERY.bat \ > ; do > if [[ -f ${file} ]] ; then > for f in $FILES ; do > @@ -138,5 +140,4 @@ > -e "s|${TYPE}_MAJOR=${ESC_MAJOR}|${TYPE}_MAJOR=${NEW_MAJOR}|g" \ > -e "s|${TYPE}_MINOR=${ESC_MINOR}|${TYPE}_MINOR=${NEW_MINOR}|g" \ > -e "s|${TYPE}_VER_SUFFIX=${ESC_SUFFIX}|${TYPE}_VER_SUFFIX=${NEW_SUFFIX}|g" \ > - -e "s|${TYPE}-${ESC_MAJOR}\.${ESC_MINOR}|${TYPE}-${NEW_MAJOR}.${NEW_MINOR}|g" \ > ${file} | ${diff} ${file} - | ${patch} > [...] -- | 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-4312 |

1 0

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB/src/gdk gdk.mx, , 1.234, 1.235 gdk_value.mx, , 1.37, 1.38
by Stefan Manegold 16 Jul '07

16 Jul '07

On Mon, Jul 16, 2007 at 07:20:22AM +0000, Fabian wrote: > Update of /cvsroot/monetdb/MonetDB/src/gdk > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv19433 > > Modified Files: > gdk.mx gdk_value.mx > Log Message: > Added GDKversion function. I do not know what the best place for the > implementation is, so I just chose a file. what about gdk_utils.mx ? seems more intuitive tham gdk_value.mx to me ... > Putting it in gdk.mx itself does not seem to work. (symbol not exported) gdk.mx only contains the gdk.h header file (cf., `grep '^@[a-z]$' MonetDB/src/gdk/gdk.mx`). Stefan > > > Index: gdk.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB/src/gdk/gdk.mx,v > retrieving revision 1.234 > retrieving revision 1.235 > diff -u -d -r1.234 -r1.235 > --- gdk.mx 9 Jul 2007 08:36:32 -0000 1.234 > +++ gdk.mx 16 Jul 2007 07:20:18 -0000 1.235 > @@ -1612,7 +1612,6 @@ > gdk_export int GDKsave(str nme, str ext, void *buf, size_t size, int mode); > gdk_export int GDKunlink(str dir, str nme, str extension); > gdk_export int GDKmove(str dir1, str nme1, str ext1, str dir2, str nme2, str ext2); > - > @ > @} > > @@ -3275,6 +3274,16 @@ > @ > > @h > +#ifdef __cplusplus > +extern "C" { > +#endif > + > +gdk_export char *GDKversion(); > + > +#ifdef __cplusplus > +} > +#endif > + > @{ > #define ILLEGALVALUE ((ptr)-1L) > #define MAXPARAMS 32 > > Index: gdk_value.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB/src/gdk/gdk_value.mx,v > retrieving revision 1.37 > retrieving revision 1.38 > diff -u -d -r1.37 -r1.38 > --- gdk_value.mx 2 May 2007 16:17:06 -0000 1.37 > +++ gdk_value.mx 16 Jul 2007 07:20:19 -0000 1.38 > @@ -697,5 +697,11 @@ > return p == ILLEGALVALUE ? p : VALptr(t); > } > > + > +static char *_gdk_version_string = VERSION; > +char *GDKversion() { > + return(_gdk_version_string); > +} > + > @} > @ > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > 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-4312 |

2 1

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/backends/monet4 sql_server.mx, , 1.169, 1.170
by Stefan Manegold 14 Jul '07

14 Jul '07

Ok, before we start changing these things back and forth: Anyone else who has an opinion on how M4 (server), M5 (server), SQL4, SQL5, XQuery(4) should reveal their version numbers at startup-/module-loading time, and whether the differences between M4 & M5 should/need to be increased by having different/non-aligned/"inconsistend" welcome messages? Stefan On Sat, Jul 14, 2007 at 08:49:25AM +0200, Fabian Groffen wrote: > On 13-07-2007 21:33:50 +0000, Stefan Manegold wrote: > > Update of /cvsroot/monetdb/sql/src/backends/monet4 > > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv15825/sql/src/backends/monet4 > > > > Modified Files: > > sql_server.mx > > Log Message: > > > > I do not argue about the exact wording, > > but let's at least (try to) keep it aligned/consistent > > Can you please undo this commit? On purpose I do NOT want it to be > aligned, because I want to see a clear distinction between MonetDB 5 and > MonetDB 4. I'd like it when M4 would annouce itself as MonetDB Database > Server for that same reason. (i.e. reverting that earlier commit as > well) > > There is absolutely no need to make it harder to see what engine you're > dealing with. MonetDB 5 should and must (IMO) look different, newer, > better and more advanced. (Because it is.) > > So please, don't align M4 with M5. > > > > Index: sql_server.mx > > =================================================================== > > RCS file: /cvsroot/monetdb/sql/src/backends/monet4/sql_server.mx,v > > retrieving revision 1.169 > > retrieving revision 1.170 > > diff -u -d -r1.169 -r1.170 > > --- sql_server.mx 13 Jul 2007 15:35:58 -0000 1.169 > > +++ sql_server.mx 13 Jul 2007 21:33:48 -0000 1.170 > > @@ -1579,5 +1579,4 @@ > > > > sql_server_start(); > > if (monet_environment.find("monet_welcome") = "yes") > > - printf("%c MonetDB/SQL Server v2.19.0 on port %s\n", > > - int(35), monet_environment.find("mapi_port")); > > + printf("%c MonetDB/SQL module v2.19.0 loaded\n", int(35)); > > > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by DB2 Express > > Download DB2 Express C - the FREE version of DB2 express and take > > control of your XML. No limits. Just data. Click to get it now. > > http://sourceforge.net/powerbar/db2/ > > _______________________________________________ > > Monetdb-sql-checkins mailing list > > Monetdb-sql-checkins(a)lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Monetdb-sql-checkins mailing list > Monetdb-sql-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-sql-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-4312 |

3 4

[Monetdb-developers] Q: pathfinder - cdata
by Arjen P. de Vries 13 Jul '07

13 Jul '07

While <a /> is accepted as a query, <![CDATA[<]]> is not. !parse error: syntax error, unexpected <![CDATA[ on line 1, column 9 (next token is `<![CDATA[') !parse error: XQuery parsing failed Is that the expected behaviour? Context: I try to output email addresses as "test <test(a)my.org>" and failing Arjen -- ==================================================================== CWI, room C1.16 Centre for Mathematics and Computer Science Kruislaan 413 Email: Arjen.de.Vries(a)cwi.nl 1098 SJ Amsterdam tel: +31-(0)20-5924306 The Netherlands fax: +31-(0)20-5924312 ===================== http://www.cwi.nl/~arjen/ ====================

3 5

[Monetdb-developers] [M5] RFC: function shipping semantics
by Fabian Groffen 13 Jul '07

13 Jul '07

Hi all, I'd like some input on an issue that I can't get a clear vision on for now. Recently I added the remote module in MonetDB 5 which basically has 3 functions which perform actions with a remote (MonetDB 5) server. The functions get, put and exec retrieve, store and execute an object from, to or on a remote host. get and put allow for retrieval and storage of basically any type, scalars, strings, BATs, etc. exec only executes functions available on the remote host. The idea is to have one to "put()" a function to the remote host, and then execute it, retrieving its return value. exec is currently implemented that way, however, get and put of functions is not because it is unclear to me how this should exactly happen. For the case of put() I can think of the following which seems quite intuitive and ok to me: function user.func(v:int):str; r := "something"; return(r); end func; m := remote.put("host", "user.func(:int):str"); t := 5; q := remote.exec("host", m, t); io.print(q); The example puts function func to the remote host and executes it with argument t which is 5. The return string kept in q will contain the string "something". Because the identifier of the function on the remote host is returned and assigned to m, the function can easily be executed, since exec requires the function name as string. Currently that function name is just the function without its signature. The signature (which is not required, even not desired currently) can be deduced from the arguments given, resulting in a normal function resolution and (slightly misleading) error reporting if that fails. The other way around (thus to get a remote function) is still unclear to me how to do it. I could imagine the following that should work: v := remote.get("host", m); w := remote.get("host", "user.func(:int):str"); Problem with v is that m is not a full signature, so a conflict may arise if m is overloaded. This is not necessarily a problem, since m is a unique identifier, so no overloading for it exists. However, it is a requirement that a get after a put should always succeed and result in the same object that was put. The bigger problem here, however, is how to deal with the function being get. Since a function cannot be stored in a variable in MAL, it has to be stored on the local machine, or its contents as a string returned. In the first case the get() function would return its local identifier. In the latter case it would return a (big) string. In both cases, the function cannot be "used" as function in the program. A variable containing a function name cannot be used as in e.g.: k := v(t); where v, a variable, would be used as function, "dereferencing" v's value or something. Of course with a human factor one can do: io.print(v); and use the value of v to construct a call to the locally stored function. In the case of a string, the function has to be made, which I don't know how to do that, but would give explicit control over its name to the program. I don't think the concept of eval is clearing up things, as well as possible at all (if you think about the k := statement where only v should be expanded, not t neither k). Ideas?

3 3

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/modules/mal/Tests remote00.mal, , 1.3, 1.4 remote00.stable.out, , 1.4, 1.5
by Martin Kersten 10 Jul '07

10 Jul '07

Fabian wrote: > Update of /cvsroot/monetdb/MonetDB5/src/modules/mal/Tests > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv4482/Tests > > Modified Files: > remote00.mal remote00.stable.out > Log Message: > Be a little bit smarter when dealing with functions. Allow dotted > notation for <module>.<func> next to just <func> for the default/current > module. (currently I guess this is "user", but should be retrieved > somehow to be on the safe site...) Yes, the default is the user module. I have been 'struggling' with arguments for reflective functions. I settled down to using two arguments where needed e.g. f(mod:str,fcn:str,...) It is not optimal, but avoid string construction/analysis

3 5