August 2007 - developers-list

[Monetdb-developers] SQL Stable branch is closed: it is being prepared for bug-fix release
by Sjoerd Mullender 21 Aug '07

21 Aug '07

From today, the Stable branch of sql is closed for all checkins unless approved by myself or Stefan. We are going to prepare a bug-fix release. Note that the development branch (HEAD branch) is open for normal business. -- Sjoerd Mullender

2 1

[Monetdb-developers] Pathfinder installation error
by Chantola Kit 21 Aug '07

21 Aug '07

Dear MonetDBs: I have problem of installing pathfinder. Even though I try to install all MonetDBs such as MonetDB, MonetDB-client, MonetDB4-server, MonetDB5-server, MonetDB-SQL, I cannot install MonetDB4-XQuery. Every time, I use command "make" for Pathfinder, I got some errors which unable me to install Pathfinder as follow: grep: /home/sjoerd/Monet-Stable/lib/libbat.la: No such file or directory /bin/sed: can't read /home/sjoerd/Monet-Stable/lib/libbat.la: No such file or directory libtool: link: `/home/sjoerd/Monet-Stable/lib/libbat.la' is not a valid libtool archive make[4]: *** [lib_pf_support.la] Error 1 make[4]: Leaving directory `/root/Desktop/MonetDBInstall/runtime' make[3]: *** [all-recursive] Error 1 make[3]: Leaving directory `/root/Desktop/MonetDBInstall/runtime' make[2]: *** [all] Error 2 make[2]: Leaving directory `/root/Desktop/MonetDBInstall/runtime' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/root/Desktop/MonetDBInstall' make: *** [all] Error 2 I am looking forward to hearing from you. Best regards, Tola -- Department of Computer Science Graduate School of Systems and Information Engineering University of Tsukuba Ibaraki, Tsukuba city, Japan

2 4

[Monetdb-developers] Installation problem
by Chantola Kit 17 Aug '07

17 Aug '07

Dear monetdb developers: I try to install MonetDB many times on Fedora7 using MonetDB-Mars-SuperBall, but I have the same problem which unables me to connect to server. 1. When I go to Mserver it was: [root@localhost ~]# Mserver # Monet Database Server V4.18.0 # Copyright (c) 1993-2007, CWI. All rights reserved. # Compiled for i686-redhat-linux-gnu/32bit with 32bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. MonetDB> But, then, I open MapiClient, there is an error like below: [root@localhost ~]# MapiClient -q MAPI = monetdb@localhost:50000 ACTION= mapi_start_talking ERROR = !MALException:setScenario:Scenario 'mil' not initialized 2. When I go to mserver5, it was: MonetDB>[root@localhost ~]# mserver5 # MonetDB Server v5.0.0 # Copyright (c) 1993-2007 CWI, all rights reserved # Compiled for i686-redhat-linux-gnu/32bit with 32bit OIDs dynamically linked # dbname:demo # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /usr/local/etc/monetdb5.conf) > Then, I open MapiClient: [root@localhost ~]# MapiClient -q MAPI = monetdb@localhost:50000 ACTION= mapi_start_talking ERROR = !MALException:setScenario:Scenario 'mil' not initialized [root@localhost ~]# Could you help me to solve the problems? I am looking forward to hearing from you. Tola -- Department of Computer Science Graduate School of Systems and Information Engineering University of Tsukuba Ibaraki, Tsukuba city, Japan

3 3

Re: [Monetdb-developers] [Monetdb-checkins] clients/src/mapiclient MapiClient.mx, , 1.54, 1.55
by Fabian Groffen 16 Aug '07

16 Aug '07

On 16-08-2007 18:49:48 +0000, Martin Kersten wrote: > Update of /cvsroot/monetdb/clients/src/mapiclient > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv14690 > > Modified Files: > MapiClient.mx > Log Message: > > > Index: MapiClient.mx This commit looks pretty dangerous. Can you elaborate/explain?

2 1

Re: [Monetdb-developers] [Monetdb-checkins] clients/src/java/scripts Makefile.ag, Clients_1-18, 1.3, 1.3.6.1 mjclient.bat.in, Clients_1-18, 1.1, 1.1.6.1 mjclient.in, Clients_1-18, 1.3, 1.3.6.1
by Sjoerd Mullender 16 Aug '07

16 Aug '07

