Stored Procedure Datatype Error

Hi. I'm using version 11.0.0.5919.

When importing a stored procedure from a query, the GUI parameters listing for the stored procedure truncates the datatype for DECIMAL(19,4) data types.

Here's an example:

drop procedure if exists usp_test;
delimiter |
create procedure usp_test
(
in v_something int
, in v_transaction_base decimal (19, 4)
, in v_transaction_approved decimal (19, 4)
, in v_transaction_long_name_due decimal (19, 4)
)
    sql security definer
    begin
    insert into trxs
        (
        a
        , b
        , c
        , d
        )
    values  (
        v_something
        , v_transaction_base
        , v_transaction_approved
        , v_transaction_long_name_due
        );
    end |
delimiter ;

May this be fixed?

Could you remove the file attachment containing ip... added by mistake. Thx.

I obfuscated the ip address your screenshot, hope that does it.

For the mentioned issue in HeidiSQL, you should retry with the latest build. 5919 is the latest release, while the latest build has >100 modifications.

Thanks for the reply and obfuscating the ip. :)

I'd just ran version 6104 and the issue remains the same.

Maybe something to look into in the future, as I can easily work around the issue by dropping and re-creating the procedure by script.

Okay... I think I found the problem...

On the parameters list in the script, if there is a space between the decimal and the round brackets, it does not properly parse the "19,4".

Works: decimal(19,4) or decimal(19, 4) Fails: decimal (19,4) or decimal (19, 4)