- developers-list - monetdb.org

Re: [Monetdb-developers] php5 interface
by Martin Kersten 09 May '08

09 May '08

Michiel Kamermans wrote: > Martin, > > A test using windows XP with PHP 5.2.6 and MonetDB seems to work just > fine. I suspect that this means that in Vista monetDB won't be able to > interface with PHP either, as the core is essentially the same as the > one used in windows server 2008... I am not a windows expert myself > when it comes to figuring out API differences, so I wouldn't know > where to look... but I do have one improvement to the php file in the > /share/php dir: > > Right now it auto-assumes running on *nix, automatically calling > dl('monetdb.so'). A change for this line to the following would make > the script usable on both *nix and windows: > > $ext="monetdb"; > if (!extension_loaded($ext)) { > $prefix = (PHP_SHLIB_SUFFIX === 'dll') ? 'php_' : ''; > dl($prefix . $ext . '.' . PHP_SHLIB_SUFFIX); } > > Regards, Thank you very much for the information provided, we will take this suggestion into consideration > > Mike Kamermans > (who will now no doubt spend a nice bit of time in XP doing > benchmarking =)

1 0

[Monetdb-developers] [Fwd: Re: php5 interface]
by Martin Kersten 09 May '08

09 May '08

-------- Original Message -------- Subject: Re: php5 interface Date: Fri, 09 May 2008 19:13:40 +0200 From: Michiel Kamermans <mkamerma(a)science.uva.nl> To: Martin Kersten <Martin.Kersten(a)cwi.nl> References: <48248084.5060306(a)science.uva.nl> <4824835A.10101(a)cwi.nl> Hi Martin, I've tested this on windows server 2008 (which is basically vista, without all the vista bits stripped off), with the MonetDB installed using "MonetDB5-SQL-Installer-i386-20080214.msi". While technically the setup also involves Apache 2.2.8, the fact that PHP as standalone engine will crash means it doesn't really enter into the picture. I will see if I have the same problems in windows XP with PHP 5.2.6 and report back on the issue. Regards, -- Michiel Kamermans ,-------------------------------------------------------------- | Masters student AI at the University of Amsterdam [0024538] | http://www.nihongoresources.com `--------------------------------------------------------------

1 0

[Monetdb-developers] Reporting a bug
by Nadeem Iftikhar 07 May '08

07 May '08

