[fdo][FDO351][New] GenericRdbms: ApplySchema alters pre-existing views.

[Brent Robinson]

You can view the artifact detail at the following URL:

    https://fdo.osgeo.org/servlets/Scarab/id/FDO351

Type
 Defect

Artifact ID
 FDO351 (GenericRdbms: ApplySchema alters pre-existing views.)

Reported by
 Brent Robinson
 brentrobinson (brent.robinson at autodesk.com)

New artifact details:
---------------------------------------------------------

- Artifact created
- Operating system set to new value
  All
- Component set to new value
  RDBMS
- Artifact Status set to new value
  New
- Subcomponent set to new value
  SCHEMA
- Platform set to new value
  All
- Priority set to new value
  P2
- Description set to new value
  Through the use of Schema Overrides, it is possible to map a class definition to a pre-existing view in an FDO-enabled datastore. 

However, when this is done, ApplySchema tries to add system property columns to the view. It attempts to drop and re-create the view with the new columns. However, the Schema Manager does not track the underlying selects for these views so the re-create fails. This effectively drops the view.
- Summary set to new value
  GenericRdbms: ApplySchema alters pre-existing views.
- Steps to Reproduce set to new value
  - created an FDO-enabled datastore.
- created the following table:

  create table parceltable (
    featureid decimal(20) not null,
    parcelkey varchar(256),
    primary key (featureid)
  )

- created the following view:

  create view myparcel as select * from parceltable;

- create a feature schema and override set. The schema contains a single feature class. The override set maps the feature class ontp the view. 

- perform an ApplySchema from the schema and overrides. 


- Version set to new value
  V2

---------------------------------------------------------
This message was automatically generated by Project Tracker.