Fabian wrote: > Update of /cvsroot/monetdb/clients/src/java/scripts > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv31067/scripts > > Modified Files: > Tag: Clients_1-18 > Makefile.ag mjclient.bat.in mjclient.in > Log Message: > Merged HEAD into Clients_1-18 These checkins look like *incompatible* changes to the stable branch. That is not allowed. The whole idea of the stable branch is that you don't have to worry about changes, you can just use the old code with the new version. If you change the name of a file, you can't do that. > > Index: mjclient.bat.in > =================================================================== > RCS file: /cvsroot/monetdb/clients/src/java/scripts/mjclient.bat.in,v > retrieving revision 1.1 > retrieving revision 1.1.6.1 > diff -u -d -r1.1 -r1.1.6.1 > --- mjclient.bat.in 8 Jan 2007 14:03:39 -0000 1.1 > +++ mjclient.bat.in 16 Aug 2007 10:52:44 -0000 1.1.6.1 > @@ -21,4 +21,4 @@ > @rem Future versions might inspect a database of eligible servers > @rem to direct the interaction to the proper ports. > > -call java -jar @datadir@\MonetDB\lib\@JDBCCLIENT_JAR@ %* > +call java -jar @datadir@\MonetDB\lib\jdbcclient.jar %* > > Index: mjclient.in > =================================================================== > RCS file: /cvsroot/monetdb/clients/src/java/scripts/mjclient.in,v > retrieving revision 1.3 > retrieving revision 1.3.6.1 > diff -u -d -r1.3 -r1.3.6.1 > --- mjclient.in 3 Jan 2007 12:17:27 -0000 1.3 > +++ mjclient.in 16 Aug 2007 10:52:44 -0000 1.3.6.1 > @@ -23,4 +23,4 @@ > # to direct the interaction to the proper ports. > > prefix=@prefix@ > -exec java -jar @datadir@/MonetDB/lib/@JDBCCLIENT_JAR@ $* > +exec java -jar @datadir@/MonetDB/lib/jdbcclient.jar $* > > Index: Makefile.ag > =================================================================== > RCS file: /cvsroot/monetdb/clients/src/java/scripts/Makefile.ag,v > retrieving revision 1.3 > retrieving revision 1.3.6.1 > diff -u -d -r1.3 -r1.3.6.1 > --- Makefile.ag 8 Jan 2007 14:03:39 -0000 1.3 > +++ Makefile.ag 16 Aug 2007 10:52:43 -0000 1.3.6.1 > @@ -17,12 +17,14 @@ > MTSAFE > > scripts_sh = { > - NOINST > + COND = NOT_WIN32 > + DIR = bindir > EXT = "" > SOURCES = mjclient.in > } > > scripts_bat = { > - NOINST > + COND = NATIVE_WIN32 > + DIR = bindir > SOURCES = mjclient.bat.in > } > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins -- Sjoerd Mullender

1 0

Re: [Monetdb-developers] [Monetdb-checkins] clients/src/mapiclient MapiClient.mx, , 1.41, 1.42
by Martin Kersten 15 Aug '07

15 Aug '07

Fabian Groffen wrote: > On 15-08-2007 11:24:47 +0000, Martin Kersten wrote: >> - case 'e': >> + case 'E': >> echoquery = 1; >> continue; >> case 'f': >> @@ -1253,7 +1243,7 @@ >> setFormatter(s); >> continue; >> } >> - case 'x': >> + case 'e': >> exit_on_error = 1; > > I suggest haveing -e for echo. > > exit_on_error should not be necessary, if you assume the following: > 1) the language being used has control for errors itself, e.g. SQL's > auto-commit, or > 2) an error should not happen in batches, thus > 3) the client continues executing when reading from stdin, but dies on > the first error when reading from file > > Don't know how much this would affect testweb, but somewhere I feel it > is only in an interactive session sensible to continue after an error. According to Stefan this does not affect the test web. The feature will be dropped on the next commit

3 5

Re: [Monetdb-developers] [Monetdb-checkins] clients/src/mapiclient MapiClient.mx, , 1.40, 1.41
by Martin Kersten 15 Aug '07

15 Aug '07

Fabian Groffen wrote: > On 15-08-2007 08:23:20 +0000, Martin Kersten wrote: >> Update of /cvsroot/monetdb/clients/src/mapiclient >> In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv26440 >> >> Modified Files: >> MapiClient.mx >> Log Message: >> Blockmode is an interaction feature for MAL. It allows you to enter multiple >> lines before it is being set for execution. Sending is triggered by an empty >> line. > > Ehm... I thought we killed linemode some releases ago, and only support > blockmode these days. Yes. But the option was still there and not working. The feature was relevant for MIL, because its reader wasn't too clever. Then postponing execution was an option. In MAL you can now enter multiple lines > mal>\b mal>io.print(1); more>io.print(2); more> [ 1 ] [ 2 ] I am not sure if this really useful, because it raises the issue that you might want to call an editor on the buffer to correct it. > So maybe you should call it "Batchmode" instead of "Blockmode" to avoid > confusion. good point. But perhaps we should drop it completely. > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins

