November 2007 - developers-list

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/test/BugTracker/Tests auto_increment.SF-1834820.sql, SQL_2-20, NONE, 1.1.2.1
by Stefan Manegold 20 Nov '07

20 Nov '07

Please note that this new test will not be executed, unless also added to the repstective "All" file. Stefan On Tue, Nov 20, 2007 at 06:50:31AM +0000, Martin Kersten wrote: > Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv29561 > > Added Files: > Tag: SQL_2-20 > auto_increment.SF-1834820.sql > Log Message: > Added the test file. Output needs to be produced. > > > --- NEW FILE: auto_increment.SF-1834820.sql --- > CREATE TABLE testusers ( > id INT NOT NULL AUTO_INCREMENT, > name VARCHAR(40), > fullname VARCHAR(100), > PRIMARY KEY (id) > ); > > > INSERT INTO testusers (id, name, fullname) VALUES (1, 'wendy', 'Wendy > Wones'); > select * from testusers; > > -- This will fail the first time > INSERT INTO testusers (name, fullname) VALUES ('fred', 'Fred Flintstone'); > select * from testusers; > > -- Now it will succeed > INSERT INTO testusers (name, fullname) VALUES ('fred', 'Fred Flintstone'); > select * from testusers; > > drop table testusers; > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > 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 |

1 0

[Monetdb-developers] bat.new undefined
by darabi＠web.de 15 Nov '07

15 Nov '07

Hello, I am trying to make a small function for creating some persistent bats. Could you point me to my (probably stupid) error? Many thanks Kambiz $ mclient --language=mal -d demo mal> mal>function init_schema():void; mal> mal> bbp.bind("schema_version"); mal> mal> # create schema, if it doesn't exist mal> catch MALException:str; mal> mal> s := bat.new(:void,:oid); mal> bat.setName(s, "schema"); mal> bat.setPersistent(s); mal> mal> s := bat.new(:void,:void); mal> bat.setName(s, "version"); mal> bat.setPersistent(s); mal> mal> sv := bat.new(:oid,:int); mal> bat.setName(sv, "schema_version"); mal> bat.setPersistent(sv); mal> mal> cl := bat.new(:oid,:oid); mal> bat.setName(sv, "schema_class"); mal> bat.setPersistent(sv); mal> mal># etc. etc. etc. mal> mal> transaction.commit(); mal> mal> exit; MAPI = monetdb@localhost:50000 QUERY = exit; ERROR = !TypeException:user.init_schema[7]:'bat.new' undefined in: s:bat[:void,:oid] := bat.new(_6:void, _6:void) mal> MAPI = monetdb@localhost:50000 QUERY = ERROR = !TypeException:user.init_schema[7]:'bat.new' undefined in: s:bat[:void,:oid] := bat.new(_6:void, _6:void) !SyntaxException:user.init_schema[18]:begin 'MALException' without exit in init_schema[19] mal> io.print("Schema tables seem to exist. Will do nothing\n"); MAPI = monetdb@localhost:50000 QUERY = io.print("Schema tables seem to exist. Will do nothing\n"); ERROR = !TypeException:user.init_schema[7]:'bat.new' undefined in: s:bat[:void,:oid] := bat.new(_6:void, _6:void) !SyntaxException:user.init_schema[19]:begin 'MALException' without exit in init_schema[20] mal>end init_schema; MAPI = monetdb@localhost:50000 QUERY = end init_schema; ERROR = !TypeException:user.init_schema[7]:'bat.new' undefined in: s:bat[:void,:oid] := bat.new(_6:void, _6:void) !SyntaxException:user.init_schema[18]:begin 'MALException' without exit in init_schema[19] mal>

3 5

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder MonetDB-XQuery.spec.in, , 1.42, 1.43
by Sjoerd Mullender 13 Nov '07

13 Nov '07

