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

ID: 39052 User updated by: xing at mac dot com Reported By: xing at mac dot com -Status: Feedback +Status: Open Bug Type: PDO related Operating System: Linux PHP Version: 5.1.6 New Comment: <?php $link = new PDO("mysql:host=127.0.0.1;port=11113;","user","password"); $link->setAttribute (PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $link->setAttribute (PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, TRUE); $link->query("SET NAMES 'utf8'"); try { $link->query("show slave status"); echo "good"; } catch (PDOException $e) { echo "<pre>"; print_r($e); echo "</pre>"; } ?> Previous Comments: ------------------------------------------------------------------------ [2006-10-05 20:21:38] tony2001@php.net 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. ------------------------------------------------------------------------ [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