× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
kirti bankar
kirtipbankar(*) reported 2014-06-04T10:25:55Z  · last modified 2017-07-27T11:18:14Z

Greenplum - Generate incorrect Alter function script in preview sql tab.


Dev
Jenny Nishimura
JennyNishimura
QA
Tariq Rahiman
tariqrahiman
Priority Minor
Complexity Unknown
Component App - Visual Editing
Version 19.0
Aqua Data Studio 15.0.0-dev-308 
Build #: 38275 
Built on: 2014-Jun-03 04:30:50 PM
 
Connect Greenplum 4.2
1.Create function
 
CREATE FUNCTION "public"."add" (in int4, in int4) RETURNS int4 AS
'select $1 + $2;'
LANGUAGE 'sql' IMMUTABLE STRICT
GO
 
2.Go to database tree node and expand it
3.Go to function tree node and expand it
4.Select Function 'public.add(23 23)' and right click on it
5.Select Alter Function option
6.Alter function window is displayed
7.Change the function name 
8.Go to Preview SQL tab ,Alter function script is generate.
 
ALTER FUNCTION ""public"."add"" (in int4, in int4) RENAME TO "public"."add_func"
GO
CREATE OR REPLACE FUNCTION "public"."add_func" (in int4, in int4) RETURNS int4 AS
'select $1 + $2;'
LANGUAGE 'sql' IMMUTABLE STRICT
 
Now you will observe that, It generate incorrect Alter function script.
3 attachments
  •  
  •  
  • No shares
  •  
All Comments (2) Change History
Sort 

Issue #12245
Closed
Fixed
Resolved 2017-07-26T03:27:37Z
 
 
Completion
No due date
Fixed Build ADS 19.0.0-beta-23
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017