TMyStoredProc does not return the correct code and parameters under mysql 5.0.45-community-nt

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
hkarmeh
Posts: 4
Joined: Thu 01 Apr 2010 22:41

TMyStoredProc does not return the correct code and parameters under mysql 5.0.45-community-nt

Post by hkarmeh » Mon 15 Feb 2021 08:09

hello

create procedure like this:

DELIMITER $$

drop PROCEDURE if exists getsum_sp$$

CREATE PROCEDURE getsum_sp(in a1 int, in a2 int, out A int)
BEGIN

Set A = a1 + a2;
END$$

DELIMITER ;

create a new c++ project and new TMyStoredProc with StoredProcName = 'getsum_sp'

doppel click the component:
1) under mariadb 10.5.8-MariaDB
the sql is: CALL getsum_sp(:a1, :a2, @A); SELECT CAST(@A AS SIGNED) AS '@A'
and the parameters that return are correct.

2) under mysql 5.0.45-community-nt:
the sql is: CALL getsum_sp()
and the parameters that return are not correct.

please help

ViktorV
Devart Team
Posts: 3047
Joined: Wed 30 Jul 2014 07:16

Re: TMyStoredProc does not return the correct code and parameters under mysql 5.0.45-community-nt

Post by ViktorV » Wed 17 Feb 2021 13:23

Thank you for the information. We have reproduced and fixed the issue. This fix will be included in the next build of MyDAC.
We can send you the nigthly build that include the necessary changes.
Please provide your license number and IDE version to us using the contact form https://devart.com/company/contactform.html and we will send you a night build.

Post Reply