[mapserver-dev] Oracle SQL (MS trunk)

[bartvde at osgis.nl]

Hi list,

using Mapserver trunk I see the following SQL being generated for Oracle
Spatial layers:

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  ROWNUM<=5  AND
SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, :srid,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window')
= 'TRUE'

Questions:

1) why is OBJECTID requested twice? DATA statement is "SHAPE FROM
BODEM.BODEMKAART50 USING UNIQUE OBJECTID".
2) where is the null after PERIMETER coming from?

Best regards,
Bart