#15307: ADS schema tree and 'Script create object' window shows different type name from type columns.

kirtipbankar(*) reported 2017-06-12T11:55:06Z · last modified 2017-07-27T10:57:32Z

ADS schema tree and 'Script create object' window shows different type name from type columns.

Dev	JennyNishimura
QA	SachinPrakash

Priority	Low
Complexity	Unknown

Component	DB - PostgreSQL
Version	19.0

Aqua Data Studio: 19.0.0-alpha-35

Build #: 54677

Build Date: 2017-Jun-11 03:16:01 PM

Operating Environment: Linux (4.4.0-79-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_102-b14

Memory: Max=704,643,072; Total=303,038,464; Free=154,274,664; CPUs=8

Steps

Connect any version of postgreSQL.

create any data type in source

create any domain in the source

Steps-01

Select datatype and domain(using 'Ctrl' button on keyboard)

Right click on it-> Script object to window as -> select 'Create' option

'Script create object' window appears.

Actual result:

Here you can see that, in Type column

'Datatype' name displayed for 'Domain' and

'Object Type' name displayed for 'Datatype'

Please refer screenshot datatype-domain.png

5 attachments

datatype_domain.png

2017-06-12T11:55:06Z

127 KB
scenario02.png

2017-06-12T12:15:23Z

118 KB
scenario03.png

2017-06-12T12:15:24Z

123 KB
Issue15307.png

2017-07-26T23:38:46Z

92 KB
closed_15307.png

2017-07-27T10:57:17Z

58 KB

All Comments (3) Change History

kirtipbankar(*) 2017-06-12T12:15:00Z

Scenario: 02

Right click on created datatype-> Tools -> 'Object search' window

Select particular Database name and Schema name,

Select 'Datatype' from object type pane,

Check on Object Names from Object search pane

Click on the Search button.

Actual result:

The incorrect icon is displayed for the datatype.

Expected result:

The correct icon should be displayed for the datatype.

Refer screenshot scenario02.png

Scenario: 03

Right click on created Domain-> Tools -> 'Object search' window

Select particular Database name and Schema name,

Select 'Domain' from object type pane,

Check on Object Names from Object search pane

Click on the Search button.

Actual result:

The icon is not displayed for Domain objects.

Expected result:

The icon should be displayed for Domain objects.

Refer screenshot scenario03.png

JennyNishimura 2017-07-26T23:43:07Z

Scenario 1 (reported in issue description): WON'T FIX

If you turn on the i18n flag and run ADS, you'll see that the words DATATYPE and OBJECT_TYPE are non-translatable texts. These are internal labels for extraction and scripting. If we try to change them for PostgreSQL, we'll also need to make other code changes to make them work correctly.

Scenarios 2 and 3 (reported in this issue comment): FIXED

These two scenarios showed what the problem would be when the wrong non-translatable object types were being used. I've fixed the Object Search code so that DATATYPE and OBJECT_TYPE are used as labels. With DATATYPE and OBJECT_TYPE as object types, the correct icons are displayed.

Take a look at the attachment Issue15307.png. It explains that when translatable texts are used, we display the labels "Domain" and "Data Type". But when non-translatable object types are used, we display DATATYPE and OBJECT_TYPE.

kirtipbankar(*) 2017-07-27T10:57:32Z

closed and verified issue in ADS19.0.0-beta-24

please refer screenshot closed_15307.png

Search Tips

Aqua Data Studio / nhilam

ADS schema tree and 'Script create object' window shows different type name from type columns.

5 attachments

Issue #15307

Completion

Search Tips

Aqua Data Studio / nhilam

Title

ADS schema tree and 'Script create object' window shows different type name from type columns.

5 attachments

Issue #15307

Completion