Please spell check. Ying Zhang wrote: > Update of /cvsroot/monetdb/pathfinder > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv27856 > > Modified Files: > MonetDB-XQuery.spec.in > Log Message: > - added a separate JAR package for the XRPC java API files > - added the new file for 'make rpm' as well > > > > > Index: MonetDB-XQuery.spec.in > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/MonetDB-XQuery.spec.in,v > retrieving revision 1.42 > retrieving revision 1.43 > diff -u -d -r1.42 -r1.43 > --- MonetDB-XQuery.spec.in 15 Oct 2007 15:39:06 -0000 1.42 > +++ MonetDB-XQuery.spec.in 13 Nov 2007 13:56:50 -0000 1.43 > @@ -90,14 +90,21 @@ > automatic index management, extensibility of data types and search > accelerators, SQL- and XQuery- frontends. > > -This package contains an XRPC Wrapper (xrpcwrapper.jar), a stand-alone > -Java program that can be pluged in on top of an XQuery engine to handle > -non-nested XRPC requests (i.e. requests that do not trigger another XRPC > -request). > +This package contains three Java Archieves > +- xrpcwrapper.jar: the XRPC Wrapper, which is a stand-alone Java program > + that can be pluged in on top of an XQuery engine to handle non-nested > + XRPC requests (i.e. requests that do not trigger another XRPC > + request). > > -This package also contains an example client program > -(xrpcwrapper-test.jar), which (i) can be used to test the XRPC Wrapper, > -and (ii) shows how to write an XRPC Java client. > +- xrpcwrapper-test.jar: an example client program, which (i) can be used > + to test the XRPC Wrapper, and (ii) shows how to write an XRPC Java > + client. > + > +- xrpcutil.jar: the XRPC Java API, which includes funcionts for > + -- creating XRPC request messages, > + -- parsing XRPC response messages, > + -- send and/or receive XRPC messages using HTTP connection, > + -- XRPC specific exception classes > > %endif > > @@ -162,7 +169,7 @@ > %files xrpcwrapper > %defattr(-,root,root) > %dir %{_datadir}/MonetDB/lib > -%{_datadir}/MonetDB/lib/xrpcwrapper*.jar > +%{_datadir}/MonetDB/lib/xrpc*.jar > %endif > > %files devel > > > ------------------------------------------------------------------------- > 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-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins -- Sjoerd Mullender

1 0

[Monetdb-developers] Physical stack space
by Maurice van Keulen 12 Nov '07

12 Nov '07

Hi, When writing recursive xqueries that that manipulate somewhat larger documents, MonetDB frequently quits with the error message !ERROR: interpret: running out of physical stack space! Is there a way to increase the physical stack space? I found no parameter to set in MonetDB.conf, perhaps in the source somewhere? Maurice. -- ---------------------------------------------------------------------- Dr.Ir. M. van Keulen - Assistant Professor, Data Management Technology Univ. of Twente, Dept of EEMCS, POBox 217, 7500 AE Enschede, Netherlands Email: m.vankeulen(a)utwente.nl, Phone: +31 534893688, Fax: +31 534892927 Room: ZI 3039, WWW: http://www.cs.utwente.nl/~keulen

1 0

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB/src/testing Mtest.py.in, , 1.320, 1.321
by Stefan Manegold 07 Nov '07

07 Nov '07

On Wed, Nov 07, 2007 at 03:44:26PM +0000, Niels Nes wrote: > Update of /cvsroot/monetdb/MonetDB/src/testing > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv21513 > > Modified Files: > Mtest.py.in > Log Message: > > added pythonlibdir (obtained from monetdb-config and monetdb-clients-config) > into the PYTHONPATH (in an attempt to fix the problems with tests using > MonetSQLdb) should the respective test do this locally? I recall addint something like this to (some of) the MonetSQLdb tests ... Stefan > > > > Index: Mtest.py.in > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB/src/testing/Mtest.py.in,v > retrieving revision 1.320 > retrieving revision 1.321 > diff -u -d -r1.320 -r1.321 > --- Mtest.py.in 2 Nov 2007 07:31:36 -0000 1.320 > +++ Mtest.py.in 7 Nov 2007 15:44:24 -0000 1.321 > @@ -102,6 +102,17 @@ > import distutils.sysconfig > p = _configure(os.path.join('@QXprefix@',distutils.sysconfig.get_python_lib(1,0,""))) > sys.path.insert(0, p) > + try: > + q = GetConfig('monetdb-config', '--pythonlibdir') > + p = p + os.pathsep + q > + except: > + None > + try: > + q = GetConfig('monetdb-clients-config', '--pythonlibdir') > + p = p + os.pathsep + q > + p = p + os.pathsep + q + os.sep + 'MonetDB' > + except: > + None > from MonetDB import monet_options > if os.environ.has_key('PYTHONPATH'): > p = p + os.pathsep + os.environ['PYTHONPATH'] > > > ------------------------------------------------------------------------- > 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 > > -- | 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

