#4829 (ok 4.4.2) Create procedure via SQL Editor not more possible

[Arnaud Kazlov]

It's not more possible to create a function or procedure using SQL-Editor. It hangs up without error. I mean for example:
DELIMITER $$
CREATE FUNCTION test(p_hd_nr INT(6), p_date VARCHAR(10)) RETURNS decimal(4,2)
DETERMINISTIC
BEGIN
declare rating_vorschlag_hymer DECIMAL(4,2);
declare hd_land VARCHAR(20);
/ .... /
end

[Arnaud Kazlov]

Also to import functions or procedures is not possible. Thanks

[Marc Delisle]

Cannot reproduce with 4.4.0, typing this in the SQL query box:
DELIMITER $$
CREATE FUNCTION test(p_hd_nr INT(6), p_date VARCHAR(10)) RETURNS decimal(4,2)
DETERMINISTIC
BEGIN
declare rating_vorschlag_hymer DECIMAL(4,2);
declare hd_land VARCHAR(20);
return 12;
end

Tested with MySQL 5.6.15, PHP 5.6.3, mysqli extension, mysqlnd client.

[Madhura Jayaratne]

I am also unable to reproduce this. Are you able to create these functions or procedures with mysql command line?

[Arnaud Kazlov]

yes, i can create this function via Terminal, but not directly. And it's not possible to import this function

[Arnaud Kazlov]

for example:

delimiter $$
CREATE FUNCTION test_function(p_auto_nr INT(6), p_home_id TINYINT, p_dev_kue VARCHAR(4)) RETURNS decimal(10,0)
DETERMINISTIC
BEGIN
Select sum(bl.value)
into @a
from tab2 bl
where bl.dev_kue = p_dev_kue
AND bl.auto_nr=p_auto_nr
and bl.home_id =p_home_id
AND bl.datum between (curdate() - interval 10 day) and curdate();
return @a;
END

---

Thank you

[Madhura Jayaratne]

I can reproduce the problem with this one.

[Arnaud Kazlov]

This error occurs since phpmyadmin Version > 4.2.12. I have teted it. That because I work with 4.2.12 without problems.

[Madhura Jayaratne]

Possibly related to https://sourceforge.net/p/phpmyadmin/bugs/4848/

[Madhura Jayaratne]

Fixed with https://github.com/phpmyadmin/phpmyadmin/commit/be47fbac53be8d86b8d3f116682c862a289c6d7a