Version: 17.0.2-2
Build #: 48494
Build Date: 2016-Feb-05 09:47:03 AM
Sybase ASE Materialized View: ADS does not script the complete DDL
To reproduce:
1. Navigate to Sybase ASE v16 at AWS ending 1.69
2. Go to pubs2 database
3. Try to Script the Materialized View dbo.MAT_VIEW_TEST with Script Object to Window -> Create
4. You can see that the script does not contain the full script.
ADS scripts the below
CREATE MATERIALIZED VIEW dbo.MAT_VIEW_TEST
constraint Account_MAT_PK unique ( accountID )
enable
populate
enable use in optimization
immediate refresh
lock allpages
as select
accountID = a.bankAccountID
, accountIdentification =
GO
5. The original script that i used to create the MAT view is as below
create materialized view MAT_VIEW_TEST
constraint Account_MAT_PK unique ( accountID )
enable
populate
enable use in optimization
immediate refresh
lock allpages
as select
accountID = a.bankAccountID
, accountIdentification = a.accountIdentification
, currencyCode = a.currencyCode
, bankID = a.bankID
, institutionName = b.institutionName
, globalCompanyID = c.customerPoolID
, bclCode = b.bclCode
, branchCode = b.branchCode
, accountName = a.name
, referenceCompanyID = a.referenceCompanyID
, accountPurpose = a.accountPurpose
, activeStatus = a.activeStatus
, activeStatusAt = a.activeStatusAt
from
dbo."bug_bank" b,
dbo."bug_BankAccount" a,
dbo."bug_customer" c
The source of the object comes back in multiple record. We check to see if the map of the object source is part of the previous record but forgot to put the object in the map. object will fully script now without issues.