Hi I tried the following link to report the bug, but it does not work http://monetdb.wiki.sourceforge.net/ Bug..... I need to insert some null values into a table via a procedure. I created the table and did insert two rows. One with (insert into) command and second with (insert into ..select) command. Both commands work well and I could see two rows added in result. When I used the same (insert into.. select) command in a procedure. It behaves in a strange fashion. It shows that a row has been affected, but does not show the newly added row. If the rows are counted, it gives the correct count which is (3) in this case but still I could not see the last row which is added via a procedure. ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' create sequence "ff" as integer start with 1; CREATE TABLE t1(timeid INT DEFAULT NEXT VALUE FOR "ff" PRIMARY KEY, a INT, b INT, c INT, d INT, e INT, f VARCHAR(20), g VARCHAR(20), h INT, i VARCHAR(10), j VARCHAR(10), k VARCHAR(10), l INT, m INT, n VARCHAR(10), o VARCHAR(10), p VARCHAR(10), q VARCHAR(15), r INT ); ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' And then insert a row ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' insert into t1(a, b, c, d, e, f, g, h, i, j, k, l, m, n, o, p, q, r) values(1, 1, 1, 1, 1, 'first row', 'first row',1, 'first row', 'first row', 'first row',1,1, 'first row', 'first row', 'first row', 'first row', 1); select * from t1;sql>sql>sql>sql>more>more>more>more>more>more>more>more>more>more>more>more>more>more>more>more>more>more>more>sql> sql>Rows affected 1 sql> +------+--+--+--+--+--+-----+-----+--+-----+------+------+--+--+------+------+------+------+--+ | time |a |b |c |d |e |f |g |h |i |j |k |l |m |n |o |p |q |r | : id | | | | | | | | | | | | | | | | | | | +======+==+==+==+==+==+=====+=====+==+=====+======+======+==+==+======+======+======+======+==+ | 1 |1 |1 |1 |1 |1 |firs |firs |1 |firs |first |first |1 |1 |first |first |first |first |1 | : | | | | | |t |t | |t |row |row | | |row |row |row |row | | : | | | | | |row |row | |row | | | | | | | | | | +------+--+--+--+--+--+-----+-----+--+-----+------+------+--+--+------+------+------+------+--+ '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Every thing is fine so far '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' sql>insert into t1(a, b, c, d, e, f, g, h) select a, b, c, d, e, f, g, h from t1 where timeid = 1; Rows affected 1 sql>select * from t1; +------+--+--+--+--+--+-----+-----+--+-----+------+------+--+--+------+------+------+------+--+ | time |a |b |c |d |e |f |g |h |i |j |k |l |m |n |o |p |q |r | : id | | | | | | | | | | | | | | | | | | | +======+==+==+==+==+==+=====+=====+==+=====+======+======+==+==+======+======+======+======+==+ | 1 |1 |1 |1 |1 |1 |firs |firs |1 |firs |first |first |1 |1 |first |first |first |first |1 | : | | | | | |t |t | |t |row |row | | |row |row |row |row | | : | | | | | |row |row | |row | | | | | | | | | | | 2 |1 |1 |1 |1 |1 |firs |firs |1 |null |null |null |n |n |null |null |null |null |n | : | | | | | |t |t | | | | |u |u | | | | |u | : | | | | | |row |row | | | | |l |l | | | | |l | : | | | | | | | | | | | |l |l | | | | |l | +------+--+--+--+--+--+-----+-----+--+-----+------+------+--+--+------+------+------+------+--+ ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' inserted another row and it works fine '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' sql>create procedure tt() begin insert into t1(a, b, c, d, e, f, g, h) select a, b, c, d, e, f, g, h from t1 where timeid = 1; end; call tt(); select * from t1; more>more>more> sql>Rows affected 1 sql>+------+--+--+--+--+--+-----+-----+--+-----+------+------+--+--+------+------+------+------+--+ | time |a |b |c |d |e |f |g |h |i |j |k |l |m |n |o |p |q |r | : id | | | | | | | | | | | | | | | | | | | +======+==+==+==+==+==+=====+=====+==+=====+======+======+==+==+======+======+======+======+==+ | 1 |1 |1 |1 |1 |1 |firs |firs |1 |firs |first |first |1 |1 |first |first |first |first |1 | : | | | | | |t |t | |t |row |row | | |row |row |row |row | | : | | | | | |row |row | |row | | | | | | | | | | | 2 |1 |1 |1 |1 |1 |firs |firs |1 |null |null |null |n |n |null |null |null |null |n | : | | | | | |t |t | | | | |u |u | | | | |u | : | | | | | |row |row | | | | |l |l | | | | |l | : | | | | | | | | | | | |l |l | | | | |l | +------+--+--+--+--+--+-----+-----+--+-----+------+------+--+--+------+------+------+------+--+ ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' The problem starts now: when I try to insert the row via a procedure it shows that row effected 1 but does not show the row. ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' sql>select count(*) from t1; +--------+ | count_ | +========+ | 3 | +--------+ sql>select timeid from t1; +--------+ | timeid | +========+ | 1 | | 2 | | 3 | +--------+ sql>select * from t1; +------+--+--+--+--+--+-----+-----+--+-----+------+------+--+--+------+------+------+------+--+ | time |a |b |c |d |e |f |g |h |i |j |k |l |m |n |o |p |q |r | : id | | | | | | | | | | | | | | | | | | | +======+==+==+==+==+==+=====+=====+==+=====+======+======+==+==+======+======+======+======+==+ | 1 |1 |1 |1 |1 |1 |firs |firs |1 |firs |first |first |1 |1 |first |first |first |first |1 | : | | | | | |t |t | |t |row |row | | |row |row |row |row | | : | | | | | |row |row | |row | | | | | | | | | | | 2 |1 |1 |1 |1 |1 |firs |firs |1 |null |null |null |n |n |null |null |null |null |n | : | | | | | |t |t | | | | |u |u | | | | |u | : | | | | | |row |row | | | | |l |l | | | | |l | : | | | | | | | | | | | |l |l | | | | |l | +------+--+--+--+--+--+-----+-----+--+-----+------+------+--+--+------+------+------+------+--+ sql> ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' I could not see the 3rd row *********************************** Regards, Nadeem Iftikhar, Ph.D. Fellow Department of Computer Science, Aalborg University Selma Lagerlöfs Vej 300, DK-9220 Aalborg Øst, Denmark Phone: (+45) 9940 9830, fax: (+45) 9940 9798 E-mail: nadeem(a)cs.aau.dk; nadeem(a)ieee.org Home Page: http://www.cs.aau.dk/~nadeem ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.

