#11551: Display wrong statement separator for view in Redshift.

kirtipbankar(*) reported 2014-01-29T07:28:41Z · last modified 2014-05-06T09:13:25Z

Dev	ivangron
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	DB - RedShift
Version	15.0

Product: Aqua Data Studio

Version: 15.0.0-dev-86

Database Version : Redshift

Connect Redshift:-

Step-1

Create view

CREATE VIEW "myschema"."view1"

SELECT test1.col1, test1.col2, test1.col3 FROM myschema.test1;

Step:02

Go to view tree node-> Right click on view->Select Scripting options-> Open Options window->

Select Amazon Redshift Database from list->Select Statement Separator '/' option and click on OK button.

Step-03

Go to view tree node->Right click on "view1" view-> Script object to window as->Select CREATE option.

Now you will observe that, ,It display wrong statement separator in view.

All Comments (4) Change History

ivangron 2014-02-10T23:29:49Z

Code was accidentally looking at the postgres settings. Fixed...

kirtipbankar(*) 2014-02-14T12:03:03Z

Verified in ADS 15.0.0-dev-110

tariqrahiman 2014-05-05T21:13:02Z

Verified in 15.0.0-dev-266

kirtipbankar(*) 2014-05-06T09:13:25Z

Verified in 15.0.0-dev-268