Aqua Data Studio: 18.0.0-devi-225

Build #: 51066

Build Date: 2016-Sep-06 09:50:20 PM

 

Operating Environment: Linux (4.4.0-36-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_72-b15

Memory: Max=704,643,072;  Total=300,941,312;  Free=151,285,352;  CPUs=8

 

Step to reproduce

 

1. Connect Informix 12.1

2. Execute below script for trigger

 

//create table
CREATE TABLE date_datatypes  ( 
   col_date       DATE,
   col_datetime   DATETIME YEAR to SECOND,
   col_interval   INTERVAL YEAR to MONTH 
   )
GO

//Create trigger
CREATE TRIGGER trigger1
INSERT 
  ON date_datatypes
REFERENCING NEW AS new FOR EACH ROW 
(
INSERT INTO informix.date_datatypes(col_date, col_datetime, col_interval) 
   VALUES('2016-9-2', '2016-9-2 19:20:5', '')
)
GO

 

3. Trigger generated successfully in trigger tree node.

4. Right click on created trigger-> Tools-> select 'Object Search'

5. Object search window appears

6. Select Database name(select database in which trigger is created),Schema name,Select Object Trigger,

7. Check on object name, check on Trigger source option.

>>Trigger object name and trigger source sql script is displayed in object search pane.

 

Actual result:

Formatting of Trigger source sql script is displayed incorrectly in object search pane.

 

Please refer screen-shot ADS18-225.png

 

Expected result:

Correct Trigger source sql script should be displayed in object search pane.

 

Observation:

This issue also occurs in ADS-v16 and ADS-v17