Share

TriActive Java Data Objects (TJDO)

Tracker: Bugs

5 Auto-creation of Views fails when view references other view - ID: 676897
Last Update: Comment added ( pierreg0 )

The auto-creation of tables/views can fail when a view
references another view. This is due to the views not
being created in any particular order. The fix should be
to create views in order of dependency. Example:

TestView.jdo:
CREATE VIEW {this}
(
{this.test}
) AS SELECT {TestClass.test}
FROM {TestClass}

DependentView.jdo:
CREATE VIEW {this}
(
{this.test}
) AS SELECT {TestView.test}
FROM {TestView}


If TJDO tries to create DependentView before TestView,
this fails.


Kelly Grizzle ( pierreg0 ) - 2003-01-29 17:10

5

Closed

Fixed

Kelly Grizzle

Core

v2.0 Beta2

Public


Comment ( 1 )

Date: 2003-02-18 17:50
Sender: pierreg0

Logged In: YES
user_id=524390

This has been fixed and checked into CVS.


Attached File

No Files Currently Attached

Changes ( 3 )

Field Old Value Date By
status_id Open 2003-02-18 17:50 pierreg0
resolution_id None 2003-02-18 17:50 pierreg0
close_date - 2003-02-18 17:50 pierreg0