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 = monetdb@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 Monetdb-sql-checkins@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 |