Opened 15 years ago
Closed 15 years ago
#470 closed enhancement (fixed)
SQLServerSpatial: Load indexes for views.
| Reported by: | brentrobinson | Owned by: | brentrobinson |
|---|---|---|---|
| Priority: | major | Milestone: | |
| Component: | SQLServer Spatial | Version: | 3.4.0 |
| Severity: | 2 | Keywords: | SQLServerSpatial view index identity property |
| Cc: | External ID: |
Description
The RDBMS providers currently assume that only tables have indexes, so they don't check for indexes on views. SQL Server allows views to have clustered indexes.
This ticket will change the RDBMS provider schema manager to load indexes for views. Unique indexes will be useful for generating identity properties for classes derived from views. This increases the changes of these classes having identity, allowing their features to be selectable and updatable in application that use FDO.
Change History (2)
comment:1 by , 15 years ago
| Status: | new → assigned |
|---|
comment:2 by , 15 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
Note:
See TracTickets
for help on using tickets.
Revision: 4415 Author: brentrobinson Date: 2:29:09 PM, Wednesday, March 11, 2009 Message: Ticket#470: RDBMS: Support generating identity properties from indexes on views.
Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/DbObject.cpp Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/DbObject.h Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/Index.cpp Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/Index.h Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/Table.cpp Modified : /trunk/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/Table.h Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/DbObject.cpp Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/DbObject.h Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Index.cpp Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Index.h Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Table.cpp Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Table.h Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/DbObject.cpp Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/DbObject.h Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Index.cpp Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Index.h Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/SpatialIndex.cpp Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/SpatialIndex.h Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Table.cpp Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Table.h Modified : /trunk/Providers/GenericRdbms/Src/SchemaMgr/Ph/Index.cpp Modified : /trunk/Providers/GenericRdbms/Src/SchemaMgr/Ph/Index.h Modified : /trunk/Providers/GenericRdbms/Src/SchemaMgr/Ph/Mgr.cpp Modified : /trunk/Providers/GenericRdbms/Src/SchemaMgr/Ph/Mgr.h Modified : /trunk/Providers/GenericRdbms/Src/SchemaMgr/Ph/Table.cpp Modified : /trunk/Providers/GenericRdbms/Src/SchemaMgr/Ph/Table.h Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Common/SchemaMgrTests.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Common/SchemaMgrTests.h Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/SQLServerSpatial/SqlServerSchemaMgrTests.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/SQLServerSpatial/SqlServerSchemaMgrTests.h Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/DbObject.h Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/Index.h Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/Mgr.h Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/SpatialIndex.h Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/Table.h Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/DbObject.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Index.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Owner.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/SpatialIndex.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Table.cpp