Ticket #3228 (closed defect: fixed)
Oracle driver: remove BLOB/CLOB columns instead of changing them to null
|Reported by:||bartvde||Owned by:||aboudreault|
|Component:||Input - Native Oracle Spatial Support||Version:||svn-trunk (development)|
|Cc:||dmorissette, msmitherdc, bartvde|
Currently, when a table has a BLOB/CLOB column, the name of the column is subsituted with null, so e.g.:
SELECT OBJECTID, OBJECTID, VOOR, LETTER, CYFER, KALK, ACHTER, SCHOP, HEL, GWT, CODE, OMSCHR, EERSTE_BOD, EERSTE_GWT, KLEUR_BOD, KLEUR_GWT, AREA, PERIMETER, null, SHAPE FROM BODEM.BODEMKAART50 WHERE ( (CODE like '%M%' escape '!') And (ACHTER like '%W%' escape '!') ) AND ROWNUM<=100 AND SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE'
However, buy default this will end up in the WFS output as well.
A better way would be to completely remove the column from the list of columns.
Also, while we are at it, we might want to exclude duplicate columns, like OBJECTID which is used twice in the query.