id summary reporter owner description type status priority milestone component version severity resolution keywords cc external_id 889 SQLServerSpatial removes parenthesis in filters beginbenoit danstoica "The SQLServerSpatial provider removes parenthesis that are not used for an IN clause. This causes major issues with the actual clause logic not being applied properly if you use any OR operators. For exemple, if you set a filter such as ""(ColumnA = '1' OR ColumnA = '2') AND ColumnB = '3'"", the resulting filter will not have the parenthesis and the logic becomes completely broken. This creates an issue in software such as Mapguide when you use the API. If you also apply a spatial filter. Without any parenthesis anywhere, the query does not respect the logic. To validate that it is a provider specific issue, I tested the same filter and API manipulation against the SDF provider and it returns the proper records for my filter logic. To reproduce the issue, I simply used FDO Toolbox 1.2.0.1267 and ran the same query on an SQL Server table and an SDF. The query returns the proper results for the SDF provider, but the SQL Server provider does not. I also confirmed using the API directly. I create an ISelect on an SQL Server provider, set the filter and then inspect the filter via debugging and notice my parenthesis have dissapeared." defect closed major 3.8.0 SQLServer Spatial 3.8.0 1 fixed