Skip to content

Cannot execute stored procedure #14787

@alfemy

Description

@alfemy

Describe the bug

Cannot execute a stored procedure. Nothing happens when a user clicks to "Execute" routine button

To Reproduce

  • phpMyAdmin 4.8.4

Steps to reproduce the behavior:

  1. Create a DB
  2. Create a stored procedure. For example:
DELIMITER //  
CREATE PROCEDURE `p2` ()  
LANGUAGE SQL  
DETERMINISTIC  
SQL SECURITY DEFINER  
COMMENT 'A procedure'  
BEGIN  
    SELECT 'Hello World !';  
END//
  1. Execute the stored procedure: Go to 'routines -> p2 -> execute'

Actual behavior

  1. The stored procedure was executed
  2. "Hello World!" was not be displayed

Expected behavior

  1. The stored procedure was executed
  2. "Hello World!" was displayed

Screenshots

screencast 2018-12-16 18-37-42

Server configuration

  • Operating system: Checked at Centos 7 and at Docker
  • Web server: Nginx
  • Database version: 10.0.37-MariaDB-1~xenial
  • phpMyAdmin version: 4.8.4

Additional context

Checked at Centos 7 and using official phpMyAdmin docker image. There is no such issue in phpMyAdmin 4.8.3 version. A stored procedure may be executed via SQL console but cannot be executed using "routines" menu

Metadata

Metadata

Assignees

Labels

BugA problem or regression with an existing feature

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions