[fdo-users] Re: FDO 3.5 ArcSDE Provider Oracle ORA-00920
hma at powel.com
Wed Nov 3 04:34:23 EDT 2010
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
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,
>> there is obviously a problem with the parantheses matching. Example of
>> 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?
>> View this message in context:
>> Sent from the FDO Users mailing list archive at Nabble.com.
>> fdo-users mailing list
>> fdo-users at lists.osgeo.org
> fdo-users mailing list
> fdo-users at lists.osgeo.org
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.
More information about the fdo-users