Product: Aqua Data Studio
Version: 18.0.0-devi-226
Build #: 51076
Build Date: 2016-Sep-07 04:59:15 PM
Operating Environment: Windows 7 (6.1, x86) / Cp1252 / en / IN / Oracle Corporation 1.8.0_101-b13
Memory: Max=766,312,448; Total=182,603,776; Free=98,376,232; CPUs=8
Connect Database Sybase Anywhere 16
Steps:
1. Create trigger manually on query analyser on the table "test_pk1".
The script is mentioned below.
ALTER TRIGGER DBA.TRIG1
after INSERT, UPDATE
On test_pk1
REFERENCING NEW AS new_row
FOR EACH ROW
BEGIN
select * from test_pk1
END
GO
2. While typing code, in "BEGIN" block after writing "select" word, it automatically pop-ups list of tables.
3. The Same behaviour is happened after typing "from" word which is expected.
Actual Result:
After typing "select" keyword automatically list of tables pops out.
If a table is selected from the list which is coming after "from" keyword, then it doesn't pop up column name list. It again shows the list of tables.
Expected Result:
Nothing should pop up after "select" keyword. List of tables should pop up after "from" keyword.
If a table is selected from the list which is coming after "from" keyword, then it should pop up column name list of respective table.
Observation:
Column list not popping up for the respective table in triggers.
All previous versions showing the same behaviour.
