January 2008 - developers-list

[Monetdb-developers] what about the jdbc driver ?
by Jean-Paul Le Fèvre 01 Feb '08

01 Feb '08

Hello, I'm unable to compile the jdbc driver : some Monet classes do not implement abstract methods. I've read a previous thread about this problem in the archive from april 2007. The cause of the problem seems to be the version of java I'm using (1.6). In my opinion jdk 1.5 is obsolete at this point and I no longer have this version on any of my machines. I tried the installation of the MonetDB-Mars-SuperBall-SR5 tarball, then of the last snapshot available but without success. Is there any already compiled jar files somewhere ? -- ___________________________________________________________________ Jean-Paul Le Fèvre * Mail : LeFevre(a)fonteny.org

2 1

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB/src/testing Mtest.py.in, , 1.333, 1.334
by Romulo Goncalves 31 Jan '08

31 Jan '08

Stefan Manegold wrote: > Update of /cvsroot/monetdb/MonetDB/src/testing > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv26786/MonetDB/src/testing > > Modified Files: > Mtest.py.in > Log Message: > > Added "-a / --algebra" switch to Mtest.py to enable the Algebra version of the SQL compiler > (once we have a proper switch for Mserver / mclient, also Pathfinder can use this switch). Well, the option -a does not work while the option --algebra works fine. the Error: Traceback (most recent call last): File "/ufs/goncalve/scratch/MonetDB/debug/MonetDB/bin/Mtest.py", line 3742, in <module> main(sys.argv) File "/ufs/goncalve/scratch/MonetDB/debug/MonetDB/bin/Mtest.py", line 2912, in main opts, args = monet_options.parse_options(argv[1:], options, Usage, False) File "/ufs/goncalve/scratch/MonetDB/debug/MonetDB/lib64/python2.5/site-packages/MonetDB/monet_options.py", line 211, in parse_options opts, args = getopt.getopt(argv, getopt_short, getopt_long) File "/usr/lib64/python2.5/getopt.py", line 91, in getopt opts, args = do_shorts(opts, args[0][1:], shortopts, args[1:]) File "/usr/lib64/python2.5/getopt.py", line 191, in do_shorts if short_has_arg(opt, shortopts): File "/usr/lib64/python2.5/getopt.py", line 207, in short_has_arg raise GetoptError('option -%s not recognized' % opt, opt) getopt.GetoptError: option -a not recognized Romulo > > Via `Mapprove.py -S.Algebra ...`, algebra-specific stable output can be approved. > > Also changed the default for template, sql, & geom to use M5 server iso. M4 server. > > > Index: Mtest.py.in > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB/src/testing/Mtest.py.in,v > retrieving revision 1.333 > retrieving revision 1.334 > diff -u -d -r1.333 -r1.334 > --- Mtest.py.in 11 Jan 2008 10:37:02 -0000 1.333 > +++ Mtest.py.in 28 Jan 2008 10:34:14 -0000 1.334 > @@ -1211,6 +1211,7 @@ > env['TST_OIDS'] = "" > env['TST_FIVE'] = "" > env['TST_STATIC'] = "" > + env['TST_ALGEBRA'] = "" > if qOut: > tbs = re.compile("^# Compiled for .*/([63][42]bit) with ([63][42])bit OIDs;? (.*) linked", re.MULTILINE) > tm = re.compile("^Modules: (.*)$", re.MULTILINE) > @@ -1262,6 +1263,9 @@ > if par['M5']: > env['TST_FIVE'] = "Five" > os.environ['TST_FIVE'] = "Five" > + if par['ALGEBRA']: > + env['TST_ALGEBRA'] = "Algebra" > + os.environ['TST_ALGEBRA'] = "Algebra" > return rtrn > ### GetBitsAndOIDsAndModsAndStatic(env) # > > @@ -1375,12 +1379,15 @@ > OIDS = env['TST_OIDS'] > FIVE = env['TST_FIVE'] > STATIC = env['TST_STATIC'] > + ALGEBRA = env['TST_ALGEBRA'] > if FIVE: > FIVE = "(\.Five)?" > if STATIC: > STATIC = "(\.STATIC)?" > + if ALGEBRA: > + ALGEBRA = "(\.Algebra)?" > dir,file = os.path.split(TST) > - outre = re.compile('^'+re.escape(file)+'\.stable\.(?P<tp>out|err)(\.(%s(%s)?|%s(%s)?))?(\.%s)?(\.%s)?%s%s$' % (re.escape(OS), re.escape(RELEASE), re.escape(DIST), re.escape(VERSION), BITS, OIDS, FIVE, STATIC)) > + outre = re.compile('^'+re.escape(file)+'\.stable\.(?P<tp>out|err)(\.(%s(%s)?|%s(%s)?))?(\.%s)?(\.%s)?%s%s%s$' % (re.escape(OS), re.escape(RELEASE), re.escape(DIST), re.escape(VERSION), BITS, OIDS, FIVE, STATIC, ALGEBRA)) > bestout = besterr = '' > for f in os.listdir(dir or os.curdir): > res = outre.match(f) > @@ -2206,6 +2213,8 @@ > Srvr = '%s "--dbinit=%s"' % (Srvr, DBINIT) > if SERVER == "SQL": > lang="sql" > + if par['ALGEBRA']: > + Srvr = '%s --set sql_debug=16384' % Srvr > if par['M5']: > Srvr = '%s --set mal_listing=0 "--dbinit=%s include sql;"' % (Srvr, DBINIT) > else: > @@ -2534,6 +2543,7 @@ > v['OIDS'] = '' > v['FIVE'] = '' > v['STATIC'] = '' > + v['ALGEBRA'] = '' > if os.path.isfile(f): > r = re.compile('^([A-Z]+) = "(.*)".*$') > for l in open(f): > @@ -2709,7 +2719,7 @@ > } > > par = {} > -# the default; only used for usage information in case -p/---package has not been given > +# the default; only used for usage information in case -p/--package has not been given > par['PACKAGE'] = 'monetdb' > # try to be "smart" > if os.path.exists(os.path.join('CVS', 'Repository')): > @@ -2808,6 +2818,8 @@ > "use Mserver of MonetDB Version 4 (default with <package> not in {monetdb5, monetdb-datacell})"), > ('MonetDB5', '5', 'MonetDB5', None, > "use mserver5 of MonetDB Version 5 (default with <package> in {monetdb5, monetdb-datacell})"), > + ('algebra', 'a', 'algebra', None, > + "use the algebra version of the SQL compiler"), > ('recursive', 'r', 'recursive', None, > "recurse into subdirectories (implies 'All')"), > ('MONETDB_SOURCE', None, 'MONETDB_SOURCE', '<path>', > @@ -2872,7 +2884,7 @@ > elif THISFILE == 'Mapprove.py': > f = os.path.join(GetMonetConfig(par['PACKAGE'],'--prefix'),dftTSTPREF,'.Mapprove.rc') > v = ReadMapproveRc(f) > - for i in 'BITS', 'OIDS', 'FIVE', 'STATIC': > + for i in 'BITS', 'OIDS', 'FIVE', 'STATIC', 'ALGEBRA': > if v[i]: > v[i] = '[.%s]' % v[i] > options = cmd_options + [ > @@ -2881,9 +2893,9 @@ > "(default: <ext> = 'out' & 'err')"), > (None, 'S', 'sys', '<sys>', > "approve specific output *.<ext><sys>\n" > - "(<sys> = '[.(<OS>[<RELEASE>]|<DIST>[<VERSION>])][.(32|64)bit][.oid(32|64)][.Five][.STATIC]',\n" > - "(default: longest match for <sys> = '[.(%s[%s]|%s[%s])]%s%s%s%s')" > - % (v['OS'], v['RELEASE'], v['DIST'], v['VERSION'], v['BITS'], v['OIDS'], v['FIVE'], v['STATIC'])), > + "(<sys> = '[.(<OS>[<RELEASE>]|<DIST>[<VERSION>])][.(32|64)bit][.oid(32|64)][.Five][.STATIC][.Algebra]',\n" > + "(default: longest match for <sys> = '[.(%s[%s]|%s[%s])]%s%s%s%s%s')" > + % (v['OS'], v['RELEASE'], v['DIST'], v['VERSION'], v['BITS'], v['OIDS'], v['FIVE'], v['STATIC'], v['ALGEBRA'])), > (None, 'f', 'force', None, > "force approval of error messages (i.e., lines starting with '!')"), > ] > @@ -2934,8 +2946,8 @@ > if par['M5'] and par['PACKAGE'] == 'monetdb4': > ErrXit('"-5/--MonetDB5" conflicts with "--package=monetdb4"!') > if not par['M4'] and not par['M5']: > - par['M4'] = par['PACKAGE'] not in ['monetdb5', 'monetdb-datacell'] > - par['M5'] = par['PACKAGE'] in ['monetdb5', 'monetdb-datacell'] > + par['M4'] = par['PACKAGE'] not in ['monetdb5', 'monetdb-datacell', 'monetdb-template', 'monetdb-sql', 'monetdb-geom'] > + par['M5'] = par['PACKAGE'] in ['monetdb5', 'monetdb-datacell', 'monetdb-template', 'monetdb-sql', 'monetdb-geom'] > > config = opts.get('config') > if config is None and par['PACKAGE'] not in ('monetdb', 'monetdb-java', 'monetdb-clients'): > @@ -2950,10 +2962,15 @@ > except monet_options.Error: > sys.exit(1) > > + par['ALGEBRA'] = opts.get('algebra', 0) > par['RECURSIVE'] = opts.get('recursive', 0) > par['QUIET'] = opts.get('quiet', 0) > if THISFILE == "Mtest.py": > - par['IGNORE'] = opts.get('ignore', dftIGNORE) > + if par['ALGEBRA'] and par['PACKAGE'] == 'monetdb-sql': > + _IGNORE = '^[#%]' > + else: > + _IGNORE = dftIGNORE > + par['IGNORE'] = opts.get('ignore', _IGNORE) > par['CONTEXT'] = '-C%d' % int(opts.get('context', 1)) > a = int(opts.get('accuracy', 1)) > if a not in (-1,0,1,2): > @@ -3132,17 +3149,17 @@ > os.environ['DISTVER'] = DISTVER > os.environ['VERSION'] = VERSION > w = {} > - for i in 'OS', 'RELEASE', 'DIST', 'VERSION', 'BITS', 'OIDS', 'FIVE', 'STATIC': > + for i in 'OS', 'RELEASE', 'DIST', 'VERSION', 'BITS', 'OIDS', 'FIVE', 'STATIC', 'ALGEBRA': > w[i] = re.escape(v[i]) > - for i in 'BITS', 'OIDS', 'FIVE', 'STATIC': > + for i in 'BITS', 'OIDS', 'FIVE', 'STATIC', 'ALGEBRA': > j = 'TST_'+i > env[j] = v[i] > os.environ[j] = v[i] > if v[i]: > v[i] = '(.%s)?' % v[i] > w[i] = '(\.%s)?' % w[i] > - sv = '^(.(%s(%s)?|%s(%s)?))?%s%s%s%s$' % (v['OS'], v['RELEASE'], v['DIST'], v['VERSION'], v['BITS'], v['OIDS'], v['FIVE'], v['STATIC']) > - sw = '^(\.(%s(%s)?|%s(%s)?))?%s%s%s%s$' % (w['OS'], w['RELEASE'], w['DIST'], w['VERSION'], w['BITS'], w['OIDS'], w['FIVE'], w['STATIC']) > + sv = '^(.(%s(%s)?|%s(%s)?))?%s%s%s%s%s$' % (v['OS'], v['RELEASE'], v['DIST'], v['VERSION'], v['BITS'], v['OIDS'], v['FIVE'], v['STATIC'], v['ALGEBRA']) > + sw = '^(\.(%s(%s)?|%s(%s)?))?%s%s%s%s%s$' % (w['OS'], w['RELEASE'], w['DIST'], w['VERSION'], w['BITS'], w['OIDS'], w['FIVE'], w['STATIC'], w['ALGEBRA']) > r = re.compile(sw) > if not r.match(par['SYSTEM']): > ErrXit("System (-S) must match '"+sv+"' !") > @@ -3396,6 +3413,7 @@ > env['TST_OIDS'] = "" > env['TST_FIVE'] = "" > env['TST_STATIC'] = "" > + env['TST_ALGEBRA'] = "" > > is_sql = par['PACKAGE'] == 'monetdb-sql' > if not is_sql: > @@ -3491,7 +3509,7 @@ > env['VERSION'] = os.environ['VERSION'] > n = os.path.join(env['TSTTRGBASE'],TSTPREF,'.Mapprove.rc') > f = open(n, 'w') > - for v in 'OS', 'RELEASE', 'DIST', 'VERSION', 'TST_BITS', 'TST_OIDS', 'TST_FIVE', 'TST_STATIC': > + for v in 'OS', 'RELEASE', 'DIST', 'VERSION', 'TST_BITS', 'TST_OIDS', 'TST_FIVE', 'TST_STATIC', 'TST_ALGEBRA': > w = v.replace('TST_','') > f.write('%s = "%s"\n' % (w, env[v])) > f.close() > @@ -3537,6 +3555,7 @@ > product = os.path.split(env['TSTSRCBASE'])[-1] > if product == 'sql': > product += env['TST_FIVE'] > + product += env['TST_ALGEBRA'] > compiler = '' > if os.name == 'nt': > compiler = 'Mic' # Microsoft Visual Studio C > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins

