Fitler encoding produces bad SQL
--------------------------------

                 Key: GEOT-1614
                 URL: http://jira.codehaus.org/browse/GEOT-1614
             Project: GeoTools
          Issue Type: Bug
            Reporter: Jody Garnett


I am running into the following error on trunk when working on a transaction 
(ie with uncommitted features) using udig.
{warning}
org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
{warning}

The resulting SQL looks like this (obtained using the debugger):
{panel}
SELECT "gid", encode(AsBinary(force_2d("the_geom"), 'XDR'),'base64') FROM
"public"."usa_counties"
WHERE ( NOT () AND "the_geom" &&
   GeometryFromText('POLYGON ((-113.48787389918262 49.42018146462066, 
-113.48787389918262 50.04857178525557, -112.23109325791282 50.04857178525557, 
-112.23109325791282 49.42018146462066, -113.48787389918262 
49.42018146462066))', 4326)
)
{panel}

I am going to guess that "NOT() is bad? And the idea there is to list the 
feature IDs of thing that the user is editing? So they are not drawn twice...

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Reply via email to