[mapserver-dev] Oracle SQL (MS trunk)

[Smith, Michael ERDC-USACE-NH]

Perhaps we can come up with a better patch that just removes the blob
columns rather than substituting the NULL. Its changed somewhat since I
submitted the patch due to the one pass query changes. Jim might also have
some ideas.

Mike


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

> Hi Mike,
> 
> thanks, right, it is an SE_ANNO_CAD_DATA column, but nulling it out also
> means it is also output in the WFS GML, which is unwanted (shows up in
> attribute tables etc.):
> 
> ..
> <rws:PERIMETER>13507.68</rws:PERIMETER>
> <rws:null/>
> </rws:AAA35>
> ..
> 
> Do you see a solution?
> 
> Or do I need to change my DATA statement to exclude it (but then again, I
> need to always change the SQL when the datamodel changes).
> 
> TIA.
> 
> Best regards,
> Bart
> 
>> 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
>> 
>> 
> 
>