On Sun, Jun 07, 2009 at 06:18:45PM +0000, Martin Kersten wrote: > Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv8305 > > Modified Files: > All > Added Files: > primekeyconstraint.SF-2783425.sql > primekeyconstraint.SF-2783425.stable.err > primekeyconstraint.SF-2783425.stable.out
FYI: You added the above files this morning to the May2009 branch. (Since then, there has not been any propagation, yet ...) Stefan > random.SF-2737889.sql > Log Message: > Addition of new tests. > > > U All > Index: All > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/All,v > retrieving revision 1.30 > retrieving revision 1.31 > diff -u -d -r1.30 -r1.31 > --- All 30 May 2009 04:29:16 -0000 1.30 > +++ All 7 Jun 2009 18:18:43 -0000 1.31 > @@ -61,3 +61,5 @@ > having_min_crash.SF-2795951 > insert_type_exception.SF-2789976 > explain_gives_crash.SF-2741829 > +primekeyconstraint.SF-2783425 > +random.SF-2737889 > > --- NEW FILE: primekeyconstraint.SF-2783425.stable.out --- > stdout of test 'primekeyconstraint.SF-2783425` in directory > 'src/test/BugTracker-2009` itself: > > > # 08:02:34 > > # 08:02:34 > mserver5 "--config=/ufs/mk/monet5//Linux/etc/monetdb5.conf" > --debug=10 --set gdk_nr_threads=0 --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 > mapi_open=true --set xrpc_open=true --set mapi_port=30582 --set > xrpc_port=46770 --set monet_prompt= --trace > "--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit= > include sql;" ; echo ; echo Over.. > # 08:02:34 > > > # MonetDB server v5.13.0, based on kernel v1.31.0 > # Serving database 'mTests_src_test_BugTracker-2009', 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-2009 MonetDB B.V., all rights reserved > # Visit http://monetdb.cwi.nl/ for further information > # Listening for connection requests on mapi:monetdb://eir.ins.cwi.nl:30582/ > # MonetDB/SQL module v2.31.0 loaded > > Ready. > #function user.main():void; > # clients.quit(); > #end main; > > Over.. > > # 08:02:34 > > # 08:02:34 > mclient -lsql -umonetdb -Pmonetdb --host=eir --port=30582 > # 08:02:34 > > > [ 1 ] > [ 1 ] > [ 1 ] > [ 1 ] > [ 1 ] > [ 1 ] > [ 1 ] > [ 1 ] > [ 1 ] > % sys.way_nds, sys.way_nds # table_name > % way, idx # name > % int, int # type > % 1, 1 # length > [ 1, 1 ] > [ 1, 1 ] > [ 2, 2 ] > [ 3, 3 ] > [ 4, 3 ] > [ NULL, 3 ] > [ NULL, 3 ] > [ 5, NULL ] > [ 5, NULL ] > % sys.way_nds, sys.way_nds, sys.way_nds # table_name > % L4, way, idx # name > % wrd, int, int # type > % 1, 1, 1 # length > [ 2, 1, 1 ] > [ 2, NULL, 3 ] > [ 2, 5, NULL ] > > # 08:02:34 > > # 08:02:34 > Done. > # 08:02:34 > > > > --- NEW FILE: primekeyconstraint.SF-2783425.stable.err --- > stderr of test 'primekeyconstraint.SF-2783425` in directory > 'src/test/BugTracker-2009` itself: > > > # 08:02:34 > > # 08:02:34 > mserver5 "--config=/ufs/mk/monet5//Linux/etc/monetdb5.conf" > --debug=10 --set gdk_nr_threads=0 --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 > mapi_open=true --set xrpc_open=true --set mapi_port=30582 --set > xrpc_port=46770 --set monet_prompt= --trace > "--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit= > include sql;" ; echo ; echo Over.. > # 08:02:34 > > > # builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu > # builtin opt gdk_version = 1.31.0 > # builtin opt prefix = /ufs/mk/monet5//Linux > # 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_alloc_map = yes > # 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 > # 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 = sql_logs > # builtin opt xquery_logdir = xquery_logs > # builtin opt standoff_ns = http://monetdb.cwi.nl/standoff > # builtin opt standoff_start = start > # builtin opt standoff_end = end > # config opt prefix = /ufs/mk/monet5//Linux > # config opt config = ${prefix}/etc/monetdb5.conf > # config opt prefix = /ufs/mk/monet5//Linux > # 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/MonetDB/merovingian.log > # config opt mero_errlog = ${prefix}/var/log/MonetDB/merovingian.log > # config opt mero_pidfile = ${prefix}/var/run/MonetDB/merovingian.pid > # config opt mal_init = ${exec_prefix}/lib/MonetDB5/mal_init.mal > # config opt mal_listing = 2 > # config opt mapi_port = 50000 > # config opt mapi_open = false > # config opt sql_optimizer = > inline,remap,evaluate,costModel,coercions,emptySet,aliases,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex > # config opt sql_logdir = sql_logs > # cmdline opt config = /ufs/mk/monet5//Linux/etc/monetdb5.conf > # cmdline opt gdk_nr_threads = 0 > # cmdline opt monet_mod_path = > /ufs/mk/monet5//Linux/lib/MonetDB5:/ufs/mk/monet5//Linux/lib/MonetDB5/lib:/ufs/mk/monet5//Linux/lib/MonetDB5/bin > # cmdline opt gdk_dbfarm = /ufs/mk/monet5//Linux/var/MonetDB5/dbfarm > # cmdline opt mapi_open = true > # cmdline opt xrpc_open = true > # cmdline opt mapi_port = 30582 > # cmdline opt xrpc_port = 46770 > # cmdline opt monet_prompt = > # cmdline opt gdk_dbname = mTests_src_test_BugTracker-2009 > # cmdline opt mal_listing = 0 > #warning: please don't forget to set your vault key! > #(see /ufs/mk/monet5//Linux/etc/monetdb5.conf) > > # 08:02:34 > > # 08:02:34 > mclient -lsql -umonetdb -Pmonetdb --host=eir --port=30582 > # 08:02:34 > > > MAPI = mone...@eir:30582 > QUERY = ALTER TABLE way_nds ADD CONSTRAINT pk_way_nds PRIMARY KEY (way, idx); > > > # 08:02:34 > > # 08:02:34 > Done. > # 08:02:34 > > > > --- NEW FILE: random.SF-2737889.sql --- > create table nr (nr int); > insert into nr values (1); > insert into nr values (2); > insert into nr values (3); > insert into nr values (4); > insert into nr values (5); > insert into nr values (6); > insert into nr values (7); > insert into nr values (8); > insert into nr values (9); > insert into nr values (10); > SELECT nr, RAND() FROM nr; > SELECT nr, RAND() AS rnd FROM nr; > drop table nr; > > --- NEW FILE: primekeyconstraint.SF-2783425.sql --- > CREATE TABLE way_nds ( > way int, > idx int, > payload string > ); > > insert into way_nds values(1,1,'abc'); > insert into way_nds values(1,1,'abc'); > insert into way_nds values(2,2,'abc'); > insert into way_nds values(3,3,'abc'); > insert into way_nds values(4,3,'abc'); > insert into way_nds values(null,3,'abc'); > insert into way_nds values(null,3,'abc'); > insert into way_nds values(5,null,'abc'); > insert into way_nds values(5,null,'abc'); > > ALTER TABLE way_nds ADD CONSTRAINT pk_way_nds PRIMARY KEY (way, idx); > > select way,idx from way_nds; > select count(way), way, idx from way_nds group by way, idx having > count(way) > 1; > drop table way_nds; > > > ------------------------------------------------------------------------------ > OpenSolaris 2009.06 is a cutting edge operating system for enterprises > looking to deploy the next generation of Solaris that includes the latest > innovations from Sun and the OpenSource community. Download a copy and > enjoy capabilities such as Networking, Storage and Virtualization. > Go to: http://p.sf.net/sfu/opensolaris-get > _______________________________________________ > Monetdb-sql-checkins mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins > -- | Dr. Stefan Manegold | mailto:[email protected] | | 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 | ------------------------------------------------------------------------------ OpenSolaris 2009.06 is a cutting edge operating system for enterprises looking to deploy the next generation of Solaris that includes the latest innovations from Sun and the OpenSource community. Download a copy and enjoy capabilities such as Networking, Storage and Virtualization. Go to: http://p.sf.net/sfu/opensolaris-get _______________________________________________ Monetdb-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
