#36572 [Opn->Csd]: Can't execute "show master status"

ID: 36572 Updated by: iliaa@php.net Reported By: nerve at gmx dot net -Status: Open +Status: Closed Bug Type: PDO related Operating System: Gentoo Linux PHP Version: 5.1.2 New Comment: This bug has been fixed in CVS. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. Thank you for the report, and for helping us make PHP better. Previous Comments: ------------------------------------------------------------------------ [2006-03-01 14:59:53] nerve at gmx dot net Description: ------------ The problem is the same problem as the bug with the nuber 36347, but the solution is for this statemnts not practicable.. What to do with the statement 'show master status' or 'show slave status' ? This statements return a result set, and im interessed in the result set. You actually can't use PDO::query() with this statements: HY000:2030:This command is not supported in the prepared statement protocol yet Using of PDO::exec() isn't a option, i want the result set! Please help me ! Releases: php 5.1.2 on gentoo linux with mysql 5.0.18 Daniel Heule Reproduce code: --------------- try to execute the MySql statement 'show master status' with pdo ... Expected result: ---------------- the result set of this query .... Actual result: -------------- an sql error ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=36572&edit=1