#3634 select in stored procedure returns error #1312

3.4.10
fixed
nobody
5
2013-06-11
2012-07-03
Michele Salvador
No

I create a very simple procedure whit only one SELECT

CREATE PROCEDURE `seleziona`()
SELECT Nome FROM utenti;

And then I call it

CALL seleziona;

in local machine no problem
phpMyAdmin 3.4.9 server Apache 2.2.21 (Win32) PHP 5.3.9 MySQL 5.5.20-log

But in production online server
phpMyAdmin 3.4.10.1 server Apache 2.2.22 PHP 5.3.10 MySQL 5.1.56-log
when from SQL window I call this procedure (or every other with a select statement ) phpMyAdmin returns the error
#1312 - PROCEDURE my_database.seleziona can't return a result set in the given context

Discussion

    • milestone: --> 3.4.10
     
  • I started using phpMyAdmin latest version 3.5.1
    this problem of the SELECT in routines seems to have fixed.
    :-)

     
  • Marc Delisle
    Marc Delisle
    2012-07-06

    • status: open --> closed
     
  • Marc Delisle
    Marc Delisle
    2012-07-06

    Great!

     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed --> fixed