× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2016-02-08T17:55:28Z  · raghavsingh last modified 2016-02-11T07:08:43Z

Sybase ASE Materialized View: ADS does not script the complete DDL


customer request
Priority Major
Complexity Unknown
Component Script Object
Version 17.0
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
 
 
1 attachment

Issue #14263

Closed
Fixed
Resolved 2016-02-08T18:30:00Z
 
 
Completion
No due date
Fixed Build v17.0.2-3, v18.0.0-dev-47
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017