Roundtripping of views in PD 9.5.2 is unreliable..

[Damon Rand]

Hi there,

I think there is a bug with PD and views.

If I reverse engineer a view into my model and then use "modify
database" or "generate database" to rebuild the view from the model it
seems that PD 9.5.2.873 (or maybe Sybase 12.5.0.3) will change the SQL
formatting in such a way as to make it appear that the model is
outdated.

I haven't exactly exactly what sql code has problems but one example
of a view that is unreliable is on with sql containing comments..

eg. When I generate this view from the model an then RE it makes me
merge the view into the model again unnecessarily.

create view dbo.myview as
select dk.document_id as document_id
from document dk, keyword k
where dk.keyword_id = k.keyword_id
/* to speed up things */
and d.record_date > '12/31/2000'
go

Regards,
Damon.