[Fdo-trac] [fdo-trac] #841: ODBC Provider fixes for Teradata

[FDO]

#841: ODBC Provider fixes for Teradata
---------------------------+------------------------------------------------
 Reporter:  brentrobinson  |         Owner:  brentrobinson
     Type:  enhancement    |        Status:  closed       
 Priority:  major          |     Milestone:  3.6.0        
Component:  ODBC Provider  |       Version:  3.6.0        
 Severity:  2              |    Resolution:  fixed        
 Keywords:  ODBC Teradata  |   External_id:               
---------------------------+------------------------------------------------
Changes (by brentrobinson):

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


Comment:

 Revision: 6500
 Author: brentrobinson
 Date: 3:30:47 PM, Tuesday, July 10, 2012
 Message:
 Ticket#841: Various fixes to allow ODBC provider to work with Teradata
 sources:
     - removed fallback to set class identity properties to all not-null
       properties. This was problematic for views since, if the geometry
       columns were not null, they were included in the identity and no
       available as geometry ordinate columns. In FDO 3.6, this change
       applies only when the data source is Teradata. However,
       in FDO 3.8, the plan is to remove this fallback for all ODBC
 sources.

     - For Teradata sources, limit retrieving schema information to the
       current database. A Teradata server can have many tables and views
       among several databases. Describing schemas is too slow when schema
       info for the whole server is retrieved.

     - For Teradata sources, recognize the SQL_TYPE_DATE data type, and
       support reading them as datetime properties.
 ----
 Modified : /branches/3.6/Providers/GenericRdbms/Inc/Rdbi/vndr_info.h
 Modified :
 /branches/3.6/Providers/GenericRdbms/Src/ODBC/SchemaMgr/OdbcSchemaMgr.vcproj
 Modified :
 /branches/3.6/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Database.cpp
 Modified :
 /branches/3.6/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Mgr.cpp
 Modified :
 /branches/3.6/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Owner.cpp
 Added :
 /branches/3.6/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Rd/TeraSchemaReader.cpp
 Added :
 /branches/3.6/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Rd/TeraSchemaReader.h
 Modified : /branches/3.6/Providers/GenericRdbms/Src/ODBCDriver/col_.c
 Modified : /branches/3.6/Providers/GenericRdbms/Src/ODBCDriver/connect.c
 Modified : /branches/3.6/Providers/GenericRdbms/Src/ODBCDriver/constants.h
 Modified : /branches/3.6/Providers/GenericRdbms/Src/ODBCDriver/desc_slct.c
 Modified : /branches/3.6/Providers/GenericRdbms/Src/ODBCDriver/pkeys_.c
 Modified : /branches/3.6/Providers/GenericRdbms/Src/ODBCDriver/vndr_info.c

 Revision: 6509
 Author: brentrobinson
 Date: 9:17:36 AM, Wednesday, July 18, 2012
 Message:
 Ticket#841: Ported revision 6500 from 3.6 to 3.7 branch.
 ----
 Modified : /branches/3.7/Providers/GenericRdbms/Inc/Rdbi/vndr_info.h
 Modified :
 /branches/3.7/Providers/GenericRdbms/Src/ODBC/SchemaMgr/OdbcSchemaMgr.vcproj
 Modified :
 /branches/3.7/Providers/GenericRdbms/Src/ODBC/SchemaMgr/OdbcSchemaMgr.vcxproj
 Modified :
 /branches/3.7/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Database.cpp
 Modified :
 /branches/3.7/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Mgr.cpp
 Modified :
 /branches/3.7/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Owner.cpp
 Added :
 /branches/3.7/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Rd/TeraSchemaReader.cpp
 (Copy from path:
 /branches/3.6/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Rd/TeraSchemaReader.cpp,
 Revision, 6500)
 Added :
 /branches/3.7/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Rd/TeraSchemaReader.h
 (Copy from path:
 /branches/3.6/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Rd/TeraSchemaReader.h,
 Revision, 6500)
 Modified : /branches/3.7/Providers/GenericRdbms/Src/ODBCDriver/col_.c
 Modified : /branches/3.7/Providers/GenericRdbms/Src/ODBCDriver/connect.c
 Modified : /branches/3.7/Providers/GenericRdbms/Src/ODBCDriver/constants.h
 Modified : /branches/3.7/Providers/GenericRdbms/Src/ODBCDriver/desc_slct.c
 Modified : /branches/3.7/Providers/GenericRdbms/Src/ODBCDriver/pkeys_.c
 Modified : /branches/3.7/Providers/GenericRdbms/Src/ODBCDriver/vndr_info.c


 Revision: 6513
 Author: brentrobinson
 Date: 12:51:32 PM, Thursday, July 19, 2012
 Message:
 Ticket#841: Ported revision 6500 from 3.6 branch to trunk.
 ----
 Modified : /trunk/Providers/GenericRdbms/Inc/Rdbi/vndr_info.h
 Modified :
 /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/OdbcSchemaMgr.vcproj
 Modified :
 /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/OdbcSchemaMgr.vcxproj
 Modified :
 /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Database.cpp
 Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Mgr.cpp
 Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Owner.cpp
 Added :
 /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Rd/TeraSchemaReader.cpp
 (Copy from path:
 /branches/3.6/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Rd/TeraSchemaReader.cpp,
 Revision, 6500)
 Added :
 /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Rd/TeraSchemaReader.h
 (Copy from path:
 /branches/3.6/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Rd/TeraSchemaReader.h,
 Revision, 6500)
 Modified : /trunk/Providers/GenericRdbms/Src/ODBCDriver/col_.c
 Modified : /trunk/Providers/GenericRdbms/Src/ODBCDriver/connect.c
 Modified : /trunk/Providers/GenericRdbms/Src/ODBCDriver/constants.h
 Modified : /trunk/Providers/GenericRdbms/Src/ODBCDriver/desc_slct.c
 Modified : /trunk/Providers/GenericRdbms/Src/ODBCDriver/pkeys_.c
 Modified : /trunk/Providers/GenericRdbms/Src/ODBCDriver/vndr_info.c

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