× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
bsriram reported 2022-02-15T02:04:10Z  · last modified 2022-02-15T02:04:10Z

InterBase Stored Procedure Properties showing wrong order of input and output parameters


Priority Major
Complexity Unknown
Component DB - Interbase
Version Future

Software version:

  • Aqua Data Studio 22.1.1, Build #: 59026, Built on: 2021-Oct-20 02:42:43 PM     
  • InterBase 2020
  • Platform: macOS

Problem description:

InterBase stored procedures take input and output parameters. It shows up differently in the metadata extraction (Procedure Properties in ADS). ADS is showing the parameters by alphabetic order, rather than the defined sequence of parameters. Input order is even more important to be correct because callers pass in values for each of those parameters as per the originally defined order.

Steps:

1. Create empty database, and create following stored procedure.

CREATE PROCEDURE Procedure_Param_Order (

                                        Input_Before INTEGER,

                                        Input_After INTEGER

)

RETURNS (Output_Start INTEGER,

         Output_Middle NUMERIC(15, 2),

         Output_End INTEGER

)

AS 

BEGIN 

 

/* This stored procedure should have this order of input and output parameters..

   If it shows up differently in the metadata extraction, there is something

   wrong in the application showing the parameters in order. Input order is even

   more important to be correct because callers pass in values for each of those

   parameters in the originally defined order.

   

   Use command line tool, isql, or IBConsole GUI tool to verify metadata extraction */

 

/* Input Parameters:

     1st parameter: Input_Before

     2nd parameter: Input_After

 

   Output/Result Parameters:

     1st parameter: OutPut_Start

     2nd parameter: OutPut_Middle

     3rd parameter: OutPut_End

*/

 

EXIT; 

END;

COMMIT;

2. Connect to database file from ADS

3. Explore Procedure Properties for the test procedure. You will notice that the input and output arguments are not in the defined order as above. Please see attached screenshot showing the issues in ADS.

4. You can use the command line InterBase tool, isql, or the GUI tool, IBConsole, to verify that they are showing the arguments in the proper order.

1 attachment

Issue #15888

New
 
 
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