[Monetdb-developers] [Monetdb-sql-checkins] sql/src/test/BugTracker-2009/Tests primekeyconstraint.SF-2783425.sql, , 1.1, 1.2 primekeyconstraint.SF-2783425.stable.err, , 1.1, 1.2 primekeyconstraint.SF-2783425.stable.out, , 1.1, 1.2 random.SF-2737889.sql, , NONE, 1.1 All, , 1.30, 1.31

Stefan Manegold Stefan.Manegold at cwi.nl
Sun Jun 7 20:23:20 CEST 2009


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 at 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
> 

-- 
| Dr. Stefan Manegold | mailto:Stefan.Manegold at 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       |




More information about the developers-list mailing list