[Monetdb-developers] Does Monetdb support Chinese?
by ding_guangfu＠topsec.com.cn 07 Nov '07

07 Nov '07

As Title. Thanks.

2 1

[Monetdb-developers] MAPI wire protocol?
by Tim Gebhardt 07 Nov '07

07 Nov '07

Hello, I'm working on a C#/.NET client library to connect to a MonetDB server. I've mapped most of the libMapi.dll api calls so that I can call the C library from .NET but this presents a few problems: 1. There's a performance penalty to interface native code libraries to .NET 2. There's a lot of overhead of marshaling UTF8 strings between .NET and the C library, and potential problems with NULL parameters. 3. There's a portability problem with using the native libraries (trouble deploying to the Mono runtime) I think the client library would be better off implementing the MAPI wire protocol rather than interfacing with the C library, but I cannot find any documents that detail the protocol. Is there somewhere this is published, or did I just not Google the right stuff? Also if anyone is interested in giving me a hand you can find the Google Code workspace of the aforementioned project at this link: http://code.google.com/p/monetdb-net/ -Tim Gebhardt tim(a)gebhardtcomputing.com

3 2

Re: [Monetdb-developers] [Monetdb-checkins] clients/src/php/Cimpl Makefile.ag, Clients_1-20, 1.4.4.1, 1.4.4.2
by Fabian Groffen 06 Nov '07

06 Nov '07

On 06-11-2007 11:55:48 +0000, Stefan Manegold wrote: > since compilation with strict compiler settings have (once again) > proved to be bery useful to locate bugs in the code, > we nolonger simply disable all of the strict "X_CFLAGS" > in directories that (also) contain swig-code, > but rather selectively disable only those extra warnings/errors > that do indeed occur in code that is beyond our control. > > (This affects only compilation with --enable-strict.) ... > +CFLAGS = $(GCC_SWIG_CFLAGS) $(ICC_SWIG_CFLAGS) -DCOMPILE_DL_MONETDB=1 -D_GNU_SOURCE Unless I misunderstood the code in the .m4, this looks like the user specified CFLAGS are overriden here, which is an undesirable effect.

2 1

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/src/tools/java build.properties, XQuery_0-20, 1.1.2.3, 1.1.2.4
by Fabian Groffen 01 Nov '07

01 Nov '07

On 01-11-2007 10:48:18 +0000, Ying Zhang wrote: > Update of /cvsroot/monetdb/pathfinder/src/tools/java > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv5671 > > Modified Files: > Tag: XQuery_0-20 > build.properties > Log Message: > Corrected value of the "compiler" attribute of <javac> [snip] > # which Java compiler to use, default: javac > -build_compiler=javac > +build_compiler=javac1.5 While the comment doesn't reflect a valid state here, this isn't too flexible. Why don't you just drop the whole build_compiler variable you introduced, and use the completely transparent and well supported and usually expected build.compiler variable only once you really want to control what compiler is being used, as I suggested to you earlier?

4 6

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/src/tools/java build.properties, XQuery_0-20, 1.1.2.4, 1.1.2.5 build.xml, XQuery_0-20, 1.1.2.4, 1.1.2.5
by Sjoerd Mullender 01 Nov '07

01 Nov '07

Ying Zhang wrote: > diff -u -d -r1.1.2.4 -r1.1.2.5 > --- build.properties 1 Nov 2007 10:48:16 -0000 1.1.2.4 > +++ build.properties 1 Nov 2007 12:49:25 -0000 1.1.2.5 > @@ -14,4 +14,5 @@ > javac_version=1.5 > > # which Java compiler to use, default: javac > -build_compiler=javac1.5 > +build.compiler=javac1.5 > + > Do we really need this property? Isn't the default good enough? Won't still this require Sun Java (since you mentioned you tried it with value gcj to compile using gcj)? If so, then that isn't good enough. -- Sjoerd Mullender

1 0