[mapserver-dev] Oracle SQL (MS trunk)

[Smith, Michael ERDC-USACE-NH]

Bart,

I'm not sure about the 2 objectid's, but it is probably due to requesting
unique OBJECTID. This gets added to the column list with has all the columns
already present. The NULL is probably a blob column, perhaps an
SE_ANNO_CAD_DATA column. NULLing it out was a patch I submitted to allow WFS
to work when you have a blob column.

Mike


-- 
Michael Smith
RSGIS Center
US Army Corps of Engineers




On 12/10/09 6:30 AM, "bartvde at osgis.nl" <bartvde at osgis.nl> wrote:

> 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
> 
> _______________________________________________
> mapserver-dev mailing list
> mapserver-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-dev