2 2

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/src/tools/Tests mclient-lxquery--help.stable.out, , 1.5, 1.6 mclient-lxquery--help.stable.out.Darwin, , 1.4, 1.5
by Martin Kersten 28 Jan '08

28 Jan '08

Using this kind of switches is not in line with the other switches - the short-cut version sofar has been aligned with the first letter of the command - \ commands may optionally contain arguments, which seems that it is more in line to use e.g. '\g true' and '\g false' Same holds for '\A' and '\a' - \g is in Postgresql (and mysql) used as a \go shortcut - \g switch does not apply to mil and mal and should therefore be placed in the language specific help sections Stefan Manegold wrote: > Update of /cvsroot/monetdb/pathfinder/src/tools/Tests > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv30003 > > Modified Files: > mclient-lxquery--help.stable.out > mclient-lxquery--help.stable.out.Darwin > Log Message: > > approved new \G / \g switches > > > Index: mclient-lxquery--help.stable.out > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/src/tools/Tests/mclient-lxquery--help.stable.out,v > retrieving revision 1.5 > retrieving revision 1.6 > diff -u -d -r1.5 -r1.6 > --- mclient-lxquery--help.stable.out 19 Dec 2007 22:52:11 -0000 1.5 > +++ mclient-lxquery--help.stable.out 28 Jan 2008 18:35:44 -0000 1.6 > @@ -1,12 +1,14 @@ > stdout of test 'mclient-lxquery--help` in directory 'src/tools` itself: > > > -# 23:46:23 > > -# 23:46:23 > Mserver "--config=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/etc/MonetDB.conf" --debug=10 --set "monet_mod_path=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/lib64/MonetDB4:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/lib64/MonetDB4/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/lib64/MonetDB4/bin" --set "gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/var/MonetDB4/dbfarm" --set "sql_logdir=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/var/MonetDB4/sql_logs" --set "xquery_logdir=/ufs/manegold/_/scratch0/Monet > /Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/var/MonetDB4/xquery_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=34548 --set xrpc_port=49429 --set monet_prompt= --trace "--dbname=mTests_src_tools" "--dbinit= module(pathfinder);" ; echo ; echo Over.. > -# 23:46:23 > > +# 19:33:05 > > +# 19:33:05 > Mserver "--config=/ufs/manegold/_/scratch0/Monet/Testing/Current/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/etc/MonetDB.conf" --debug=10 --set "monet_mod_path=/ufs/manegold/_/scratch0/Monet/Testing/Current/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/lib64/MonetDB4:/ufs/manegold/_/scratch0/Monet/Testing/Current/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/lib64/MonetDB4/lib:/ufs/manegold/_/scratch0/Monet/Testing/Current/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/lib64/MonetDB4/bin" --set "gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Current/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/var/MonetDB4/dbfarm" --set "sql_logdir=/ufs/manegold/_/scratch0/Monet/Testing/Current/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/var/MonetDB4/sql_logs" --set "xquery_logdir=/ufs/manegold/_/scratch0 > /Monet/Testing/Current/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/var/MonetDB4/xquery_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=31795 --set xrpc_port=42301 --set monet_prompt= --trace "--dbname=mTests_src_tools" "--dbinit= module(pathfinder);" ; echo ; echo Over.. > +# 19:33:05 > > > -# MonetDB Server v4.20.1 > -# based on GDK v1.20.1 > + > + > +# MonetDB Server v4.21.0 > +# based on GDK v1.21.0 > # Copyright (c) 1993-2007, CWI. All rights reserved. > # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs; dynamically linked. > # Visit http://monetdb.cwi.nl/ for further information. > @@ -47,6 +49,8 @@ > \|cmd - pipe result to process, or stop when no command is given > \h - show the readline history > \t - toggle timer > +\G - switch to algebra frontend > +\g - switch to old frontend > \f - result format: dm or xml[-noheader][-typed|-noroot|-root-FOOBAR] > \L file - save client/server interaction > \X - trace mclient code > > Index: mclient-lxquery--help.stable.out.Darwin > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/src/tools/Tests/mclient-lxquery--help.stable.out.Darwin,v > retrieving revision 1.4 > retrieving revision 1.5 > diff -u -d -r1.4 -r1.5 > --- mclient-lxquery--help.stable.out.Darwin 19 Dec 2007 22:52:11 -0000 1.4 > +++ mclient-lxquery--help.stable.out.Darwin 28 Jan 2008 18:35:44 -0000 1.5 > @@ -1,12 +1,14 @@ > stdout of test 'mclient-lxquery--help` in directory 'src/tools` itself: > > > -# 23:46:23 > > -# 23:46:23 > Mserver "--config=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/etc/MonetDB.conf" --debug=10 --set "monet_mod_path=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/lib64/MonetDB4:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/lib64/MonetDB4/lib:/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/lib64/MonetDB4/bin" --set "gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/var/MonetDB4/dbfarm" --set "sql_logdir=/ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/var/MonetDB4/sql_logs" --set "xquery_logdir=/ufs/manegold/_/scratch0/Monet > /Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/var/MonetDB4/xquery_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=34548 --set xrpc_port=49429 --set monet_prompt= --trace "--dbname=mTests_src_tools" "--dbinit= module(pathfinder);" ; echo ; echo Over.. > -# 23:46:23 > > +# 19:33:05 > > +# 19:33:05 > Mserver "--config=/ufs/manegold/_/scratch0/Monet/Testing/Current/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/etc/MonetDB.conf" --debug=10 --set "monet_mod_path=/ufs/manegold/_/scratch0/Monet/Testing/Current/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/lib64/MonetDB4:/ufs/manegold/_/scratch0/Monet/Testing/Current/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/lib64/MonetDB4/lib:/ufs/manegold/_/scratch0/Monet/Testing/Current/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/lib64/MonetDB4/bin" --set "gdk_dbfarm=/ufs/manegold/_/scratch0/Monet/Testing/Current/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/var/MonetDB4/dbfarm" --set "sql_logdir=/ufs/manegold/_/scratch0/Monet/Testing/Current/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/var/MonetDB4/sql_logs" --set "xquery_logdir=/ufs/manegold/_/scratch0 > /Monet/Testing/Current/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/var/MonetDB4/xquery_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=31795 --set xrpc_port=42301 --set monet_prompt= --trace "--dbname=mTests_src_tools" "--dbinit= module(pathfinder);" ; echo ; echo Over.. > +# 19:33:05 > > > -# MonetDB Server v4.20.1 > -# based on GDK v1.20.1 > + > + > +# MonetDB Server v4.21.0 > +# based on GDK v1.21.0 > # Copyright (c) 1993-2007, CWI. All rights reserved. > # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs; dynamically linked. > # Visit http://monetdb.cwi.nl/ for further information. > @@ -46,6 +48,8 @@ > \>file - save response in file, or stdout if no file is given > \|cmd - pipe result to process, or stop when no command is given > \t - toggle timer > +\G - switch to algebra frontend > +\g - switch to old frontend > \f - result format: dm or xml[-noheader][-typed|-noroot|-root-FOOBAR] > \L file - save client/server interaction > \X - trace mclient code > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins >

