On Sun, May 25, 2008 at 01:47:36AM +0200, Stefan de Konink wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA512 > > Stefan Manegold schreef: > > Well, I only said that all available tests do work fine. I don't know the > > tests by hard, and hence cannot tell whether you scenario is (already) > > covered. > > In case you find it not working and file a bug report, a test will be added > > before the bug report is closed. > > We mght also consider adding a test even without bug report, once we have > > some spare time --- any help is more than aprechiated ;-) > > > From: http://monetdb.cwi.nl/SQL/Documentation/SQL_002fGIS.html > > (One thing that should get an update is the location of geom.sql)
??? Could you *please* be a bit more verbose and/or precise? > [EMAIL PROTECTED] /opt/osm/bin $ ./mclient -lsq > sql>CREATE TABLE forests(id INT,name TEXT,shape MULTIPOLYGON); > sql>CREATE TABLE buildings(id INT,name TEXT,location POINT,outline POLYGON); > sql>INSERT INTO forests VALUES(109, 'Green Forest', > more>'MULTIPOLYGON( ((28 26,28 0,84 0,84 42,28 26), (52 18,66 23,73 9,48 > 6,52 18)), ((59 18,67 18,67 13,59 13,59 18)))'); > Rows affected 1 > sql>INSERT INTO buildings VALUES(113, '123 Main Street', > more>'POINT( 52 30 )', > more>'POLYGON( ( 50 31, 54 31, 54 29, 50 29, 50 31) )'); > Rows affected 1 > sql>INSERT INTO buildings VALUES(114, '215 Main Street', > more>'POINT( 64 33 )', > more>'POLYGON( ( 66 34, 62 34, 62 32, 66 32, 66 34) )'); > Rows affected 1 > sql> > sql>SELECT forests.name,buildings.name > more>FROM forests,buildings > more>WHERE forests.name = 'Green Forest' and > more> Overlaps(forests.shape, buildings.outline) = true; > !types multipolygon(0,0) (wkb) and geometry(0,0) (wkb) are not equal Please file this as a bug report via SF. > http://xen.bot.nu/mTests/ (output) Looks OK. Differences are minor due to changes between geos 2.2.3 and geos 3.0.0; see also http://monetdb.cwi.nl/testing/projects/monetdb/Stable/geom/.mTests5103/index.html > Help is nice :) Which help do you refer to? > Please review all errors even if they 'matchup'. The differences under http://xen.bot.nu/mTests/ are only minor due do output / precision changes between geos 2.2.3 and geos 3.0.0; see above. The error with the web site example seems to be a bug --- either in the code or in the example --- and should be filed as such via SF. Thanks in advance! Stefan > > Stefan > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v2.0.9 (GNU/Linux) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iEYEAREKAAYFAkg4qRgACgkQYH1+F2Rqwn3RGwCghaNao7Z5/pZyq7hf+LAO1dCs > T1kAnRiZzTlP7z/ilRTWQgg7tPV6Itq9 > =p9DG > -----END PGP SIGNATURE----- > -- | 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 | ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Monetdb-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