1 0

Re: [Monetdb-developers] [Monetdb-checkins] clients/src/mapilib Mapi.mx, , 1.13, 1.14
by Martin Kersten 13 Aug '07

13 Aug '07

Fabian Groffen wrote: > On 13-08-2007 14:16:28 +0000, Martin Kersten wrote: >> Update of /cvsroot/monetdb/clients/src/mapilib >> In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv20770 >> >> Modified Files: >> Mapi.mx >> Log Message: >> It is handy to gain access to the query from the handler. The MapiClient program is in flux. It functionality is quickly made on par with what is available for other systems. Rendering a tabular display is probably the most important feature, but also help functionality for MAL programmers is worth mentioning. > > The -e switch in JdbcClient does not print the full query per se, it > echos for each line read, just that very line, before it sends it to the > server, if it does at all. This way you can see results appearing right > after a query, which in multi-statment queries may differ from the full > query. There will/should be a simple version of \t that will do the job on a line by line basis. The statement boundaries are not easy to detect. > > I guess the difference is not that important though. For test scripts > (Mtest in particular) it is an extremely useful feature to be able to > see to what query the given result corresponds. yes. Given the fact that Mtest ignores lines starting with # makes it possible to realize this feature. A few more steps are needed to make MapiClient the default textual interface for all. The request list includes: CVS and TSV output. Or even XML and HTML. Inclusion of an easy logging. So, a few more things to do during this summer activity. > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins

1 0

Re: [Monetdb-developers] [Monetdb-checkins] clients/src/mapiclient dump.c, , 1.7, 1.8
by Sjoerd Mullender 12 Aug '07

12 Aug '07