2 2

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/optimizer/Tests remote00.stable.err, , 1.4, 1.5 remote00.stable.out, , 1.8, 1.9 remote01.stable.err, , 1.4, 1.5 remote01.stable.out, , 1.10, 1.11
by Stefan Manegold 27 Jan '08

27 Jan '08

Martin, please double check the results you approved. I hvaeno idea what the test (are supposed to) do, but a simple layman's sanity check reveals the following: - Test "remote00" contains six "io.print()", one with a literal "1", two with "mapi_port", and three with a BAT argument; however, the new stable output only contains a "[ 1 ]", the two mapi_ports and two BATs (there was no third?) have been removed by your checkin ... ? - Test "remote01" prints 4 BATs and one count; however, your changes of the stable (corrct?) output replace the last two BATs and the count by error messages ... ? Thanks! Stefan On Sun, Jan 27, 2008 at 08:36:49AM +0000, Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/src/optimizer/Tests > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv8290/Tests > > Modified Files: > remote00.stable.err remote00.stable.out remote01.stable.err > remote01.stable.out > Log Message: > Approve test output > > > Index: remote00.stable.out > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/optimizer/Tests/remote00.stable.out,v > retrieving revision 1.8 > retrieving revision 1.9 > diff -u -d -r1.8 -r1.9 > --- remote00.stable.out 21 Aug 2006 14:40:36 -0000 1.8 > +++ remote00.stable.out 27 Jan 2008 08:36:46 -0000 1.9 > @@ -1,41 +1,25 @@ > stdout of test 'remote00` in directory 'src/optimizer` itself: > > > -# 23:06:19 > > -# 23:06:19 > Mtimeout -timeout 60 mserver5 "--config=/ufs/mk/monet5/Linux/etc/MonetDB5.conf" --debug=10 --set "monet_mod_path=/ufs/mk/monet5/Linux/lib/MonetDB5:/ufs/mk/opensource/MonetDB/Linux/lib/MonetDB" --set "gdk_dbfarm=/ufs/mk/monet5/Linux/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/mk/monet5/Linux/var/MonetDB5/dblogs" --set mapi_port=30126 --set monet_prompt= --trace --dbname=mTests_src_optimizer remote00.mal < /dev/null > -# 23:06:19 > > +# 09:35:05 > > +# 09:35:05 > /usr/bin/python remote00.py remote00 > +# 09:35:05 > > > -# MonetDB Server v4.99.19 > -# Copyright (c) 1993-2006 CWI, all rights reserved > -# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked > -# config:/ufs/mk/monet5/Linux/etc/MonetDB5.conf > -# dbfarm:/ufs/mk/monet5/Linux/var/MonetDB5/dbfarm > -# dbname:mTests_src_optimizer > +# MonetDB server v5.3.0, based on kernel v1.21.0 > +# Serving database 'db1' > +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked > +# Copyright (c) 1993-2007 CWI, all rights reserved > # Visit http://monetdb.cwi.nl/ for further information > +# Listening for connection requests on mapi:monetdb://gio.ins.cwi.nl:12345/ > [ 1 ] > -[ "12345" ] > -# MonetDB Server v4.99.19 > -# Copyright (c) 1993-2006 CWI, all rights reserved > -# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked > -# config:/ufs/niels/scratch/Linux-x86_64/etc/MonetDB5.conf > -# dbfarm:/ufs/niels/scratch/Linux-x86_64/var/MonetDB5/dbfarm > -# dbname:db2 > +# MonetDB server v5.3.0, based on kernel v1.21.0 > +# Serving database 'db2' > +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked > +# Copyright (c) 1993-2007 CWI, all rights reserved > # Visit http://monetdb.cwi.nl/ for further information > -[ "12346" ] > -#-----------------# > -# h t # name > -# int int # type > -#-----------------# > -[ 1, 1 ] > -[ 2, 7 ] > -[ 1 ] > -#-----------------# > -# h t # name > -# int int # type > -#-----------------# > -[ 2, 7 ] > +# Listening for connection requests on mapi:monetdb://gio.ins.cwi.nl:12346/ > > -# 16:36:12 > > -# 16:36:12 > Done. > -# 16:36:12 > > +# 09:35:07 > > +# 09:35:07 > Done. > +# 09:35:07 > > > > Index: remote00.stable.err > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/optimizer/Tests/remote00.stable.err,v > retrieving revision 1.4 > retrieving revision 1.5 > diff -u -d -r1.4 -r1.5 > --- remote00.stable.err 26 Jan 2008 13:34:23 -0000 1.4 > +++ remote00.stable.err 27 Jan 2008 08:36:46 -0000 1.5 > @@ -1,12 +1,16 @@ > stderr of test 'remote00` in directory 'src/optimizer` itself: > > > -# 23:06:19 > > -# 23:06:19 > Mtimeout -timeout 60 mserver5 "--config=/ufs/mk/monet5/Linux/etc/MonetDB5.conf" --debug=10 --set "monet_mod_path=/ufs/mk/monet5/Linux/lib/MonetDB5:/ufs/mk/opensource/MonetDB/Linux/lib/MonetDB" --set "gdk_dbfarm=/ufs/mk/monet5/Linux/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/mk/monet5/Linux/var/MonetDB5/dblogs" --set mapi_port=30126 --set monet_prompt= --trace --dbname=mTests_src_optimizer remote00.mal < /dev/null > -# 23:06:19 > > +# 09:35:05 > > +# 09:35:05 > /usr/bin/python remote00.py remote00 > +# 09:35:05 > > > +#warning: please don't forget to set your vault key! > +#(see /ufs/mk/monet5/Linux/etc/monetdb5.conf) > +#warning: please don't forget to set your vault key! > +#(see /ufs/mk/monet5/Linux/etc/monetdb5.conf) > > -# 23:06:19 > > -# 23:06:19 > Done. > -# 23:06:19 > > +# 09:35:07 > > +# 09:35:07 > Done. > +# 09:35:07 > > > > Index: remote01.stable.err > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/optimizer/Tests/remote01.stable.err,v > retrieving revision 1.4 > retrieving revision 1.5 > diff -u -d -r1.4 -r1.5 > --- remote01.stable.err 26 Jan 2008 13:34:23 -0000 1.4 > +++ remote01.stable.err 27 Jan 2008 08:36:46 -0000 1.5 > @@ -1,12 +1,14 @@ > stderr of test 'remote01` in directory 'src/optimizer` itself: > > > -# 23:06:19 > > -# 23:06:19 > Mtimeout -timeout 60 mserver5 "--config=/ufs/mk/monet5/Linux/etc/MonetDB5.conf" --debug=10 --set "monet_mod_path=/ufs/mk/monet5/Linux/lib/MonetDB5:/ufs/mk/opensource/MonetDB/Linux/lib/MonetDB" --set "gdk_dbfarm=/ufs/mk/monet5/Linux/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/mk/monet5/Linux/var/MonetDB5/dblogs" --set mapi_port=30126 --set monet_prompt= --trace --dbname=mTests_src_optimizer remote01.mal < /dev/null > -# 23:06:19 > > +# 09:35:05 > > +# 09:35:05 > mserver5 "--config=/ufs/mk/monet5/Linux/etc/monetdb5.conf" --debug=10 --set "monet_mod_path=/ufs/mk/monet5//Linux/lib/MonetDB5:/ufs/mk/monet5//Linux/lib/MonetDB5/lib:/ufs/mk/monet5//Linux/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/mk/monet5//Linux/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/mk/monet5//Linux/var/MonetDB5/sql_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=39715 --set xrpc_port=43844 --set monet_prompt= --trace --dbname=mTests_src_optimizer remote01.mal > +# 09:35:05 > > > +#warning: please don't forget to set your vault key! > +#(see /ufs/mk/monet5/Linux/etc/monetdb5.conf) > > -# 23:06:19 > > -# 23:06:19 > Done. > -# 23:06:19 > > +# 09:35:05 > > +# 09:35:05 > Done. > +# 09:35:05 > > > > Index: remote01.stable.out > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/optimizer/Tests/remote01.stable.out,v > retrieving revision 1.10 > retrieving revision 1.11 > diff -u -d -r1.10 -r1.11 > --- remote01.stable.out 8 Jun 2007 08:47:31 -0000 1.10 > +++ remote01.stable.out 27 Jan 2008 08:36:46 -0000 1.11 > @@ -1,36 +1,53 @@ > stdout of test 'remote01` in directory 'src/optimizer` itself: > > > -# 23:06:19 > > -# 23:06:19 > Mtimeout -timeout 60 mserver5 "--config=/ufs/mk/monet5/Linux/etc/MonetDB5.conf" --debug=10 --set "monet_mod_path=/ufs/mk/monet5/Linux/lib/MonetDB5:/ufs/mk/opensource/MonetDB/Linux/lib/MonetDB" --set "gdk_dbfarm=/ufs/mk/monet5/Linux/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/mk/monet5/Linux/var/MonetDB5/dblogs" --set mapi_port=30126 --set monet_prompt= --trace --dbname=mTests_src_optimizer remote01.mal < /dev/null > -# 23:06:19 > > +# 09:35:05 > > +# 09:35:05 > mserver5 "--config=/ufs/mk/monet5/Linux/etc/monetdb5.conf" --debug=10 --set "monet_mod_path=/ufs/mk/monet5//Linux/lib/MonetDB5:/ufs/mk/monet5//Linux/lib/MonetDB5/lib:/ufs/mk/monet5//Linux/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/mk/monet5//Linux/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/mk/monet5//Linux/var/MonetDB5/sql_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=39715 --set xrpc_port=43844 --set monet_prompt= --trace --dbname=mTests_src_optimizer remote01.mal > +# 09:35:05 > > > -# MonetDB Server v4.99.19 > -# Copyright (c) 1993-2006 CWI, all rights reserved > -# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked > -# config:/ufs/mk/monet5/Linux/etc/MonetDB5.conf > -# dbfarm:/ufs/mk/monet5/Linux/var/MonetDB5/dbfarm > -# dbname:mTests_src_optimizer > +# MonetDB server v5.3.0, based on kernel v1.21.0 > +# Serving database 'mTests_src_optimizer' > +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked > +# Copyright (c) 1993-2007 CWI, all rights reserved > # Visit http://monetdb.cwi.nl/ for further information > +# Listening for connection requests on mapi:monetdb://gio.ins.cwi.nl:39715/ > ## First test of the remoteQueries optimizer > ## we create a remote bat and fake a bind operation. > # > -#mid:= mserver.reconnect("s0_0","localhost",50000,"monetdb","monetdb","mal"); > -#mserver.rpc(mid,"rb:= bat.new(:int,:int); bat.setName(rb,\"rbat\"); bat.insert(rb,1,1);"); > +#cat:= inspect.getEnvironment(); > +#fs := algebra.find(cat,"mapi_port"); > +#port := calc.int(fs); > +##io.printf("port %d\n",port); > # > -#b:bat[:int,:int]:= mserver.bind(mid,"rbat"); > -#mserver.rpc(mid,"c:=algebra.select(b,0,12);"); > -#c:bat[:int,:int]:= mserver.rpc(mid, "io.print(c);"); > +#mid:= mapi.reconnect("localhost",port,"s0_0","monetdb","monetdb","mal"); > +#mapi.rpc(mid,"rb:= bat.new(:int,:int); bat.setName(rb,\"rbat\");"); > +#mapi.rpc(mid,"bat.insert(rb,1,1);"); > +#mapi.rpc(mid,"bat.insert(rb,3,3);"); > +#mapi.rpc(mid,"bat.insert(rb,5,5);"); > +#mapi.rpc(mid,"bat.insert(rb,6,6);"); > +#mapi.rpc(mid,"bat.insert(rb,7,7);"); > +#mapi.rpc(mid,"c:=algebra.select(rb,0,12);"); > +#c:bat[:int,:int]:= mapi.rpc(mid, "io.print(c);"); > #io.print(c); > -#mserver.rpc(mid,"d:=algebra.select(b,5,10);"); > +#mapi.rpc(mid,"c:=algebra.select(rb,0,4);"); > +#c:bat[:int,:int]:= mapi.rpc(mid, "io.print(c);"); > +#io.print(c); > +# > +#b:bat[:int,:int]:= mapi.bind(mid,"rbat"); > +#io.print(b); > +# > +## see if we can do some remote selections. > +#mapi.rpc(mid,"d:=algebra.select(b,5,10);"); > #low:= 5+1; > -#mserver.put(mid,"low",low); > -#mserver.rpc(mid,"e:=algebra.select(d,low,7);"); > -#mserver.rpc(mid,"i:=aggr.count(d);"); > -#i:lng:= mserver.rpc(mid,"io.print(i);"); > +#mapi.put(mid,"low",low); > +#mapi.rpc(mid,"e:=algebra.select(d,low,7);"); > +#mapi.rpc(mid,"i:=aggr.count(d);"); > +#i:lng:= mapi.rpc(mid,"io.print(i);"); > #io.printf(" count %d\n",i); > -#d:bat[:int,:int]:= mserver.rpc(mid,"io.print(d);"); > +#d:bat[:int,:int]:= mapi.rpc(mid,"io.print(d);"); > #io.print(d); > +#mapi.disconnect(mid); > +#optimizer.remoteQueries(); > # > function user.main():void; # 0 (main:void) > # First test of the remoteQueries optimizer # 1 (_1:str) > @@ -39,34 +56,33 @@ > fs := algebra.find(cat,"mapi_port"); # 4 ALGfind (fs:str)<-(cat:bat[:str,:str])(_5:str) > port := calc.int(fs); # 5 CALCstr2int (port:int)<-(fs:str) > #io.printf("port %d\n",port); # 6 (_7:str) > - mid := mserver.reconnect("localhost",port,"s0_0","monetdb","monetdb","mal"); # 7 SERVERreconnectAlias (mid:int)<-(_9:str)(port:int)(_10:str)(_11:str)(_11:str)(_12:str) > - mserver.rpc(mid,"rb:= bat.new(:int,:int); bat.setName(rb,\"rbat\");"); # 8 SERVERquery (_13:void)<-(mid:int)(_14:str) > - mserver.rpc(mid,"bat.insert(rb,1,1);"); # 9 SERVERquery (_15:void)<-(mid:int)(_16:str) > - mserver.rpc(mid,"bat.insert(rb,3,3);"); # 10 SERVERquery (_17:void)<-(mid:int)(_18:str) > - mserver.rpc(mid,"bat.insert(rb,5,5);"); # 11 SERVERquery (_19:void)<-(mid:int)(_20:str) > - mserver.rpc(mid,"bat.insert(rb,6,6);"); # 12 SERVERquery (_21:void)<-(mid:int)(_22:str) > - mserver.rpc(mid,"bat.insert(rb,7,7);"); # 13 SERVERquery (_23:void)<-(mid:int)(_24:str) > - mserver.rpc(mid,"c:=algebra.select(rb,0,12);"); # 14 SERVERquery (_25:void)<-(mid:int)(_26:str) > - c:bat[:int,:int] := mserver.rpc(mid,"io.print(c);"); # 15 SERVERmapi_rpc_bat (c:bat[:int,:int])<-(mid:int)(_28:str) > + mid := mapi.reconnect("localhost",port,"s0_0","monetdb","monetdb","mal"); # 7 SERVERreconnectAlias (mid:int)<-(_9:str)(port:int)(_10:str)(_11:str)(_11:str)(_12:str) > + mapi.rpc(mid,"rb:= bat.new(:int,:int); bat.setName(rb,\"rbat\");"); # 8 SERVERquery (_13:void)<-(mid:int)(_14:str) > + mapi.rpc(mid,"bat.insert(rb,1,1);"); # 9 SERVERquery (_15:void)<-(mid:int)(_16:str) > + mapi.rpc(mid,"bat.insert(rb,3,3);"); # 10 SERVERquery (_17:void)<-(mid:int)(_18:str) > + mapi.rpc(mid,"bat.insert(rb,5,5);"); # 11 SERVERquery (_19:void)<-(mid:int)(_20:str) > + mapi.rpc(mid,"bat.insert(rb,6,6);"); # 12 SERVERquery (_21:void)<-(mid:int)(_22:str) > + mapi.rpc(mid,"bat.insert(rb,7,7);"); # 13 SERVERquery (_23:void)<-(mid:int)(_24:str) > + mapi.rpc(mid,"c:=algebra.select(rb,0,12);"); # 14 SERVERquery (_25:void)<-(mid:int)(_26:str) > + c:bat[:int,:int] := mapi.rpc(mid,"io.print(c);"); # 15 SERVERmapi_rpc_bat (c:bat[:int,:int])<-(mid:int)(_28:str) > io.print(c); # 16 IOprint_val (_29:void)<-(c:bat[:int,:int]) > - mserver.rpc(mid,"c:=algebra.select(rb,0,4);"); # 17 SERVERquery (_30:void)<-(mid:int)(_31:str) > - c:bat[:int,:int] := mserver.rpc(mid,"io.print(c);"); # 18 SERVERmapi_rpc_bat (c:bat[:int,:int])<-(mid:int)(_28:str) > + mapi.rpc(mid,"c:=algebra.select(rb,0,4);"); # 17 SERVERquery (_30:void)<-(mid:int)(_31:str) > + c:bat[:int,:int] := mapi.rpc(mid,"io.print(c);"); # 18 SERVERmapi_rpc_bat (c:bat[:int,:int])<-(mid:int)(_28:str) > io.print(c); # 19 IOprint_val (_32:void)<-(c:bat[:int,:int]) > - mserver.rpc(mid,"b:bat[:int,:int] := bbp.bind(\"rbat\":str);"); # 20 SERVERmapi_rpc_bat (_57:bat[:int,:int])<-(mid:int)(_58:str) > - b:bat[:int,:int] := mserver.rpc(mid,"io.print(b);"); # 21 SERVERmapi_rpc_bat (b:bat[:int,:int])<-(mid:int)(_60:str) > - io.print(b); # 22 IOprint_val (_35:void)<-(b:bat[:int,:int]) > -# see if we can do some remote selections. # 23 (_36:str) > - mserver.rpc(mid,"d:=algebra.select(b,5,10);"); # 24 SERVERquery (_37:void)<-(mid:int)(_38:str) > - low := calc.+(5,1); # 25 CALCbinaryADDintint (low:int)<-(_40:int)(_41:int) > - mserver.put(mid,"low",low); # 26 SERVERput (_42:void)<-(mid:int)(_43:str)(low:int) > - mserver.rpc(mid,"e:=algebra.select(d,low,7);"); # 27 SERVERquery (_44:void)<-(mid:int)(_45:str) > - mserver.rpc(mid,"i:=aggr.count(d);"); # 28 SERVERquery (_46:void)<-(mid:int)(_47:str) > - i:lng := mserver.rpc(mid,"io.print(i);"); # 29 SERVERmapi_rpc_single_row (i:lng)<-(mid:int)(_49:str) > - io.printf(" count %d\n",i); # 30 IOprint_formatted_lng (_50:void)<-(_51:str)(i:lng) > - d:bat[:int,:int] := mserver.rpc(mid,"io.print(d);"); # 31 SERVERmapi_rpc_bat (d:bat[:int,:int])<-(mid:int)(_53:str) > - io.print(d); # 32 IOprint_val (_54:void)<-(d:bat[:int,:int]) > - mserver.disconnect(mid); # 33 SERVERdisconnect (_55:void)<-(mid:int) > -end main; # 34 > + b:bat[:int,:int] := mapi.bind(mid,"rbat"); # 20 SERVERbindBAT (b:bat[:int,:int])<-(mid:int)(_34:str) > + io.print(b); # 21 IOprint_val (_35:void)<-(b:bat[:int,:int]) > +# see if we can do some remote selections. # 22 (_36:str) > + mapi.rpc(mid,"d:=algebra.select(b,5,10);"); # 23 SERVERquery (_37:void)<-(mid:int)(_38:str) > + low := calc.+(5,1); # 24 CALCbinaryADDintint (low:int)<-(_40:int)(_41:int) > + mapi.put(mid,"low",low); # 25 SERVERput (_42:void)<-(mid:int)(_43:str)(low:int) > + mapi.rpc(mid,"e:=algebra.select(d,low,7);"); # 26 SERVERquery (_44:void)<-(mid:int)(_45:str) > + mapi.rpc(mid,"i:=aggr.count(d);"); # 27 SERVERquery (_46:void)<-(mid:int)(_47:str) > + i:lng := mapi.rpc(mid,"io.print(i);"); # 28 SERVERmapi_rpc_single_row (i:lng)<-(mid:int)(_49:str) > + io.printf(" count %d\n",i); # 29 IOprint_formatted_lng (_50:void)<-(_51:str)(i:lng) > + d:bat[:int,:int] := mapi.rpc(mid,"io.print(d);"); # 30 SERVERmapi_rpc_bat (d:bat[:int,:int])<-(mid:int)(_53:str) > + io.print(d); # 31 IOprint_val (_54:void)<-(d:bat[:int,:int]) > + mapi.disconnect(mid); # 32 SERVERdisconnect (_55:void)<-(mid:int) > +end main; # 33 > #-----------------# > # h t # name > # int int # type > @@ -82,25 +98,12 @@ > #-----------------# > [ 1, 1 ] > [ 3, 3 ] > -#-----------------# > -# h t # name > -# int int # type > -#-----------------# > -[ 1, 1 ] > -[ 3, 3 ] > -[ 5, 5 ] > -[ 6, 6 ] > -[ 7, 7 ] > - count 3 > -#-----------------# > -# h t # name > -# int int # type > -#-----------------# > -[ 5, 5 ] > -[ 6, 6 ] > -[ 7, 7 ] > +!MALException:mapi.bind:remote error: SyntaxException:parseError:b:bat[int,int]:=bbp.bind("rbat"); > +!MALException:mapi.bind:remote error:SyntaxException:parseError: ^',' expected > +!MALException:mapi.bind:remote error:SyntaxException:parseError: > +!MALException:mapi.bind:remote error:';' expected > > -# 23:06:19 > > -# 23:06:19 > Done. > -# 23:06:19 > > +# 09:35:05 > > +# 09:35:05 > Done. > +# 09:35:05 > > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > 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] re compiling on darwin9
by Stefan Manegold 22 Jan '08

22 Jan '08

Hi, I just made a very simple attempt to fix the problem by ensuring that --enable-oid32 is handled and MONET_OID32 defined only with 64-bit builds (but ignored/unset otherwise); see also [ 1876580 ] Compile MonetDB on Darwin 9: failed by --enable-oid32 https://sourceforge.net/tracker/index.php?func=detail&aid=1876580&group_id=… If this works, we're fine. If not, we can go back to the previous situtation (before Fabian's changes in buildtools/conf/MonetDB.m4), i.e., --enable-bits is only handled on platform where it is known to work (incl. Darwin 8), while on other platforms (e.g., Darwin 9; or when using the Intel compiler), configure stops with the following advice: "case "$GCC-$CC-$host_os-$host-$bits" not handled with --enable-bits, yet; please use CC, CFLAGS and/or LDFLAGS (instead of --enable-bits=$bits) to make "$CC" produce $bits-bit code" (obviously with the variables replaced with the respective values...) Stefan On Tue, Jan 22, 2008 at 10:25:37AM +0100, Fabian Groffen wrote: > I just noticed > http://article.gmane.org/gmane.comp.db.monetdb.devel/937 > > > > (3) Indeed, even though it does not make sense, we should not crash on > > > "--enable-bits=32 --enable-oid32", but either (preferred) handle it > > > correctly (e.g., by ignoring the latter in case the former holds > > > (regardless of whether requested explicitly or simply by being the > > > default)), or (at the very least) stop with a proper message > > > saying that > > > it is not required to specify the redundant information. > > > > I would prefer to give a message that the redundant "--enable-oid32" > > has been discarded and continue. > > I think the only "redundant" option here is --enable-bits. Simply > because --enable-bits only works for GNU multilib compilers, but it > doesn't check them, and also assumes every compiler to be a multilib > compiler. I noticed so when I changed MonetDB.m4 for Jennie. > > The correct way to deal with multilib compilers is to leave it up to the > user, e.g. set CC="gcc -m64" or CC="gcc64" or CHOST/CTARGET=xxx64-xx-xx. > Having configure have a flag that switches on the -mX per magic is > rather misleading, and from the auto* world's point of view something > that should have happened outside. I guess we run the test for the flag > early enough in the process such that all AC_COMPILE tests use the -mX > flag, but still I think it would clean things up when the flag would > disappear. > > (I cannot reply on the thread, because I am not subscribed to the > list/didn't receive the message.) -- | 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] Compiling on Darwin 7
by Fabian Groffen 21 Jan '08

