#39052 [Opn->Fbk]: pdo::query with "show slave/master status"

ID: 39052 Updated by: tony2001@php.net Reported By: xing at mac dot com -Status: Open +Status: Feedback Bug Type: PDO related Operating System: Linux PHP Version: 5.1.6 New Comment: Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. Previous Comments: ------------------------------------------------------------------------ [2006-10-05 20:09:14] xing at mac dot com Just tried the 5.2cvs snapshot. Same result. No change. ------------------------------------------------------------------------ [2006-10-05 19:36:29] tony2001@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.2-win32-latest.zip ------------------------------------------------------------------------ [2006-10-05 19:28:57] xing at mac dot com Description: ------------ PHP 5.1.6 Mysql 5.0.24a I have tested using PDO::query for both "show master status" and "show slave status" via tcp port and both bomb out with "SQLSTATE[HY000]: General error: 2030 This command is not supported in the prepared statement protocol yet" error. Bug #36572 was suppoed to fix this but I just tested with php 5.1.6 and the issue is still unresolved. Reproduce code: --------------- Execute "show slave status;" or "show master status" via pdo::query connected to server using tcp port. Expected result: ---------------- Result set. Actual result: -------------- SQLSTATE[HY000]: General error: 2030 This command is not supported in the prepared statement protocol yet ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=39052&edit=1