December 2008 - developers-list

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/test/Skyserver Skyserver_import.sql, , 1.3, 1.4 Skyserver_tables.sql, , 1.4, 1.5
by Stefan Manegold 29 Dec '08

29 Dec '08

On Mon, Dec 29, 2008 at 04:50:00PM +0000, Romulo Goncalves wrote: > Update of /cvsroot/monetdb/sql/src/test/Skyserver > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv383 > > Modified Files: > Skyserver_import.sql Skyserver_tables.sql > Log Message: > Correct some copy from statements to make the test green > At the same time remove some NULL constraints from the columns because "" is now seen as NULL IMHO, "" (i.e., an empty string of length 0) is *not* NULL --- but I don't know, whether the SQL standard has a different "opinion" ... Stefan > > > > U Skyserver_tables.sql > Index: Skyserver_tables.sql > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_tables.sql,v > retrieving revision 1.4 > retrieving revision 1.5 > diff -u -d -r1.4 -r1.5 > --- Skyserver_tables.sql 1 Apr 2008 11:45:51 -0000 1.4 > +++ Skyserver_tables.sql 29 Dec 2008 16:49:58 -0000 1.5 > @@ -451,7 +451,7 @@ > eta float NOT NULL, > lambdaMin float NOT NULL, > lambdaMax float NOT NULL, > - htmArea varchar(1024) NOT NULL, > + htmArea varchar(1024), --NOT NULL, > CONSTRAINT pk_StripeDefs_stripe PRIMARY KEY > ( > stripe > @@ -1155,11 +1155,11 @@ > ); > CREATE TABLE DBColumns( > tablename varchar(128) NOT NULL, > - name varchar(64) NOT NULL, > - unit varchar(64) NOT NULL, > - ucd varchar(128) NOT NULL, > - enum varchar(64) NOT NULL, > - description varchar(2000) NOT NULL, > + name varchar(64), -- NOT NULL, > + unit varchar(64), -- NOT NULL, > + ucd varchar(128), --NOT NULL, > + enum varchar(64), -- NOT NULL, > + description varchar(2000),-- NOT NULL, > rank int NOT NULL DEFAULT (0), > CONSTRAINT pk_DBColumns_tableName_name PRIMARY KEY > ( > > U Skyserver_import.sql > Index: Skyserver_import.sql > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_import.sql,v > retrieving revision 1.3 > retrieving revision 1.4 > diff -u -d -r1.3 -r1.4 > --- Skyserver_import.sql 6 Jun 2008 11:54:58 -0000 1.3 > +++ Skyserver_import.sql 29 Dec 2008 16:49:58 -0000 1.4 > @@ -60,7 +60,7 @@ > > COPY 1000 RECORDS INTO SDSSConstants FROM 'DATA/SDSSConstants1.dat.bz2' USING DELIMITERS '|', '\015\n'; > > -COPY 1000 RECORDS INTO StripeDefs FROM 'DATA/StripeDefs1.dat.bz2' USING DELIMITERS '\t', '\015\n'; > +COPY 1000 RECORDS INTO StripeDefs FROM 'DATA/StripeDefs1.dat.bz2' USING DELIMITERS '\t', '\015\n', '"' NULL as ''; > > COPY 1000 RECORDS INTO RunShift FROM 'DATA/RunShift.dat.bz2' USING DELIMITERS '\t', '\015\n'; > > @@ -116,7 +116,7 @@ > > COPY 1000 RECORDS INTO Inventory FROM 'DATA/Inventory.dat.bz2' USING DELIMITERS '\t', '\015\n'; > > -COPY 3000 RECORDS INTO DBColumns FROM 'DATA/DBColumns1.dat.bz2' USING DELIMITERS '\t', '\015\n'; > +COPY 3000 RECORDS INTO DBColumns FROM 'DATA/DBColumns1.dat.bz2' USING DELIMITERS '\t', '\015\n', '"' NULL as ''; > > COPY 1000 RECORDS INTO DBViewCols FROM 'DATA/DBViewCols.dat.bz2' USING DELIMITERS '\t', '\015\n'; > > > > ------------------------------------------------------------------------------ > _______________________________________________ > 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 |

2 1

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/server sql_schema.mx, Nov2008, 1.152.2.1, 1.152.2.2
by Stefan Manegold 27 Dec '08

27 Dec '08

On Sat, Dec 27, 2008 at 05:08:39PM +0000, Romulo Goncalves wrote: > Update of /cvsroot/monetdb/sql/src/server > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv19272 > > Modified Files: > Tag: Nov2008 > sql_schema.mx > Log Message: > It seems it is also broken in the stable... > If you drop a constraint like a primary key make sure there are no dependencies on it... > > Note: Do not propagate this check in... it was already done in the current branch... if the changes are identical (i.e., made using cvs commands), propagation will notice this and silently accept the identical changes (i.e., not try to do them again). see also `man cvs` and pages 8-16 (in particular pages 13-15) of http://homepages.cwi.nl/~manegold/Presentations/MonetDBdevTTT.pdf Stefan > > U sql_schema.mx > Index: sql_schema.mx > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/server/sql_schema.mx,v > retrieving revision 1.152.2.1 > retrieving revision 1.152.2.2 > diff -u -d -r1.152.2.1 -r1.152.2.2 > --- sql_schema.mx 14 Nov 2008 13:48:40 -0000 1.152.2.1 > +++ sql_schema.mx 27 Dec 2008 17:08:37 -0000 1.152.2.2 > @@ -1695,6 +1695,8 @@ > assert(l->h->next->type == type_int); > if ((key = mvc_bind_key(sql, ss, kname )) == NULL) > return sql_error(sql, 02, "cannot drop unknown constraint %s\n", kname); > + if (!drop_action && mvc_check_dependency(sql, key->base.id, KEY_DEPENDENCY, NULL)) > + return sql_error(sql, 02, "unable to drop constraint %s (there are database objects which depend on it)\n", key->base.name); > mvc_drop_key(sql, ss, key, drop_action); > res = stmt_none(); > } break; > > > ------------------------------------------------------------------------------ > _______________________________________________ > 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 |

2 2

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/tests/StandOff StandOff.py, , 1.10, 1.11
by Stefan Manegold 23 Dec '08

23 Dec '08

Wouter, On Tue, Dec 23, 2008 at 10:40:57AM +0000, Wouter Alink wrote: > Update of /cvsroot/monetdb/pathfinder/tests/StandOff > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv29912 > > Modified Files: > StandOff.py > Log Message: > - this commit switches StandOff testing towards Algebra-backend was/is it you intension to force all StandOff testing though the Algebra back-end (added "-A" option for pf; see below), i.e., ignoring/overruling the compile time default / choice (whch is indeed the Algebra back-end) as well as the choice on the Mtest.py command line? If so, why? Does MPS not longer support StandOff (or v.v.)? If not, you should remove the "-A" swicth for pf, again. > - observation: order of attributes seems to have changed in some > tests, the testoutput has been changed accordingly Serialization in MonetDB/XQuery has not feature (yet?) to enforce a particular attribute order. The order of attributes is only determined by the very implementation and (physical) order of input data, and can hence change. If it happens to differe between the MPS & ALG back-end for (some) StandOff tests, we could consider approving back-end specific (ALG or MPS) stable output for these tests. (See `Mtest.py --help` and/or http://monetdb.cwi.nl/Development/TestWeb/Mtest/ for details and/or feel free to ask for advice/help.) Stefan > - the "video/artists" test still fails, due to incorrect order > of the elements in the result. this test needs more investigation > > > U StandOff.py > Index: StandOff.py > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/tests/StandOff/StandOff.py,v > retrieving revision 1.10 > retrieving revision 1.11 > diff -u -d -r1.10 -r1.11 > --- StandOff.py 15 Feb 2008 18:34:11 -0000 1.10 > +++ StandOff.py 23 Dec 2008 10:40:55 -0000 1.11 > @@ -27,7 +27,7 @@ > TSTSRCDIR = os.environ['TSTSRCDIR'] > PF = os.environ['PF'] > > -CALL = '%s -b "%s.xq" | %s --set standoff=enabled --dbname=%s "--dbinit=module(pathfinder);"' % (PF,os.path.join(TSTSRCDIR,TST),MSERVER,TSTDB) > +CALL = '%s -bA "%s.xq" | %s --set standoff=enabled --dbname=%s "--dbinit=module(pathfinder);"' % (PF,os.path.join(TSTSRCDIR,TST),MSERVER,TSTDB) > > import sys, time > Mlog = "\n%s %s\n\n" % (time.strftime('# %H:%M:%S >',time.localtime(time.time())), CALL) > > > ------------------------------------------------------------------------------ > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins > > -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

3 4

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/compiler/semantics typecheck.brg, , 1.73, 1.74
by Stefan Manegold 22 Dec '08

22 Dec '08

Hi Wouter, thank you very much for porting your StandOff extensions to the Algebra back-end! I took this as a trigger to disable to automatic fall-back to the (deprecated) "milprint_summer" back-end in case the StandOff extensions are enabled (cf., http://monetdb.cwi.nl/Development/Releases/Version4.24/index.html#XQuery) The result: ======== .../pathfinder $ Mtest.py -rq --no-algebra tests/StandOff ................ ======== .../pathfinder $ Mtest.py -rq --algebra tests/StandOff .... * (test2.test.out.FILTERED) significantly .. * (lltest.test.out.FILTERED) significantly ........ * (scenes.test.out.FILTERED) significantly .. * (artists.test.out.FILTERED) significantly !ERROR: Testing FAILED SIGNIFICANTLY ! 4 out of 16 tests produced SIGNIFICANTLY different output ======== .../pathfinder $ Mtest.py -rq tests/StandOff .... * (test2.test.out.FILTERED) significantly .. * (lltest.test.out.FILTERED) significantly ........ * (scenes.test.out.FILTERED) significantly .. * (artists.test.out.FILTERED) significantly !ERROR: Testing FAILED SIGNIFICANTLY ! 4 out of 16 tests produced SIGNIFICANTLY different output ======== ;-) Stefan On Sun, Dec 21, 2008 at 07:33:36PM +0000, Wouter Alink wrote: > Update of /cvsroot/monetdb/pathfinder/compiler/semantics > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv21308/semantics > > Modified Files: > typecheck.brg > Log Message: > Step 3 of: > - enabling the standoff axes with the algebra backend. > - removing the "reject-narrow" and "reject-wide" axes steps > > In this commit: > - changes to the compiler. > > > > U typecheck.brg > Index: typecheck.brg > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/compiler/semantics/typecheck.brg,v > retrieving revision 1.73 > retrieving revision 1.74 > diff -u -d -r1.73 -r1.74 > --- typecheck.brg 14 Nov 2008 14:39:48 -0000 1.73 > +++ typecheck.brg 21 Dec 2008 19:33:33 -0000 1.74 > @@ -138,10 +138,8 @@ > %term preceding_sibling = 51 /**< all preceding nodes with same parent */ > %term self = 52 /**< the context node itself */ > /* [STANDOFF] */ > -%term select_narrow = 100 /**< regions contained in a context-node */ > -%term select_wide = 101 /**< regions overlapping a context-node */ > -%term reject_narrow = 102 /**< all regions except the contained regions */ > -%term reject_wide = 103 /**< all regions except the overlapping regions */ > +%term select_narrow = 53 /**< regions contained in a context-node */ > +%term select_wide = 54 /**< regions overlapping a context-node */ > /* [/STANDOFF] */ > > /* Constructor Nodes */ > @@ -228,10 +226,8 @@ > LocationStep: preceding_sibling (SequenceType) = 36 (10); > LocationStep: self (SequenceType) = 37 (10); > /* [STANDOFF] */ > -LocationStep: select_narrow (SequenceType) = 100 (10); > -LocationStep: select_wide (SequenceType) = 101 (10); > -LocationStep: reject_narrow (SequenceType) = 102 (10); > -LocationStep: reject_wide (SequenceType) = 103 (10); > +LocationStep: select_narrow (SequenceType) = 38 (10); > +LocationStep: select_wide (SequenceType) = 39 (10); > /* [/STANDOFF] */ > > LocationSteps: locsteps (LocationStep, LocationSteps) = 40 (10); > @@ -884,23 +880,13 @@ > TY(p) = TY(L(p)); > break; > /* [STANDOFF] */ > - case 100: > + case 38: > /* LocationStep: select_narrow (SequenceType) */ > TY(p) = PFty_star (TY(L(p))); > break; > > /* LocationStep: select_wide (SequenceType) */ > - case 101: > - TY(p) = PFty_star (TY(L(p))); > - break; > - > - /* LocationStep: reject_narrow (SequenceType) */ > - case 102: > - TY(p) = PFty_star (TY(L(p))); > - break; > - > - /* LocationStep: reject_wide (SequenceType) */ > - case 103: > + case 39: > TY(p) = PFty_star (TY(L(p))); > break; > /* [/STANDOFF] */ > > > ------------------------------------------------------------------------------ > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-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] Announcement: New bug fix release of MonetDB suite
by Sjoerd Mullender 22 Dec '08

22 Dec '08

The MonetDB team at CWI is pleased to announce the Nov2008-SP1 bug fix release of the MonetDB suite of programs. This is a bug fix release of last month's Nov2008 release. More information on this release can be found at <http://monetdb.cwi.nl/projects/monetdb/Development/Releases/Nov2008/#Nov200…>. The sources and binaries are available at <http://monetdb.cwi.nl/projects/monetdb/Download/>. -- Sjoerd Mullender

1 0

[Monetdb-developers] stable branch open
by Sjoerd Mullender 18 Dec '08

18 Dec '08

The release has been built. The stable branch is open again for business. Bug fixes only! -- Sjoerd Mullender

1 0

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/mal mal_interpreter.mx, , 1.274, 1.275 mal_recycle.mx, , 1.169, 1.170
by Stefan Manegold 16 Dec '08

16 Dec '08

On Tue, Dec 16, 2008 at 05:28:57PM +0000, Milena Ivanova wrote: > Update of /cvsroot/monetdb/MonetDB5/src/mal > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv4716 > > Modified Files: > mal_interpreter.mx mal_recycle.mx > Log Message: > Subsumed instructions are not recycled. This is checked in the proper place > before the attempt to obtain the lock. > Mtest gave No differences encountered during testing. "Comfirmed" ;-) Thanks! Stefan > > > U mal_recycle.mx > Index: mal_recycle.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/mal/mal_recycle.mx,v > retrieving revision 1.169 > retrieving revision 1.170 > diff -u -d -r1.169 -r1.170 > --- mal_recycle.mx 15 Dec 2008 16:13:13 -0000 1.169 > +++ mal_recycle.mx 16 Dec 2008 17:28:55 -0000 1.170 > @@ -114,7 +114,6 @@ > mal_export int recycleCacheLimit; > mal_export lng recycleMemory; /* Units of memory permitted */ > mal_export lng recyclerUsedMemory; > -mal_export MT_Lock recycleLock; > mal_export MalBlkPtr recycleBlk; > mal_export double recycleAlpha; > mal_export double recycleFresh; > @@ -173,7 +172,7 @@ > #include "mal_function.h" > #include "mal_client.h" > > -MT_Lock recycleLock ; > +static MT_Lock recycleLock ; > MalBlkPtr recycleBlk = NULL; > > static void RECYCLEexitImpl(Client cntxt,MalBlkPtr mb, MalStkPtr stk, InstrPtr p); > @@ -1055,7 +1054,7 @@ > > if( recycleBlk == 0 || reusePolicy == 0) > return -1; > - mal_set_lock(recycleLock,"recycle"); > + mal_set_lock(recycleLock,"recycle"); > > for (i = 0; i < recycleBlk->stop; i++){ > q = getInstrPtr(recycleBlk,i); > @@ -1143,7 +1142,7 @@ > updateQryStat(q->recycle,gluse); > } > recycleRecent = i; > - mal_unset_lock(recycleLock,"recycle"); > + mal_unset_lock(recycleLock,"recycle"); > return i; > notfound: > continue; > @@ -1192,7 +1191,7 @@ > #else > (void) evicted; > #endif > - mal_unset_lock(recycleLock,"recycle"); > + mal_unset_lock(recycleLock,"recycle"); > return pc; > } > > @@ -1241,8 +1240,6 @@ > > if ( wr > memLimit) > return; > - if ( p->recycle == NO_RECYCLING ) > - return; > if (recycleBlk){ > if ( recyclerUsedMemory + wr > memLimit || > recycleSize >= cacheLimit ) > > U mal_interpreter.mx > Index: mal_interpreter.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/mal/mal_interpreter.mx,v > retrieving revision 1.274 > retrieving revision 1.275 > diff -u -d -r1.274 -r1.275 > --- mal_interpreter.mx 17 Nov 2008 08:57:52 -0000 1.274 > +++ mal_interpreter.mx 16 Dec 2008 17:28:55 -0000 1.275 > @@ -1923,7 +1923,7 @@ > @= MALrecycleStart > if( !RECYCLEentry(cntxt, mb,stk,pci) ) > @= MALrecycleExit > - if( pci->recycle ) > + if( pci->recycle > 0 ) > RECYCLEexit(cntxt, mb,stk,pci); > @} > @- > > > ------------------------------------------------------------------------------ > SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. > The future of the web can't happen without you. Join us at MIX09 to help > pave the way to the Next Web now. Learn more and register at > http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.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 |

1 0

Re: [Monetdb-developers] [Monetdb-checkins] testing/src Mtest.py.in, , 1.4, 1.5
by Milena Ivanova 16 Dec '08

16 Dec '08

Hi, I have the following message when configure testing( updated at 12.45h) checking for perl... /usr/bin/perl checking perl.h usability... no checking perl.h presence... yes configure: WARNING: perl.h: present but cannot be compiled configure: WARNING: perl.h: check for missing prerequisite headers? configure: WARNING: perl.h: see the Autoconf documentation configure: WARNING: perl.h: section "Present But Cannot Be Compiled" configure: WARNING: perl.h: proceeding with the preprocessor's result configure: WARNING: perl.h: in the future, the compiler will take precedence configure: WARNING: ## --------------------------- ## configure: WARNING: ## Report this to monet(a)cwi.nl ## configure: WARNING: ## --------------------------- ## checking for perl.h... yes I also got (in src, build) find: perl.h: No such file or directory The hanging recycle test shows the following: 13:04:59> src/mal/recycle01.mal (<=60,60,60) ... 0.075s recycle01.stable.out.FILTERED and recycle01.test.out.FILTERED are equal. recycle01.stable.err.FILTERED and recycle01.test.err.FILTERED are equal. No differences encountered during testing. If necessary, you can checkin your modifications, now. Exception in thread Thread-3 (most likely raised during interpreter shutdown): Traceback (most recent call last): File "/usr/lib64/python2.5/threading.py", line 460, in __bootstrap File "/usr/lib64/python2.5/threading.py", line 623, in run File "/usr/lib64/python2.5/threading.py", line 364, in wait File "/usr/lib64/python2.5/threading.py", line 238, in wait <type 'exceptions.ValueError'>: list.remove(x): x not in list Unhandled exception in thread started by Error in sys.excepthook: Original exception was: Milena

1 0

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/test/BugTracker-2008/Tests is_distinct_broken.SF-2430201.stable.err, , NONE, 1.1 is_distinct_broken.SF-2430201.stable.out, , NONE, 1.1
by Romulo Goncalves 16 Dec '08

16 Dec '08

Niels Nes wrote: > Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv8183/src/test/BugTracker-2008/Tests > > Added Files: > is_distinct_broken.SF-2430201.stable.err > is_distinct_broken.SF-2430201.stable.out > Log Message: > approved output You need to do the same for the stable ;) If not I can't close the bug... Romulo > > > --- NEW FILE: is_distinct_broken.SF-2430201.stable.out --- > stdout of test 'is_distinct_broken.SF-2430201` in directory 'src/test/BugTracker-2008` itself: > > > # 12:32:45 > > # 12:32:45 > mserver5 "--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10 --set gdk_nr_threads=4 --set "monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=35778 --set xrpc_port=45446 --set monet_prompt= --trace "--dbname=mTests_src_test_BugTracker-2008" --set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over.. > # 12:32:45 > > > # MonetDB server v5.9.0, based on kernel v1.27.0 > # Serving database 'mTests_src_test_BugTracker-2008', using 4 threads > # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked > # Copyright (c) 1993-July 2008 CWI. > # Copyright (c) August 2008- MonetDB B.V., all rights reserved > # Visit http://monetdb.cwi.nl/ for further information > # Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:35778/ > # MonetDB/SQL module v2.27.0 loaded > > Ready. > # falling back to direct mode > # falling back to direct mode > # falling back to direct mode > #function user.main():void; > # clients.quit(); > #end main; > > Over.. > > # 12:32:45 > > # 12:32:45 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=35778 > # 12:32:45 > > > [ 1 ] > [ 1 ] > [ 1 ] > [ 1 ] > [ 1 ] > [ 1 ] > [ 1 ] > [ 1 ] > % sys.way_tags # table_name > % way # name > % int # type > % 8 # length > [ 23950375 ] > [ 24644162 ] > % . # table_name > % single_value # name > % tinyint # type > % 2 # length > [ 10 ] > % .b # table_name > % a # name > % tinyint # type > % 2 # length > [ 10 ] > > # 12:32:45 > > # 12:32:45 > Done. > # 12:32:45 > > > > --- NEW FILE: is_distinct_broken.SF-2430201.stable.err --- > stderr of test 'is_distinct_broken.SF-2430201` in directory 'src/test/BugTracker-2008` itself: > > > # 12:32:45 > > # 12:32:45 > mserver5 "--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10 --set gdk_nr_threads=4 --set "monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=35778 --set xrpc_port=45446 --set monet_prompt= --trace "--dbname=mTests_src_test_BugTracker-2008" --set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over.. > # 12:32:45 > > > # builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu > # builtin opt gdk_version = 1.27.0 > # builtin opt monet_pid = 8562 > # builtin opt prefix = /ufs/niels/scratch/monetdb/Linux-x86_64 > # builtin opt exec_prefix = ${prefix} > # builtin opt gdk_dbname = tst > # builtin opt gdk_dbfarm = ${prefix}/var/MonetDB > # builtin opt gdk_debug = 8 > # builtin opt gdk_mem_bigsize = 262144 > # builtin opt gdk_alloc_map = yes > # builtin opt gdk_mem_pagebits = 14 > # builtin opt gdk_vmtrim = yes > # builtin opt monet_admin = adm > # builtin opt monet_prompt = > > # builtin opt monet_welcome = yes > # builtin opt monet_mod_path = ${exec_prefix}/lib/MonetDB:${exec_prefix}/lib/bin > # builtin opt monet_daemon = yes > # builtin opt host = localhost > # builtin opt mapi_port = 50000 > # builtin opt mapi_noheaders = no > # builtin opt mapi_debug = 0 > # builtin opt mapi_clients = 2 > # builtin opt sql_debug = 0 > # builtin opt sql_logdir = ${prefix}/var/MonetDB > # builtin opt xquery_logdir = ${prefix}/var/MonetDB > # builtin opt standoff_ns = http://monetdb.cwi.nl/standoff > # builtin opt standoff_start = start > # builtin opt standoff_end = end > # config opt prefix = /ufs/niels/scratch/monetdb/Linux-x86_64 > # config opt config = ${prefix}/etc/monetdb5.conf > # config opt prefix = /ufs/niels/scratch/monetdb/Linux-x86_64 > # config opt exec_prefix = ${prefix} > # config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm > # config opt gdk_dbname = demo > # config opt gdk_alloc_map = no > # config opt gdk_embedded = no > # config opt gdk_debug = 0 > # config opt monet_mod_path = ${exec_prefix}/lib/MonetDB5:${exec_prefix}/lib/MonetDB5/lib:${exec_prefix}/lib/MonetDB5/bin > # config opt monet_daemon = no > # config opt monet_welcome = yes > # config opt mero_msglog = ${prefix}/var/log/merovingian.log > # config opt mero_errlog = ${prefix}/var/log/merovingian.log > # config opt mero_timeinterval = 600 > # config opt mero_pidfile = ${prefix}/var/run/merovingian.pid > # config opt mero_exittimeout = 7 > # config opt mero_doproxy = yes > # config opt mero_discoveryttl = 600 > # config opt mal_init = ${exec_prefix}/lib/MonetDB5/mal_init.mal > # config opt mal_listing = 2 > # config opt checkpoint_dir = ${prefix}/var/MonetDB5/chkpnt > # config opt mapi_port = 50000 > # config opt mapi_open = false > # config opt sql_logdir = ${prefix}/var/MonetDB5/sql_logs > # config opt sql_init = ${exec_prefix}/lib/MonetDB5/sql_init.sql > # cmdline opt config = /ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf > # cmdline opt gdk_nr_threads = 4 > # cmdline opt monet_mod_path = /ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin > # cmdline opt gdk_dbfarm = /ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm > # cmdline opt sql_logdir = /ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs > # cmdline opt mapi_open = true > # cmdline opt xrpc_open = true > # cmdline opt mapi_port = 35778 > # cmdline opt xrpc_port = 45446 > # cmdline opt monet_prompt = > # cmdline opt gdk_dbname = mTests_src_test_BugTracker-2008 > # cmdline opt mal_listing = 0 > # cmdline opt gdk_debug = 10 > #warning: please don't forget to set your vault key! > #(see /ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf) > > # 12:32:45 > > # 12:32:45 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=35778 > # 12:32:45 > > > > # 12:32:45 > > # 12:32:45 > Done. > # 12:32:45 > > > > > ------------------------------------------------------------------------------ > SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. > The future of the web can't happen without you. Join us at MIX09 to help > pave the way to the Next Web now. Learn more and register at > http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ > _______________________________________________ > Monetdb-sql-checkins mailing list > Monetdb-sql-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins

1 0

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/test/BugTracker-2008/Tests is_distinct_broken.SF-2430201.sql, Nov2008, NONE, 1.1.2.2 All, Nov2008, 1.6.2.8, 1.6.2.9
by Sjoerd Mullender 15 Dec '08

15 Dec '08

Where is the stable output? There is no sense running a test if there is no stable output. Romulo Goncalves wrote: > Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv15432 > > Modified Files: > Tag: Nov2008 > All > Added Files: > Tag: Nov2008 > is_distinct_broken.SF-2430201.sql > Log Message: > Add test to cover bug: > is_distinct_broken.SF-2430201 > > Note: Please do not propagate this check in. It was already checked in current cvs branch ;) > > > U All > Index: All > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/All,v > retrieving revision 1.6.2.8 > retrieving revision 1.6.2.9 > diff -u -d -r1.6.2.8 -r1.6.2.9 > --- All 19 Nov 2008 10:39:51 -0000 1.6.2.8 > +++ All 15 Dec 2008 10:04:26 -0000 1.6.2.9 > @@ -30,3 +30,4 @@ > count_with_order_by_and_limit_crashes.SF-2229936 > sql_command_kills_db.SF-2233677 > between_no_columns.SF2102101 > +is_distinct_broken.SF-2430201 > > --- NEW FILE: is_distinct_broken.SF-2430201.sql --- > create table way_tags (way int, k int); > insert into way_tags values(23950375,1); > insert into way_tags values(23950375,1); > insert into way_tags values(23950375,1); > insert into way_tags values(23950375,1); > insert into way_tags values(23950375,1); > insert into way_tags values(24644162,1); > insert into way_tags values(24644162,1); > insert into way_tags values(24644162,1); > > select distinct way from way_tags group by way, k having count(*) > 1; > > drop table way_tags; > > select distinct (select 10 union all select 10); > > select distinct a from (select 10 as a union all select 10 as a) as b; > > > ------------------------------------------------------------------------------ > SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. > The future of the web can't happen without you. Join us at MIX09 to help > pave the way to the Next Web now. Learn more and register at > http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ > _______________________________________________ > Monetdb-sql-checkins mailing list > Monetdb-sql-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins -- Sjoerd Mullender

2 1