21 Jan '08

Is there anyone that can think of a solution for this problem? cc1: warnings being treated as errors /Volumes/Scratch/monetdb/stable/monetdb/src/modules/plain/bat.mx: In function 'local_itoa': /Volumes/Scratch/monetdb/stable/monetdb/src/modules/plain/bat.mx:1253: warning: format '%zd' expects type 'signed size_t', but argument 4 has type 'ssize_t' I mean... is there a difference between "signed size_t" and "ssize_t"? Ehrm. [Orion:src/modules/plain] fabian% uname -a Darwin Orion.local 7.9.0 Darwin Kernel Version 7.9.0: Wed Mar 30 20:11:17 PST 2005; root:xnu/xnu-517.12.7.obj~1/RELEASE_PPC Power Macintosh powerpc PowerBook4,3 Darwin [Orion:src/modules/plain] fabian% gcc --version gcc (GCC) 4.0.1 (Apple Computer, Inc. build 5341) Copyright (C) 2005 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Probably just need to compile without -Werror.

4 5

Re: [Monetdb-developers] [Monetdb-checkins] buildtools/conf MonetDB.m4, MonetDB_1-20, 1.37.2.18, 1.37.2.19
by Ying Zhang 21 Jan '08

21 Jan '08

helaas, als ik de stable brach compileer, krijg ik steeds de selfde error, misschien is de string "+yes-*-darwin[89]*-powerpc*-* | yes-*- darwin[89]*-i386*-* | yes-*-darwin[89]*-x86_64*-*)" waar het script naar kijkt niet correct, mijn gcc zegt namelijk zo iets: $ gcc i686-apple-darwin9-gcc-4.0.1: no input files ik kan dit zelf wel uitzoeken, denk ik, maar niet nu:) Als ik "--enable-bits" helemaal niet gebruikt, compileert het als een speer:) Ik kan alleen de tijah module net laden in mserver, maar dat is een ander verhaal. Jennie On Jan 18, 2008, at 10:34 , Fabian wrote: > Update of /cvsroot/monetdb/buildtools/conf > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv25825 > > Modified Files: > Tag: MonetDB_1-20 > MonetDB.m4 > Log Message: > Add support for 64-bits with GCC 4 on Solaris and on Darwin 9 and > Darwin on Intel > > Index: MonetDB.m4 > =================================================================== > RCS file: /cvsroot/monetdb/buildtools/conf/MonetDB.m4,v > retrieving revision 1.37.2.18 > retrieving revision 1.37.2.19 > diff -u -d -r1.37.2.18 -r1.37.2.19 > --- MonetDB.m4 22 Nov 2007 15:44:17 -0000 1.37.2.18 > +++ MonetDB.m4 18 Jan 2008 09:34:48 -0000 1.37.2.19 > @@ -490,8 +490,8 @@ > ;; > yes-*-solaris*-*-*) > case `$bits-$CC -v 2>&1` in > - 32-*|*-*'gcc version 3.'*) ;; > - *) AC_MSG_ERROR([need GCC version 3.X for 64 bits]);; > + 32-*|*-*'gcc version '[34]'.'*) ;; > + *) AC_MSG_ERROR([need GCC version >=3.X for 64 bits]);; > esac > CC="$CC -m$bits" > ;; > @@ -520,7 +520,8 @@ > -*pgcc*-linux*-x86_64*-*) > CC="$CC -tp=k8-$bits" > ;; > -yes-*-darwin8*-powerpc*-*) > +yes-*-darwin[89]*-powerpc*-* | yes-*-darwin[89]*-i386*-* | yes-*- > darwin[89]*-x86_64*-*) > + # Darwin/OSX cases > CC="$CC -m$bits" > ;; > *) > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins

