Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Stored Procedure Datatype Error

airkatz's profile image airkatz posted 2 weeks ago in General Permalink

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?

2 attachment(s):
  • 1
  • 2
airkatz's profile image airkatz posted 2 weeks ago Permalink

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

ansgar's profile image ansgar posted 2 weeks ago Permalink

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.

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
airkatz's profile image airkatz posted 2 weeks ago Permalink

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.

airkatz's profile image airkatz posted 2 weeks ago Permalink

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)

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.