David Blasby wrote:

I noticed this change.

I think this is the incorrect interpretation since there is a <PropertyIsNull> test in Filter.

oops, I noticed that <PropertyIsNull> is interpreted as

"[ interstate = null ]"

which causes exceptions because the right hand side of the "=" is 'null' (not something that means null).

I'll update the postgis driver to handle this case, but its likely that
<PropertyIsNull>...</PropertyIsNull>
AND
<PropertyIsEqualTo>
  ...
   <Literal><Literal>
</PropertyIsEqualTo>

Will cause exceptions in *MOST* datastores.

I'm only changing this in the postgis driver (SQLEncoderPostgis) because I believe its done differently in different databases.

SELECT * FROM <table> WHERE <column> isnull;  -- postgresql
SELECT * FROM <table> WHERE isnull(<column>); -- oracle???

Other databases will have problems too.

dave


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Geotools-devel mailing list
Geotools-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Reply via email to