Re: [Geotools-devel] Question about JDBCFunctionTest

2011-10-09 Thread christian . mueller
SOLVED. There is a db2 sql construct "CASE WHEN THEN .. ELSE ... END which allows to remap boolean types. I am skipping only 2 tests public void testStrEndsWithOtherProperty() throws IOException public void testStrStartsWithOtherProperty() throws IOException because the use numeric

Re: [Geotools-devel] Question about JDBCFunctionTest

2011-10-09 Thread Andrea Aime
On Sun, Oct 9, 2011 at 4:35 PM, Andrea Aime wrote: > As for, why the "= true", because the filter function per se is not a > filter, it is an expression, > to make it into a filter you have to compare its result with true > (turning it into a PropertyIsEqualsTo > filter). Btw, to expan on this po

Re: [Geotools-devel] Question about JDBCFunctionTest

2011-10-09 Thread Andrea Aime
On Sat, Oct 8, 2011 at 6:24 PM, wrote: > Hi, Andrea > > I am about to finish my DB2FunctionTest. At the moment, there is only a > postgis implementation PostgisFunctionTest. > > Some tests give me headaches. "testEuqalsIgnoreCase" is a good example. The > resulting postgis sql string is: > > SELE

[Geotools-devel] Question about JDBCFunctionTest

2011-10-08 Thread christian . mueller
Hi, Andrea I am about to finish my DB2FunctionTest. At the moment, there is only a postgis implementation PostgisFunctionTest. Some tests give me headaches. "testEuqalsIgnoreCase" is a good example. The resulting postgis sql string is: SELECT "id",encode(ST_AsBinary(ST_Force_2D("geometry")),