× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Nilesh Mali
nileshhmali reported 2013-10-11T09:52:43Z  · tariqrahiman last modified 2014-04-12T19:22:42Z

Double quote is missing in generated procedure script in schema script generator.


Dev
Ivan Gron
ivangron
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component Tools - Schema Script Gen
Version 15.0
Database version: Postgres-9.2
ADS version : ads-windows-x64-14.0-rc-44
 
Go to procedure node and right click -> Select tools->Select schema script generator->check procedure from object type->
select any procedures from list,click on next button.->select double quote from object quoted identifier,click on next button.
 
Generated text file is as below
 
/*
Script generated by Aqua Data Studio 14.0.0-rc-44 on Oct-11-2013 03:08:07 PM
Database: Nishtha
Schema: nishtha
Objects: PROCEDURE
*/
DROP FUNCTION "nishtha"."test" ()
GO
DROP FUNCTION "nishtha"."Test_procedure" ()
GO
 
CREATE FUNCTION Test_procedure () RETURNS void AS
'DECLARE result integer;
BEGIN
   PERFORM ''select 5 + 7'';
END
'
LANGUAGE 'plpgsql'
GO
 
CREATE FUNCTION test () RETURNS void AS
'
DECLARE
result text;
BEGIN
PERFORM ''SELECT 1+1'';
END;
'
LANGUAGE 'plpgsql'
GO
 
Now you will observe that double quote is missing in generated procedure script.
 

 

3 attachments
  •  
  •  
  • No shares
  •  
All Comments (5) Change History
Sort 

Issue #10409
Closed
Fixed
Resolved 2013-10-23T15:49:03Z
 
 
Completion
No due date
No fixed build
No time estimate

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