Opened 12 years ago

Closed 11 years ago

#841 closed enhancement (fixed)

ODBC Provider fixes for Teradata

Reported by: brentrobinson Owned by: brentrobinson
Priority: major Milestone: 3.6.0
Component: ODBC Provider Version: 3.6.0
Severity: 2 Keywords: ODBC Teradata
Cc: External ID:

Description

Implement fixes to allow ODBC provider to work with Teradata sources.

Change History (3)

comment:1 by brentrobinson, 12 years ago

Resolution: → fixed
Status: new → closed

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

comment:2 by brentrobinson, 11 years ago

Resolution: fixed
Status: closed → reopened

comment:3 by brentrobinson, 11 years ago

Resolution: → fixed
Status: reopened → closed

Revision: 6765 Author: brentrobinson Date: 9:50:19 AM, Wednesday, January 30, 2013 Message: Ticket#841: Removed fallback, to set identity to not null properties, for all data sources in addition to Teradata.

Modified : /trunk/Providers/GenericRdbms/Src/ODBCDriver/pkeys_.c Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcBaseSetup.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcFdoSelectTest.cpp

Note: See TracTickets for help on using tickets.