On Wed, Apr 17, 2013 at 3:38 PM, Lukas Bergliden <[email protected]
> wrote:

>  I checked the log and saw that this is the sql that is executed:
>  SELECT * FROM (SELECT
> "Id","Innehavare","NuvarandeTillstaand","Publicerad","Adress","Postnummer","Ort","Vaaningsplan","Placering","Kommun","Laen","OevrigInfo","Geometri".STAsBinary()
> as "Geometri", ROW_NUMBER() OVER (ORDER BY CURRENT_TIMESTAMP) AS
> _GT_ROW_NUMBER  FROM "HjaertstartarPositionsVy" WHERE
> ("Geometri".Filter(geometry::STGeomFromText('POINT (2006637.8011951
> 8263826.9502469)', 900913)) = 1 AND
> "Geometri".STDistance(geometry::STGeomFromText('POINT (2006637.8011951
> 8263826.9502469)', 900913))<50.0 AND "Innehavare" LIKE 'ica%' )) AS
> _GT_PAGING_SUBQUERY WHERE _GT_ROW_NUMBER <= 1000000
>
> and after a while I figured out that I could get it to work correctly if I
> removed
> "Geometri".Filter(geometry::STGeomFromText('POINT (2006637.8011951
> 8263826.9502469)', 900913)) = 1
>
> so that the query is:
> SELECT * FROM (SELECT
> "Id","Innehavare","NuvarandeTillstaand","Publicerad","Adress","Postnummer","Ort","Vaaningsplan","Placering","Kommun","Laen","OevrigInfo","Geometri".STAsBinary()
> as "Geometri", ROW_NUMBER() OVER (ORDER BY CURRENT_TIMESTAMP) AS
> _GT_ROW_NUMBER  FROM "HjaertstartarPositionsVy" WHERE
> ("Geometri".STDistance(geometry::STGeomFromText('POINT (2006637.8011951
> 8263826.9502469)', 900913))<50.0 AND "Innehavare" LIKE 'ica%' )) AS
> _GT_PAGING_SUBQUERY WHERE _GT_ROW_NUMBER <= 1000000
>
> So, basicly why does the DWitin create a Geometry.Filter()? And how can I
> stop it from doing so?
>

Ah yes, that does not seem right. You stop it by fixing the code that
generates the sql, you can find it in geotools, in the jdbc-sqlserver
module.
Patches welcomed, if not, at least open a ticket at jira.codehaus.org (if
you don't have an account, create it on xircles.codehaus.org)

Cheers
Andrea

-- 
==
GeoServer training in Milan, 6th & 7th June 2013!  Visit
http://geoserver.geo-solutions.it for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------
------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to