[fdo-trac] #540: Add XYZM functions to ArcSDE, MySQL, SQLServerSpatial and WFS

[FDO]

#540: Add XYZM functions to ArcSDE, MySQL, SQLServerSpatial and WFS
---------------------------------------------------------------------------+
 Reporter:  brentrobinson                                                  |         Owner:  brentrobinson
     Type:  enhancement                                                    |        Status:  assigned     
 Priority:  major                                                          |     Milestone:  3.5.0        
Component:  General                                                        |       Version:  3.5.0        
 Severity:  2                                                              |    Resolution:               
 Keywords:  Expression X Y Z M function ArcSDE MySQL SQLServerSpatial WFS  |   External_id:               
---------------------------------------------------------------------------+
Changes (by brentrobinson):

  * status:  new => assigned

Comment:

 Revision: 4837
 Author: brentrobinson
 Date: 8:27:41 AM, Thursday, July 16, 2009
 Message:
 Ticket#540: Added XYZM functions to the MySQL, ODBC,
 SQLServerSpatial and WFS providers. The following components were
 effected:

 Expression Engine:

 Made X, Y, Z and M functions standard since they are now supported by most
 providers.

 MySQL Provider:

 Evaluate X and Y functions natively.

 Evaluate Z and M functions by Expression Engine. However, the MySQL
 provider only supports 2D geometries so these functions will always return
 NULL.

 ODBC Provider

 Evaluate X, Y, Z and M functions through the Expression Engine. Although
 not in scope, it was easier to add support than disable it.

 In the future, it would be possible to evaluate these functions natively
 since one would simply need to retrieve the X, Y or Z column value.

 SQLServerSpatial Provider:

 Evaluate Z and M functions natively.

 Evaluate X and Y functions by Expression Engine.SQL Server 2008's X and Y
 functions do not work for geometries with geodetic coordinate system.

 SDF Provider

 Removed custom code to add XYZM functions to supported list. They are now
 picked up as standard functions.

 Moved part of ExpressionFunctionTest code down to Utilities\TestCommon so
 it can be shared with RDBMS and WFS unit tests.

 SHP Provider:

 Removed custom code to add XYZM functions to supported list. They are now
 picked up as standard functions.

 WFS Provider:

 Evaluate X, Y, Z and M functions (in select properties) by Expression
 Engine. WFS does not support computed properties in select list so not
 possible to evaluate natively. The Expression Engine was added to the WFS
 provider.

 Ealuate X, Y, Z and M functions (in filter) natively. TODO: evaluate these
 by Expression Engine when underlying WFS does not support them. However,
 we would first have to add the parsing of supported functions from the WFS
 capabilities to be able to determine if the functions are supported or
 not.

 Added XYZM function unit test.

 None of the other standard functions were added to the WFS Provider's list
 of supported functions as advertise through capabilities.

 ----
 Modified :
 /trunk/Utilities/ExpressionEngine/Src/ExpressionEngineInitializeClass.h
 Modified : /trunk/Utilities/TestCommon/CMakeLists.txt
 Added : /trunk/Utilities/TestCommon/Inc/TestCommonExpressionFunction.h
 Added : /trunk/Utilities/TestCommon/Inc/TestCommonExpressionFunctionR.h
 Added : /trunk/Utilities/TestCommon/Inc/TestCommonExpressionFunctionW.h
 Modified : /trunk/Utilities/TestCommon/Makefile.am
 Added : /trunk/Utilities/TestCommon/Src/TestCommonExpressionFunction.cpp
 Added : /trunk/Utilities/TestCommon/Src/TestCommonExpressionFunctionR.cpp
 Added : /trunk/Utilities/TestCommon/Src/TestCommonExpressionFunctionW.cpp
 Modified : /trunk/Utilities/TestCommon/TestCommon.vcproj

 Revision: 4838
 Author: brentrobinson
 Date: 8:31:02 AM, Thursday, July 16, 2009
 Message:
 Ticket#540: added the XYZM functions to the MySQL, ODBC,
 SQLServerSpatial and WFS providers. See revision 4837 for more details.
 ----
 Modified :
 /trunk/Providers/GenericRdbms/Src/MySQL/Fdo/FdoRdbmsMySqlFilterProcessor.cpp
 Modified :
 /trunk/Providers/GenericRdbms/Src/ODBC/Fdo/FdoRdbmsOdbcFilterProcessor.cpp
 Modified :
 /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/Fdo/FdoRdbmsSqlServerFilterProcessor.cpp
 Modified :
 /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/Fdo/FdoRdbmsSqlServerFilterProcessor.h
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/Common/FdoExpressionFunctionTest.cpp
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/Common/FdoExpressionFunctionTest.h
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/Common/SchemaMgrTests.cpp
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcFdoConnectTest.cpp
 Added :
 /trunk/Providers/GenericRdbms/Src/UnitTest/gen_default1_SqlServer2008_master.txt
 Modified : /trunk/Providers/SHP/Src/Provider/ShpConnection.cpp
 Modified : /trunk/Providers/SHP/Src/Provider/ShpExpressionCapabilities.cpp
 Modified : /trunk/Providers/WFS/Src/Makefile.am
 Modified : /trunk/Providers/WFS/Src/Provider/CMakeLists.txt
 Modified : /trunk/Providers/WFS/Src/Provider/FdoWfsCommandCapabilities.cpp
 Modified :
 /trunk/Providers/WFS/Src/Provider/FdoWfsExpressionCapabilities.cpp
 Modified : /trunk/Providers/WFS/Src/Provider/FdoWfsSelectCommand.cpp
 Modified : /trunk/Providers/WFS/Src/Provider/Makefile.am
 Modified : /trunk/Providers/WFS/Src/Provider/WFSProvider.vcproj
 Modified : /trunk/Providers/WFS/Src/WFSOS.sln

 Revision: 4839
 Author: brentrobinson
 Date: 8:32:24 AM, Thursday, July 16, 2009
 Message:
 Ticket#540: Made XYZM functions standard. See revision 4837 for more
 details.
 ----
 Modified : /trunk/Providers/SDF/Src/Provider/SdfConnection.cpp
 Modified : /trunk/Providers/SDF/Src/Provider/SdfExpressionCapabilities.cpp
 Modified : /trunk/Providers/SDF/Src/UnitTest/FdoExpressionFunctionTest.cpp
 Modified : /trunk/Providers/SDF/Src/UnitTest/FdoExpressionFunctionTest.h

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