2 1

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/runtime pathfinder.mx, , 1.411, 1.412
by Lefteris 07 May '08

07 May '08

That was drastic:) On Tue, May 6, 2008 at 7:20 PM, Jan Rittinger <tsheyar(a)users.sourceforge.net> wrote: > Update of /cvsroot/monetdb/pathfinder/runtime > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv14794 > > Modified Files: > pathfinder.mx > Log Message: > -- Check whether Lefteris changes to ws_create() are complete :) > > > U pathfinder.mx > Index: pathfinder.mx > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/runtime/pathfinder.mx,v > retrieving revision 1.411 > retrieving revision 1.412 > diff -u -d -r1.411 -r1.412 > --- pathfinder.mx 6 May 2008 11:36:10 -0000 1.411 > +++ pathfinder.mx 6 May 2008 16:20:00 -0000 1.412 > @@ -1348,7 +1348,6 @@ > return bat(void,tpe).seqbase(PRE_BASE); # a constant bat > } > > -PROC ws_create() : BAT[void,bat] { return ws_create(0); } # still exists for algebra > PROC ws_create(int update) : BAT[void,bat] > { > # wsid = 1bit(0) | 31bits(unique-id) | 2bits(update) | 30bits(batid) > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Don't miss this year's exciting event. There's still time to save $100. > Use priority code J8TL2D2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/java… > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins >

2 2

[Monetdb-developers] check-in "killed" pf/tijah
by Henning Rode 07 May '08

07 May '08

hej, one of the check-ins yesterday more or less "killed" pf/tijah. the test-set is now completely red for our module. since i also checked in one line of code yesterday, i tested already whether it was the cause of the trouble, but undoing my check-in does not solve anything. so, i suppose there must be some other reason. -henning

3 5

[Monetdb-developers] How to debug MonetDB project on Windows OS?
by 廉小伟 06 May '08

06 May '08

Hi.. I want to know about the method of debugging MonetDB on Windows OS. After compiering MonetDB use "namke" , how can I debug it. Is special debug tool needed?

1 0

[Monetdb-developers] RDF
by Bellekens, P.A.E. 18 Apr '08

18 Apr '08

Dear MonetDB developers, I have a question related to RDF. In you PDF online, I see that it is possible to import RDF in the MonetDB system, although there is not much further information concerning RDF input. Could you please inform me a bit more about: - is it possible to upload RDF data? - is there any kind of RDF specific querying? - is it possible to run MonetDB as a backend in a triple store like for example in Sesame? - is there any performance measuring done for RDF querying? It is known that column stores have a good performance (c-store benchmarks) for RDF data as well... With kind regards, Pieter

2 2

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/modules/mal rdf.mx, , 1.2, 1.3
by Lefteris 17 Apr '08

17 Apr '08