2 8

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/modules/mal/Tests remote04.mal, , NONE, 1.1 remote05.mal, , NONE, 1.1
by Romulo Goncalves 20 Jan '08

20 Jan '08

Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/src/modules/mal/Tests > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv31308 > > Added Files: > remote04.mal remote05.mal > Log Message: > Examples of poor-mans bat transport. > > > --- NEW FILE: remote04.mal --- > #this example tests recieving tuple values as part of the > #MAL interface. > > b:bat[:oid,:int]:=mserver.receive(); > [ 0@0, 1] > [ 0@1, 2] > > c:bat[:oid,:str]:=mserver.receive(); > [ 0@0, "hello"] > [ 0@1, "world"] > > io.print(b); > io.print(c); > > --- NEW FILE: remote05.mal --- > #this example tests recieving tuple values as part of the > #MAL interface. > # now in a remote setting > > include remote; > # for testweb, we need to ask the server itself how it is available, use > # sabaoth for that > include sabaoth; > > h := sabaoth.getLocalConnectionHost(); > p := sabaoth.getLocalConnectionPort(); > > # create a connecton to ourself > remote.create("test", h, p, nil:str, "monetdb", "monetdb"); > > b:= bat.new(:oid,:str); > bat.insert( 0@0, "hello"); > bat.insert( 0@1, "world"); Shouldn't here be: bat.insert( b, 0@0, 1); bat.insert( b, 0@1, 2); Because your remote site is expecting to receive b:bat[:oid,:int]:=mserver.receive(); Romulo > > # store the values > remote.send("test",b); > c:= remote.query("test","io.print(b);") > io.print(c); > # shutdown > remote.destroy("test"); > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins

