Hi folks,
I found a problem with a stored procedure, crashing the MySQL broswer.
The stored procedure looks as:
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 ;
So, what might be 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 --