#34499 [Bgs]: pdo::exec fails when executing sequential 'OPTIMIZE TABLE' queries

ID: 34499 User updated by: maesa at email dot it Reported By: maesa at email dot it Status: Bogus Bug Type: PDO related Operating System: Windows XP SP2 PHP Version: 5.1.0RC1 Assigned To: wez New Comment: I'm sorry, in the documentation for the exec function i've only read this about returning results 'PDO::exec() does not return results from a SELECT statement. For a SELECT statement that you only need to issue once during your program, consider issuing PDO::query(). For a statement that you need to issue multiple times, prepare a PDOStatement object with PDO::prepare() and issue the statement with PDOStatement::execute().' and so i thought that for other queries different from SELECT the pdo::exec should have to work sorry Previous Comments: ------------------------------------------------------------------------ [2005-09-14 18:50:24] iliaa@php.net Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.php.net/manual/ and the instructions on how to report a bug at http://bugs.php.net/how-to-report.php Error reporting issue was addressed, but for optimize query you really should be using the query() and not the exec() method. ------------------------------------------------------------------------ [2005-09-14 16:58:41] wez@php.net OPTIMIZE TABLE is a query that returns rows. You should use PDO::query() instead. I'll see about handling this user error more gracefully. ------------------------------------------------------------------------ [2005-09-14 13:47:29] sniper@php.net Assigned to the maintainer ------------------------------------------------------------------------ [2005-09-14 13:25:13] maesa at email dot it I've installed the snapshot package for windows and got it running but the problem persist... ------------------------------------------------------------------------ [2005-09-14 11:52:29] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip Several fixes were committed since RC1 was released.. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/34499 -- Edit this bug report at http://bugs.php.net/?id=34499&edit=1