CREATE DATABASE A;
USE A;
delimiter //
CREATE PROCEDURE simpleproc()
    BEGIN
       SELECT 1;
    END//
delimiter ;
CREATE DATABASE a;
USE a;
delimiter //
CREATE PROCEDURE simpleproc()
    BEGIN
       SELECT 2;
    END//
delimiter ;
use a;
SHOW CREATE PROCEDURE simpleproc;
-- Shows correctly SELECT 2
USE A;
SHOW CREATE PROCEDURE simpleproc;
-- Shows SELECT 2 too when it should show SELECT 1

DROP DATABASE A;
DROP DATABASE a;

