MySQL程序没有返回第一行

Question

Does the execute() statement perform an implicit fetch()? PHP does not show the first row of the returned result in the following simple code:

$query = 'CALL `MySP`()';

$stmt = $db->prepare($query);
$stmt->execute();        
$rows = $stmt->fetchAll();
return $rows;

$rows contains only 3 rows instead of actual 4; the first one is missing. The same SP returns 4 rows when run directly.

Edit

No luck yet after I tried everything suggested in the comments. Additionally I found that PDO can fail for very simple SPs too. Here is an example:

CREATE PROCEDURE `Test`()
BEGIN
  SELECT 123 as Col1
  UNION ALL
  SELECT 456 as Col1;
END

Try calling this proc from PHP. PDO throws a "no clue" exception when you try to fetch:

PDO error: “ SQLSTATE[HY000]: General error ” ...

Answer 1

Finally!

This is so very stupid. Not sure who to blame. It ruined my entire night and turned out to be just the fact that I was using Count as alias for one of my columns. PDO somehow doesn't like this and as a result removes the first row of the result set. I'm pretty sure there would be a logical explanation of this unexpected behavior, since MySQL doesn't mind this alias.

Anyway changing Count to RowCount or anything else fixed the behavior.

Hope this helps someone down the road.

Thank you everyone who worked with me on this one.