[fdo-trac] #699: RDBMS: Fixes for classes with inherited associations and constraints

[FDO]

#699: RDBMS: Fixes for classes with inherited associations and constraints
-----------------------------------------------------------------------+----
 Reporter:  brentrobinson                                              |         Owner:  brentrobinson
     Type:  defect                                                     |        Status:  closed       
 Priority:  minor                                                      |     Milestone:  3.6.0        
Component:  GenericRdbms API                                           |       Version:               
 Severity:  3                                                          |    Resolution:  fixed        
 Keywords:  Association Property List Constraint inherited base class  |   External_id:               
-----------------------------------------------------------------------+----
Changes (by brentrobinson):

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


Comment:

 Revision: 5723
 Author: brentrobinson
 Date: 11:30:38 AM, Friday, October 01, 2010
 Message:
 Ticket#699: Modified the SQL for retrieving unique and check constraints,
 to go against the SQLServer sys views instead of the information_schema.
 This resolves a problem that occurred when ApplySchema created a class
 that inherits from an existing class with check constraint longer than
 4000 characters. The constraint got truncated and the creation of the
 class table failed with SQL syntax error. The problem can still happen but
 the constraint now has to be longer than 32000 characters.

 This change also speeds up the retrieval of unique and check constraints.
 ----
 Modified :
 /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/ODBCDriver/constants.h
 Modified :
 /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/ODBCDriver/desc_slct.c
 Modified :
 /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Rd/ConstraintReader.cpp
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/apply_no_meta_test1_SQLServerSpatial_master.xml

 Revision: 5739
 Author: brentrobinson
 Date: 10:27:22 AM, Tuesday, October 05, 2010
 Message:
 Ticket#699: Added test for creating class based on existing class that has
 association properties.
 ----
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/Common/FdoAssociationSchemaTest.cpp
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/Common/FdoAssociationSchemaTest.h

 Revision: 5740
 Author: brentrobinson
 Date: 8:48:43 AM, Thursday, October 07, 2010
 Message:
 Ticket#699: Added case for adding class based on existing class with
 constraints.
 ----
 Modified : /trunk/Utilities/TestCommon/Src/TestCommonConstraints.cpp

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