[fdo-trac] #499: ODBC: Support non-double SQL Server columns

[FDO]

#499: ODBC: Support non-double SQL Server columns
-----------------------------------------------------+----------------------
 Reporter:  brentrobinson                            |         Owner:  brentrobinson
     Type:  defect                                   |        Status:  closed       
 Priority:  major                                    |     Milestone:  3.5.0        
Component:  ODBC Provider                            |       Version:  3.5.0        
 Severity:  2                                        |    Resolution:  fixed        
 Keywords:  ODBC SQL Server insert geometry decimal  |   External_id:               
-----------------------------------------------------+----------------------
Changes (by brentrobinson):

  * status:  assigned => closed
  * resolution:  => fixed

Comment:

 Revision: 4530
 Author: brentrobinson
 Date: 7:35:05 PM, Monday, April 06, 2009
 Message:
 Ticket#499:

 Modified the PVC Insert and Update handlers to round geometry ordinates to
 the precision specified by their corresponding RDBMS columns. SQL Server
 gives an error if too much precision is supplied.

 The rounding was implemented for all numeric types, including integral
 ones, though these would be used much less frequently for geometry values
 than floating point types.

 The ODBC Column type mapper was mapping the SQL float column type to FDO
 Single data type. However, these columns can store double precision
 numbers so the mapping was changed to FDO Double. This prevents this
 submission from rounding ordinate values for SQL float columns to single
 precision.
 ----
 Modified : /trunk/Providers/GenericRdbms/Src/Fdo/Fdo.vcproj
 Added : /trunk/Providers/GenericRdbms/Src/Fdo/Pvc/FdoRdbmsPvcHandler.cpp
 Modified : /trunk/Providers/GenericRdbms/Src/Fdo/Pvc/FdoRdbmsPvcHandler.h
 Modified :
 /trunk/Providers/GenericRdbms/Src/Fdo/Pvc/FdoRdbmsPvcInsertHandler.cpp
 Modified :
 /trunk/Providers/GenericRdbms/Src/Fdo/Pvc/FdoRdbmsPvcUpdateHandler.cpp
 Modified : /trunk/Providers/GenericRdbms/Src/Fdo/Pvc/Makefile.am
 Modified :
 /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/ColTypeMapper.cpp
 Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/MSTest.mdb
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcBaseSetup.cpp
 Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcBaseSetup.h
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcDescribeSchemaTest.cpp
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcFdoUpdateTest.cpp
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcFdoUpdateTest.h
 Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/Column.h
 Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/ColumnBLOB.h
 Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/ColumnBool.h
 Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/ColumnByte.h
 Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/ColumnChar.h
 Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/ColumnDate.h
 Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/ColumnDecimal.h
 Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/ColumnDouble.h
 Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/ColumnGeom.h
 Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/ColumnInt16.h
 Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/ColumnInt32.h
 Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/ColumnInt64.h
 Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/ColumnSingle.h
 Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/ColumnUnknown.h

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