Product: Aqua Data Studio

Version: 19.0.0-beta-24

Build #: 55303

Build Date: 2017-Jul-26 09:03:24 PM

 

Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_121-b13

Memory: Max=704,643,072;  Total=375,390,208;  Free=232,735,912;  CPUs=8

Connect to MySQL 5.1

Steps to reproduce:-
1.Launch ADS.
2.Connect to MySQL 5.1 and execute below script on QA.

CREATE TABLE Test_permissions  ( 
   c1 text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
   c2 text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL 
   )
ENGINE = MyISAM
CHARACTER SET latin1
COLLATE latin1_swedish_ci
AUTO_INCREMENT = 0
GO
GRANT SELECT(c2), INSERT(c2), UPDATE(c2), REFERENCES(c2) ON Test_permissions TO SOURCE_USER1@'localhost'
GO
GRANT SELECT(c1), INSERT(c1), UPDATE(c1), REFERENCES(c1) ON Test_permissions TO SOURCE_USER1@'localhost'
GO
GRANT REFERENCES ON Test_permissions TO SOURCE_USER1@'localhost'
GO

3.Go to table 'Test_permissions' in tree node->right click on it->select 'Alter Table'
4.Select user SOURCE_USER1@'localhost' in Permissions tab.
5.Click on 'Columns...' button.
Actual Result:-In alter user window, column 'References' is not displayed.
Expected Result:-'References' column must be displayed as it is displayed for MySQL 5.7.
Please refer the attachment:-References.png

Observation:-

Latest Build (ADS 19.0.0-beta-24)	Issue is observed
ADS 18.0.18-1	Issue is observed
ADS 17	Issue is observed
ADS 16	Issue is observed
ADS 15	Issue is observed