Quantcast

Duplicate keyword "DEFAULT" in storage procedure

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Duplicate keyword "DEFAULT" in storage procedure

break1
FlameRobin 0.9.3.2220 Unicod
Ubuntu 14.04
firebird2.5-classic  Version: 2.5.2.26540.ds4-9ubuntu1


If add DEFAULT value to input parameters with domain type in storage procedure when after close it and when open in next time (alter procedure by flamerobin gui) - keyword "DEFAULT" is duplicate!

CREATE DOMAIN D_INTEGER
 AS integer
 NOT NULL
;

CREATE PROCEDURE TEST_DEFAULT_FR_BUG (
    INPUT_P1 integer,
    INPUT_P2 D_INTEGER,
    INPUT_P3 D_INTEGER DEFAULT 0
)
AS
BEGIN
END

-----------------------------------
after click alter in flame robin procedure look like this:

ALTER PROCEDURE TEST_DEFAULT_FR_BUG (
    INPUT_P1 integer,
    INPUT_P2 D_INTEGER,
    INPUT_P3 D_INTEGER DEFAULT DEFAULT 0 )
AS
BEGIN
END
Loading...