我正在使用PDO调用以DROP TABLE IF EXISTS开头的存储过程。我随机地遇到PDOException 'SQLSTATE [42S02]:Base table or view not found:1146 Table' historygr.reached '不存在',更令人烦恼的是,它在几秒钟内就会从告诉我表不存在的异常转为抛出异常说该表已经存在,看起来是来自同一个连接。
我无法自己触发错误,但我会收到错误通知。
以下是产生错误的PHP代码段:
我无法自己触发错误,但我会收到错误通知。
以下是产生错误的PHP代码段:
$dbh = PDODB::getInstance();
$stmt = $dbh->query("CALL ListReached(".$this->item_id.")"); // <-- ERROR
$items = $stmt->fetchAll();
以下是MySQL存储过程定义:
DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `ListReached`( IN root INT)
BEGIN
DECLARE rows SMALLINT DEFAULT 0;
DROP TABLE IF EXISTS reached;
CREATE TABLE reached(
node_id INT PRIMARY KEY
) ENGINE=HEAP;
INSERT INTO reached VALUES (root);
SET rows = ROW_COUNT();
WHILE rows > 0 DO
INSERT IGNORE INTO reached
SELECT DISTINCT child_id
FROM related_item AS r
INNER JOIN reached AS p ON r.parent_id = p.node_id;
SET rows = ROW_COUNT();
INSERT IGNORE INTO reached
SELECT DISTINCT parent_id
FROM related_item AS r
INNER JOIN reached AS p ON r.child_id = p.node_id;
SET rows = rows + ROW_COUNT();
END WHILE;
DELETE FROM reached WHERE node_id = root;
SELECT * FROM reached;
DROP TABLE reached;
END