I encountered some problem with a stored procedure that sometimes crashes the MySQL broswer. The stored procedure looks more or less like this:
DELIMITER $$
DROP PROCEDURE IF EXISTS `tc`.`GTH` $$
CREATE PROCEDURE `GTH`(IN origID INT)
BEGIN
// create and fill a table called tempT
CREATE TEABLE tempT...
//perform a SELECT statement using tempT, let the returnset be returned
SELECT *
FROM A a, B b, tempT tt
WHERE a.ID = b.ID
AND a.ID = tt.id;
END $$
DELIMITER ;
MySQL Browser exist with lots of strange error messages. Sometimes it doesn't. What is the problem?
Thanks in advance!!
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --