[mapserver-dev] Oracle SQL (MS trunk)

[bartvde at osgis.nl]

Hi Mike,

indeed, that was also my thinking.

I've opened up a ticket for further discussion:

http://trac.osgeo.org/mapserver/ticket/3228

Best regards,
Bart

> 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
>>>
>>>
>>
>>
>
>