Update of /cvsroot/monetdb/geom/src/sql/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv26858
Modified Files:
All
Added Files:
geom_multi.dbinit geom_multi.dbinit5 geom_multi.sql
geom_multi.stable.err geom_multi.stable.out
Log Message:
added test for multi* types
Index: All
===================================================================
RCS file: /cvsroot/monetdb/geom/src/sql/Tests/All,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- All 22 Aug 2007 21:00:52 -0000 1.3
+++ All 8 Sep 2007 11:53:43 -0000 1.4
@@ -5,6 +5,7 @@
geom_linestring
geom_surface
geom_polygon
+geom_multi
geom_mbr
basic
relation
--- NEW FILE: geom_multi.sql ---
START TRANSACTION;
CREATE TABLE tuin (
the_geom MULTILINESTRING);
INSERT INTO tuin (the_geom) VALUES ('MULTILINESTRING((0 0,0 80,60 80,60 0,0
0))');
INSERT INTO tuin (the_geom) VALUES ('MULTILINESTRING((32.6002766132418
79.6282111001846,32.6002766132418 43.4495799044218,60 43.4495799044218))');
INSERT INTO tuin (the_geom) VALUES ('MULTILINESTRING((-0.0618009189770508
78.5913197499555,4.24639364857977 78.1989578090258,8.41282906921902
77.034782474182,12.3004107150971 75.1371003956325,15.7812195126786
72.568353923266,18.7407210606057 69.4130664700482,21.0815343311285
65.7750613082651,22.7266359477212 61.7740453128334,23.621894603614
57.5416700620239,23.7378522273712 53.217199903252))');
INSERT INTO tuin (the_geom) VALUES ('MULTILINESTRING((24.0459229738511
40.2263397914762,24.3452043818619 35.5131014031623,25.3105891313714
30.8900918042461,26.9225206006616 26.4509632406012,29.1483445200274
22.2856429232384,31.9429704771502 18.4785112961428,35.2497853520134
15.106692669698,39.001800177129 12.2384928477941,43.1230071901497
9.93201539893725))');
INSERT INTO tuin (the_geom) VALUES ('MULTILINESTRING((32.6002766132418
39.9671169539189,32.9241373943297 35.9444532021224,33.8873771318695
32.025412672405,35.4651829129764 28.3109492680019,37.6169106945631
24.8967470157193,40.2871322878666 21.8707552595839,43.407063180376
19.3109230987754))');
INSERT INTO tuin (the_geom) VALUES ('MULTILINESTRING((23.7378522273712
53.217199903252,24.0459229738511 40.2263397914762))');
INSERT INTO tuin (the_geom) VALUES ('MULTILINESTRING((32.6002766132418
43.4495799044218,32.6002766132418 39.9671169539189))');
INSERT INTO tuin (the_geom) VALUES ('MULTILINESTRING((43.407063180376
19.3109230987754,48.6720925417939 24.6729695380386,60.0778973943148
19.4885127868928))');
INSERT INTO tuin (the_geom) VALUES ('MULTILINESTRING((0.197421918580242
29.8574262891845,25.6012599991949 29.5982034516272))');
INSERT INTO tuin (the_geom) VALUES ('MULTILINESTRING((0.197421918580242
55.0020415322418,23.5274772987366 55.0020415322418))');
INSERT INTO tuin (the_geom) VALUES ('MULTILINESTRING((28.9711568874397
70.2961889481221,27.1293834790847 73.020965899317,24.147063040934
76.8292465515136,20.6310769666185 80.1511554375197))');
INSERT INTO tuin (the_geom) VALUES ('MULTILINESTRING((28.9711568874397
70.2961889481221,32.6002766132418 69.7777432730075))');
COMMIT;
--- NEW FILE: geom_multi.stable.out ---
stdout of test 'geom_multi` in directory 'src/sql` itself:
# 13:49:29 >
# 13:49:29 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=30470 --set
xrpc_port=47835 --set monet_prompt= --trace "--dbname=mTests_src_sql"
--dbinit="module(geom); module(sql_server);" ; echo ; echo Over..
# 13:49:29 >
# MonetDB Server v4.19.0
# based on GDK v1.19.0
# Copyright (c) 1993-2007, CWI. All rights reserved.
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
# Visit http://monetdb.cwi.nl/ for further information.
# MonetDB/SQL module v2.19.0 loaded
printf("\nReady.\n");
Ready.
quit();
Over..
# 13:49:29 >
# 13:49:29 > Mtimeout -timeout 60 mclient -lsql -umonetdb -Pmonetdb
--host=koala --port=30470
# 13:49:29 >
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
# 13:49:29 >
# 13:49:29 > Done.
# 13:49:29 >
--- NEW FILE: geom_multi.dbinit ---
module(geom);
--- NEW FILE: geom_multi.stable.err ---
stderr of test 'geom_multi` in directory 'src/sql` itself:
# 13:49:29 >
# 13:49:29 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/MonetDB.conf" --debug=10
--set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=30470 --set
xrpc_port=47835 --set monet_prompt= --trace "--dbname=mTests_src_sql"
--dbinit="module(geom); module(sql_server);" ; echo ; echo Over..
# 13:49:29 >
# 13:49:29 >
# 13:49:29 > Mtimeout -timeout 60 mclient -lsql -umonetdb -Pmonetdb
--host=koala --port=30470
# 13:49:29 >
# 13:49:29 >
# 13:49:29 > Done.
# 13:49:29 >
--- NEW FILE: geom_multi.dbinit5 ---
include geom;
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
