Product: Aqua Data Studio
Version: 19.0.0-beta-14
Build #: 55132
Build Date: 2017-Jul-13 06:30:40 PM
Operating Environment: Linux (4.4.0-64-generic, amd64) / UTF-8 / en / US / Oracle Corporation 1.8.0_102-b14
Memory: Max=704,643,072; Total=318,242,816; Free=152,019,224; CPUs=8
Connect Sybase IQ-16.0
Scenario-01: view depends on index
CREATE TABLE Table_ind (
title_id varchar(24) NOT NULL,
title varchar(80) NULL
)
IN iq_main
GO
CREATE HG INDEX Table_ind_ind
ON Table_ind(title_id)
IN iq_main
GO
CREATE VIEW view1
AS
SELECT title_id
FROM Table_ind
WITH( INDEX( Table_ind.Table_ind_ind))
GO
Steps-01:
Go to database node
Expand view(view1) node
Expand Dependencies node
Actual Result:
You can see that index object is not extracted in View->Dependencies node, The only Table is displayed in View->Dependencies node
Expected Result:
Index object should be extracted in View->Dependencies node.
Observation:
1)Right click on view(view1) and select View Properties and switch to Dependencies tab
=>You can see that Index and table are extracted successfully in View properties->Dependencies tab
N-issue is not reproduced.