On Thu, Apr 17, 2008 at 5:24 PM, Marco Antonelli <marcoantonelli(a)users.sourceforge.net> wrote: > Update of /cvsroot/monetdb/MonetDB5/src/modules/mal > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv26814/src/modules/mal > > Modified Files: > rdf.mx > Log Message: > Added a T bat that stores the types of the RDF objects (IRI, integer, double, plain literal...). It still has to be sorted together with the S, P, O bats in all their possible combinations > > U rdf.mx > Index: rdf.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/modules/mal/rdf.mx,v > retrieving revision 1.2 > retrieving revision 1.3 > diff -u -d -r1.2 -r1.3 > --- rdf.mx 1 Apr 2008 14:48:08 -0000 1.2 > +++ rdf.mx 17 Apr 2008 15:24:15 -0000 1.3 > +static rdf_type RDFparseXsdDataType(char *uri) > +{ > + rdf_type ret; > + if (uri == NULL) > + ret = PLAIN; > + else if ( strcmp(uri, "http://www.w3.org/2001/XMLSchema#int") || > + strcmp(uri, "http://www.w3.org/2001/XMLSchema#integer")) > + ret = INTEGER; > + else if (strcmp(uri, "http://www.w3.org/2001/XMLSchema#decimal")) > + ret = DECIMAL; > + else if (strcmp(uri, "http://www.w3.org/2001/XMLSchema#double")) > + ret = DOUBLE; > + else if (strcmp(uri, "http://www.w3.org/2001/XMLSchema#boolean")) > + ret = BOOLEAN; > + else if (strcmp(uri, "http://www.w3.org/2001/XMLSchema#float")) > + ret = FLOAT; > + else if (strcmp(uri, "http://www.w3.org/2001/XMLSchema#string")) > + ret = STRING; > + else if (strcmp(uri, "http://www.w3.org/2001/XMLSchema#dateTime")) > + ret = DATETIME; > + else > + ret = UNKNOWN; > + > + raptor_free_memory(uri); > + return ret; > +} I am not sure if this is the correct way to identify the type, what happens if 2001 changes to 1998 or 2003? or if they use prefix instead of the uri? Does raptor gives you always the full uri back? it seems way to much hard wired. > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Don't miss this year's exciting event. There's still time to save $100. > Use priority code J8TL2D2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/java… > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins >

2 3

[Monetdb-developers] MonetDB clients asks for MonetDB common 1.22.0
by Marco Antonelli 17 Apr '08

17 Apr '08

Hello, I'm building Monet on my laptop, but the clients module during configure stops saying: checking whether MonetDB Common version 1.22.0 or newer is installed... no: found only version 1.20.0 configure: error: Clients requires at least version 1.22.0 of MonetDB, but only version 1.20.0 was found. I checked out from cvs as told here on the sourceforce page: http://sourceforge.net/cvs/?group_id=56967 how may I fix it? Marco

2 2

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/compiler/mil mil_dce.c, , 1.19, 1.20 milgen.brg, , 1.142, 1.143
by Jan Rittinger 17 Apr '08

17 Apr '08

The answer is simple: kind=165 is your new tape operator and its printing is missing in print_statement(). Your tape is no expression with a return value but a statement with side effects. Thus the MIL grammar in milprint.c expects the handling of your tape in print_statement() instead of print_expression() -- see also the grammar at the top of milprint.c (as the error message suggests :)). Jan On 04/17/2008 09:27 AM, Jan Flokstra wrote with possible deletions: > Hi Jan, > > When I remove the if_() around my tj_docmgmt_tape() function in milgen.brg I > get the following error message. [...] > > Jan. > > # End rule: "Rel: std_sort(Rel)" > a0001 := a0006; > a0004 := a0001.project (str(nil)); > a0002 := a0007; > a0003 := a0001.project (str(nil)); > DocmgmTape (ws, a0004, a0002, a0003, a0001); > fatal error: I encountered problems while generating MIL output. > fatal error: This is possibly due to an illegal MIL tree, not conforming to > the grammar in milprint.c > fatal error: This is how far I was able to generate the script: > notice: node: ALG_tj_docmgmt_tape > fatal error: Illegal MIL tree. MIL printer screwed up (kind: 165). > # halted in milprint.c (print_statement), line 596 -- Jan Rittinger Database Systems Technische Universität München (Germany) http://www-db.in.tum.de/~rittinge/

1 0