[Fdo-trac] [fdo-trac] #889: SQLServerSpatial removes parenthesis in filters

[FDO]

#889: SQLServerSpatial removes parenthesis in filters
---------------------------------+------------------------------------------
   Reporter:  beginbenoit        |       Owner:  danstoica
       Type:  defect             |      Status:  new      
   Priority:  major              |   Milestone:  3.8.0    
  Component:  SQLServer Spatial  |     Version:  3.8.0    
   Severity:  1                  |    Keywords:           
External_id:                     |  
---------------------------------+------------------------------------------

Comment(by beginbenoit):

 Replying to [comment:4 jng]:
 > Try these providers and see if these providers fix your issue.
 >
 > 32-bit:
 http://download.osgeo.org/mapguide/patches/fdo3.9_ticket864/SQLServerSpatialProvider_x86_ticket_864_and_889.zip
 >
 > 64-bit:
 http://download.osgeo.org/mapguide/patches/fdo3.9_ticket864/SQLServerSpatialProvider_x64_ticket_864_and_889.zip
 >
 > If you're using FDO Toolbox, you must use the 1.3 release.

 Tested it against the 1.3 release of FDO Toolbox and the patched version
 does indeed work. However, I traced the SQL Server database and noticed it
 now seems to still change the filter syntax a little bit.

 So my filter was modified to be (ColumnA = '1' OR ColumnA = '2') AND
 (ColumnB = '3'). It respects the logic and fixes the issue.

 Sorry for the extra ticket on the issue, I was under the impression it was
 a different issue. Cheers!

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/889#comment:5>
FDO <http://fdo.osgeo.org/>
Feature Data Objects