1 0

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/runtime/xrpc/export xrpc.html, xquery-decomposition, 1.3, 1.3.2.1
by Sjoerd Mullender 17 Jan '08

17 Jan '08

Should this also be fixed on the main branch? Ying Zhang wrote: > Update of /cvsroot/monetdb/pathfinder/runtime/xrpc/export > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv26528 > > Modified Files: > Tag: xquery-decomposition > xrpc.html > Log Message: > fixed wrong link > > > > Index: xrpc.html > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/runtime/xrpc/export/xrpc.html,v > retrieving revision 1.3 > retrieving revision 1.3.2.1 > diff -u -d -r1.3 -r1.3.2.1 > --- xrpc.html 18 Dec 2007 21:02:22 -0000 1.3 > +++ xrpc.html 17 Jan 2008 12:11:33 -0000 1.3.2.1 > @@ -40,7 +40,7 @@ > For more information on XRPC, check the following sources: > <ul> > <li> the XRPC <a href="http://monetdb.cwi.nl/XQuery/QuickTour/XRPC">tutorial</a> > - <li> the XRPC <a href="http://monetdb.cwi.nl/XQuery/Documentation/XRPC/">reference manual</a> > + <li> the XRPC <a href="http://monetdb.cwi.nl/XQuery/Documentation/XRPC-Extension.html">reference manual</a> > <li> the XRPC <a href="http://www.cwi.nl/htbin/ins1/publications?request=intabstract&key=ZhBo:VLDB…">VLDB Paper</a> > </ul> > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins -- Sjoerd Mullender

2 2

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/src/sqlhelpers/xmlshred encoding.c, , 1.15, 1.16 hash.c, , 1.7, 1.8
by Sjoerd Mullender 10 Jan '08

10 Jan '08

Why did you move the include of pf_config.h? Generally, the *config.h files need to be *first*. Torsten Grust wrote: > Update of /cvsroot/monetdb/pathfinder/src/sqlhelpers/xmlshred > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv10014 > > Modified Files: > encoding.c hash.c > Log Message: > -- pfshred now requires SAX2 (namespace URI processing) > > -- Local name and URI hash tables operate with xmlChar* values > > > > Index: encoding.c > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/src/sqlhelpers/xmlshred/encoding.c,v > retrieving revision 1.15 > retrieving revision 1.16 > diff -u -d -r1.15 -r1.16 > --- encoding.c 9 Jan 2008 09:16:05 -0000 1.15 > +++ encoding.c 10 Jan 2008 09:02:16 -0000 1.16 > @@ -25,13 +25,14 @@ > * $Id$ > */ > > -#include "pf_config.h" > #include <stdio.h> > #include <string.h> > > /* libxml SAX2 parser internals */ > #include "libxml/parserInternals.h" > > +#include "pf_config.h" > + > #include "encoding.h" > #include "guides.h" > #include "oops.h" > @@ -40,6 +41,9 @@ > > #include <assert.h> > > +#ifndef HAVE_SAX2 > + #error "libxml2 SAX2 interface required to compile the XML shredder `pfshred'" > +#endif > > FILE *out; > FILE *out_attr; > @@ -256,15 +260,14 @@ > > if (!localname) > return -1; > + > + localname_id = hashtable_find (localname_hash, localname); > > - localname_id = hashtable_find (localname_hash, (char *) localname); > - > - /* key not found */ > if (NOKEY (localname_id)) { > - /* create a new name id */ > + /* key not found, create a new name id */ > localname_id = global_localname_id++; > - /* add the pair into the hashtable */ > - hashtable_insert (localname_hash, (char *) localname, localname_id); > + /* add the (localname, localname_id) pair into the hash table */ > + hashtable_insert (localname_hash, localname, localname_id); > /* print the name binding if necessary */ > if (shredstate.names_separate) > fprintf (out_names, "%i, \"%s\"\n", localname_id, (char*) localname); > @@ -282,14 +285,13 @@ > if (!URI) > return -1; > > - uri_id = hashtable_find (uris_hash, (char *) URI); > + uri_id = hashtable_find (uris_hash, URI); > > - /* key not found */ > if (NOKEY (uri_id)) { > - /* create a new URI id */ > + /* key not found, create a new URI id */ > uri_id = global_uri_id++; > - /* add the pair into the hashtable */ > - hashtable_insert (uris_hash, (char *) URI, uri_id); > + /* add the (URI, uri_id) pair to the hash table */ > + hashtable_insert (uris_hash, URI, uri_id); > /* print the URI binding if necessary */ > if (shredstate.names_separate) > fprintf (out_uris, "%i, \"%s\"\n", uri_id, (char*) URI); > @@ -313,7 +315,8 @@ > > /* check if tagname is larger than TAG_SIZE characters */ > if (localname && xmlStrlen (localname) > TAG_SIZE) > - BAILOUT ("attribute local name `%s' exceeds %u characters", localname, TAG_SIZE); > + BAILOUT ("attribute local name `%s' exceeds %u characters", > + localname, TAG_SIZE); > > if (URI && xmlStrlen (URI) > TAG_SIZE) > BAILOUT ("namespace URI `%s' exceeds length of %u characters", > @@ -686,7 +689,7 @@ > report (void) > { > if (text_stripped > 0) { > - fprintf (err, "%u values were stripped to %u " > + fprintf (err, "%u text node/attribute values were stripped to %u " > "character(s).\n", text_stripped, text_size); > } > } > > Index: hash.c > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/src/sqlhelpers/xmlshred/hash.c,v > retrieving revision 1.7 > retrieving revision 1.8 > diff -u -d -r1.7 -r1.8 > --- hash.c 8 Jan 2008 10:00:07 -0000 1.7 > +++ hash.c 10 Jan 2008 09:02:16 -0000 1.8 > @@ -25,39 +25,39 @@ > * $Id$ > */ > > -#include "pf_config.h" > -#include "hash.h" > -#include "shred_helper.h" > #include <string.h> > #include <unistd.h> > #include <assert.h> > > +#include "pf_config.h" > +#include "hash.h" > +#include "shred_helper.h" > + > /* We use a seperate chaining strategy to > - * mantain our hash_table, > - * So each bucket is a chained list itself, > - * to handle possible collisions. > + * mantain our hash table, so each bucket is a chained list itself > + * to handle collisions. > */ > struct bucket_t { > - char *key; /**< key as string */ > - int id; /**< name_id */ > - bucket_t* next; /**< next bucket in our list */ > + xmlChar *key; /**< key (elem/attr name or namespace URI) */ > + int id; /**< name_id */ > + bucket_t *next; /**< next bucket in overflow chain */ > }; > > -/* size of the hashtable */ > +/* hashtable size */ > #define PRIME 113 > > /** > - * Lookup an id in a given bucket using it associated key. > + * Lookup an id in a given bucket using its associated key. > */ > static int > -find_id (bucket_t *bucket, char *key) > +find_id (bucket_t *bucket, const xmlChar *key) > { > bucket_t *cur_bucket = bucket; > > assert (key); > > while (cur_bucket) > - if (strcmp (cur_bucket->key, key) == 0) > + if (xmlStrcmp (cur_bucket->key, key) == 0) > return cur_bucket->id; > else > cur_bucket = cur_bucket->next; > @@ -69,16 +69,16 @@ > * Attach an (id, key) pair to a given bucket list. > */ > static bucket_t * > -bucket_insert (bucket_t *bucket, char *key, int id) > +bucket_insert (bucket_t *bucket, const xmlChar *key, int id) > { > int ident = find_id (bucket, key); > > - /* no key found */ > if (NOKEY (ident)) { > + /* no key found */ > bucket_t *newbucket = (bucket_t*) malloc (sizeof (bucket_t)); > > newbucket->id = id; > - newbucket->key = strndup (key, strlen(key)); > + newbucket->key = xmlStrdup (key); > > /* add new bucket to the front of list */ > newbucket->next = bucket; > @@ -95,13 +95,12 @@ > * Create the hash value for a given key. > */ > static int > -find_hash_bucket (char *key) > +find_hash_bucket (const xmlChar *key) > { > assert (key); > > - size_t len = strlen (key); > - /* keys have at least length 1 */ > - /* assert (len > 0); */ > + size_t len = xmlStrlen (key); > + > /* build a hash out of the first and the last character > and the length of the key */ > return (key[0] * key[MAX(0,len-1)] * len) % PRIME; > @@ -113,7 +112,9 @@ > hashtable_t > new_hashtable (void) > { > - hashtable_t ht = malloc (PRIME * sizeof (bucket_t)); > + hashtable_t ht; > + > + ht = (hashtable_t) malloc (PRIME * sizeof (bucket_t)); > > /* initialize the hash table */ > for (unsigned int i = 0; i < PRIME; i++) > @@ -126,24 +127,25 @@ > * Insert key and id into hashtable. > */ > void > -hashtable_insert (hashtable_t hash_table, char *key, int id) > +hashtable_insert (hashtable_t hash_table, const xmlChar *key, int id) > { > int hashkey; > > - assert (hash_table && key); > - > + assert (hash_table); > + assert (key); > + > hashkey = find_hash_bucket (key); > hash_table[hashkey] = bucket_insert (hash_table[hashkey], key, id); > - return; > } > > /** > * Find element in hashtable. > */ > int > -hashtable_find (hashtable_t hash_table, char *key) > +hashtable_find (hashtable_t hash_table, const xmlChar *key) > { > - assert (key); > + assert (key); > + > return find_id (hash_table[find_hash_bucket (key)], key); > } > > @@ -156,7 +158,6 @@ > bucket_t *bucket, *free_bucket; > > assert (hash_table); > - if (!hash_table) return; > > for (int i = 0; i < PRIME; i++) { > bucket = hash_table[i]; > @@ -165,9 +166,11 @@ > free_bucket = bucket; > bucket = bucket->next; > /* free the copied hash key */ > - if (free_bucket->key) free (free_bucket->key); > + if (free_bucket->key) > + xmlFree (free_bucket->key); > free (free_bucket); > } > } > + > free(hash_table); > } > > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace > _______________________________________________ > 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