[fdo-trac] #756: SQLServerSpatial: Expose synonyms as FDO classes.

[FDO]

#756: SQLServerSpatial: Expose synonyms as FDO classes.
---------------------------------+------------------------------------------
   Reporter:  brentrobinson      |       Owner:  brentrobinson                                 
       Type:  enhancement        |      Status:  assigned                                      
   Priority:  minor              |   Milestone:  3.7.0                                         
  Component:  SQLServer Spatial  |     Version:  3.7.0                                         
   Severity:  3                  |    Keywords:  SQL Server 2008 SQLServerSpatial synonym class
External_id:                     |  
---------------------------------+------------------------------------------

Comment(by brentrobinson):

 Revision: 6011
 Author: brentrobinson
 Date: 1:22:14 PM, Friday, March 25, 2011
 Message:
 Ticket#756: SQLServerSpatial: synonym handling performance improvements.

 In FdoSmPhSynonym:

     - skip fetching foreign keys if referenced table is in a different
 datastore.
       Foreign keys in other datastores are currently not turned into
 association
       properties anyway.

     - Removed fallbacks (for when referenced table cannot be found) which
 look
       for columns, primary keys, foreign keys and indexes directly owned
 by the
       Synonym. The Oracle and SQL Server data dictionaries do not relate
       synonyms directly to these components.

     - Load up synonym reference when asked to load base objects.

     The above eliminate a number of selects that always have an empty
 results set.

 In FdoSmPhSpatialContextGeom

     - Fixed bug introduced by J000-BR9, where the geometry column is
 determined
       to be the base column if it's owning dbObject is differs from the
 current
       dbObject. This was determined by comparing unqualified names, giving
 a false
       match if the 2 dbObjects had same name but were in different
 datastores. Changed
       comparison to be by qualified name.
 ----
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/SQLServerSpatial/SqlServerSchemaMgrTests.cpp
 Modified :
 /trunk/Providers/GenericRdbms/Src/UnitTest/synonyms1_SQLServerSpatial_master.xml
 Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/DbObject.h
 Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/Synonym.h
 Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/SpatialContextGeom.cpp
 Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Synonym.cpp

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