[fdo-users] Re: FDO 3.5 ArcSDE Provider Oracle ORA-00920

[maland]

I have debugged the ArcSDE provider source and identified the problem. It
seems to be related to the "nesting" in function
ArcSDEFilterToSql::ProcessBinaryLogicalOperator. It happens when both
operands are "attribute"-style filters. The parenthesis matching is broken.
Where can I post the bugfix proposal so it can be included in the next
release?

Regards
Henning Maeland


oyvind idland wrote:
> 
> I get the same problem here.
> 
> It seems to me that the SQL generator goes a bit too far in wrapping
> everything in parenthesis ?
> 
> Unfortunately it seems that the SDE provider is currently broken.
> 
> 
> -- Oyvind
> 
> 
> On Fri, Oct 1, 2010 at 10:27 AM, maland <hma at powel.com> wrote:
> 
>>
>> I've been able to find the SQL generated by the ArcSDEFilterToSql class,
>> and
>> there is obviously a problem with the parantheses matching. Example of
>> SQL
>> generated:
>>
>> SELECT  XROW, YROW FROM EXAMPLE_POINTS WHERE YROW = 0  AND  ( ( ( (XROW) 
>> =
>> (0)  ( OR  ( (XROW)  =  (1) ) ) )
>>
>> Hopefully the authors of the FDO ArcSDE provider can have a look at this?
>>
>>
>> Regards
>> Henning
>> --
>> View this message in context:
>> http://osgeo-org.1803224.n2.nabble.com/FDO-3-5-ArcSDE-Provider-Oracle-ORA-00920-tp5587468p5590547.html
>> Sent from the FDO Users mailing list archive at Nabble.com.
>> _______________________________________________
>> fdo-users mailing list
>> fdo-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/fdo-users
>>
> 
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
> 
> 

-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/FDO-3-5-ArcSDE-Provider-Oracle-ORA-00920-tp5587468p5700469.html
Sent from the FDO Users mailing list archive at Nabble.com.