On 08/12/2007 08:39 PM, Martin Kersten wrote: > Update of /cvsroot/monetdb/clients/src/mapiclient > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv25741 > > Modified Files: > dump.c > Log Message: > Remove duplicate rows. This solves the duplicates seen > when typing '\d idxs'. Is this the right thing to do? The problem, it seems to me, is that idxs occurs twice in the tables table (select * from tables where name = 'idxs'; returns two entries). Is that correct? > Index: dump.c > =================================================================== > RCS file: /cvsroot/monetdb/clients/src/mapiclient/dump.c,v > retrieving revision 1.7 > retrieving revision 1.8 > diff -u -d -r1.7 -r1.8 > --- dump.c 10 Aug 2007 11:48:59 -0000 1.7 > +++ dump.c 12 Aug 2007 18:39:52 -0000 1.8 > @@ -79,7 +79,7 @@ > fprintf(toConsole, " (\n"); > > snprintf(query, maxquerylen, > - "SELECT \"c\".\"name\"," /* 0 */ > + "SELECT DISTINCT \"c\".\"name\"," /* 0 */ > "\"c\".\"type\"," /* 1 */ > "\"c\".\"type_digits\"," /* 2 */ > "\"c\".\"type_scale\"," /* 3 */ > @@ -212,7 +212,7 @@ > } > mapi_close_handle(hdl); > snprintf(query, maxquerylen, > - "SELECT \"kc\".\"column\"," /* 0 */ > + "SELECT DISTINCT \"kc\".\"column\"," /* 0 */ > "\"kc\".\"nr\", " /* 1 */ > "\"k\".\"name\" " /* 2 */ > "FROM \"keycolumns\" \"kc\", " > @@ -267,7 +267,7 @@ > mapi_close_handle(hdl); > > snprintf(query, maxquerylen, > - "SELECT \"kc\".\"column\"," /* 0 */ > + "SELECT DISTINCT \"kc\".\"column\"," /* 0 */ > "\"kc\".\"nr\", " /* 1 */ > "\"k\".\"name\" " /* 2 */ > "FROM \"keycolumns\" \"kc\", " > @@ -325,7 +325,7 @@ > mapi_close_handle(hdl); > > snprintf(query, maxquerylen, > - "SELECT \"pkt\".\"name\"," /* 0 */ > + "SELECT DISTINCT \"pkt\".\"name\"," /* 0 */ > "\"pkkc\".\"column\"," /* 1 */ > "\"fkkc\".\"column\"," /* 2 */ > "\"fkkc\".\"nr\"," /* 3 */ > @@ -432,7 +432,7 @@ > fprintf(toConsole, ");\n"); > > snprintf(query, maxquerylen, > - "SELECT \"i\".\"name\", " /* 0 */ > + "SELECT DISTINCT \"i\".\"name\", " /* 0 */ > "\"k\".\"name\", " /* 1 */ > "\"kc\".\"nr\", " /* 2 */ > "\"c\".\"name\" " /* 3 */ > @@ -576,13 +576,13 @@ > { > const char *start = "START TRANSACTION"; > const char *end = "COMMIT"; > - const char *sequences1 = "SELECT \"name\" FROM \"sequences\""; > - const char *sequences2 = "SELECT seq.\"name\",get_value_for(s.\"name\",seq.\"name\"),\"minvalue\",\"maxvalue\",\"increment\",\"cycle\" FROM \"sequences\" seq, \"schemas\" s WHERE s.id = seq.schema_id"; > + const char *sequences1 = "SELECT DISTINCT \"name\" FROM \"sequences\""; > + const char *sequences2 = "SELECT DISTINCT seq.\"name\",get_value_for(s.\"name\",seq.\"name\"),\"minvalue\",\"maxvalue\",\"increment\",\"cycle\" FROM \"sequences\" seq, \"schemas\" s WHERE s.id = seq.schema_id"; > const char *tables = "SELECT \"name\" FROM \"_tables\" WHERE " > "\"type\" = 0 AND \"system\" = FALSE"; > - const char *views = "SELECT \"name\",\"query\" FROM \"_tables\" WHERE " > + const char *views = "SELECT DISTINCT \"name\",\"query\" FROM \"_tables\" WHERE " > "\"type\" = 1 AND \"system\" = FALSE"; > - const char *functions = "SELECT \"func\" FROM \"functions\" WHERE " > + const char *functions = "SELECT DISTINCT \"func\" FROM \"functions\" WHERE " > "\"sql\" = TRUE"; > MapiHdl hdl; > int rc = 0; > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins -- Sjoerd Mullender

2 1

Re: [Monetdb-developers] [Monetdb-checkins] clients/src/mapiclient MapiClient.mx, , 1.8, 1.9
by Romulo Goncalves 09 Aug '07

09 Aug '07

Martin Kersten wrote: > Update of /cvsroot/monetdb/clients/src/mapiclient > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv19893 > > Modified Files: > MapiClient.mx > Log Message: > MapiClient has been extended with a SQL rendering option based on > a predefined columnwidth and pagesize. > A columnwidth= -1 means old display structure. > Columnwidth=0 indicates to respect the sizes in the table headers. > Columnwidth>0 is an upperbound. Broad columns are pushed to make > all fit. The long values are displayed over multiple lines. If columnwidth is bigger than the table headers it equivalent to set it to zero. For columnwidth=5 and columnswith=10 I do not see any differences in the output, why? The error output is different. [goncalve@amelia src]$ MapiClient -lsql --columnwidth=-1 --pagesize=-1 sql>select * from table; MAPI = monetdb@localhost:50000 QUERY = select * from table; ERROR = !syntax error, unexpected TABLE in: "select * from table" sql>\q [goncalve@amelia src]$ MapiClient -lsql --columnwidth=0 --pagesize=-1 sql>select * from table; !syntax error, unexpected TABLE in: "select * from table" Timer 0.427 msec sql>\q [goncalve@amelia src]$ Another interesting point is the response time. If I use: columnwidth=0 the response time is around 8 ms columnwidth=10 the response time is around 13 ms Note: I am looking to the response time printed in the MapiClient. There are not special measures made by me. > > The pagesize default is -1 to indicate the old situation. A pagesize > = 0 indicates no pagination structure, and a pagesize>0 produces > a paginated result, which can be stopped. Well if I use columnwidth=-1 the pagesize does not have any effect. If I load a file the options do not work. MapiClient -lsql --columnwidth=0 --pagesize=10 romulo.sql Where romulo.sql contains the query select * from tables; > > The styling works with the debugger, which now also better indicates > the mode. I will test this after you fix the previous problems. ;) Regards, Romulo The trace mode requires some extra work (for columnwidth>=0) > > The style conventions for the other languages should not have been > changed. (checking is needed) (and multi platform compilation) >

2 2