Description:
------------
Using MySQL 4.1.11

The pdo_mysql driver appears to attempt to prepare every query 
that it processes. Unfortunately only certain query statement 
types can be prepared in the current version of MySQL. See: 
http://bugs.mysql.com/bug.php?id=6415

This is causing a failure in the example code posted.

Perhaps the pdo_mysql driver could look at the type of 
statement it is processing and act accordingly and only 
prepare statements that allow it or perhaps a new option or 
method could be added so that it could be explicitly stated 
that the query should not be prepared.

Reproduce code:
---------------
<?php
$db = new PDO("mysql:dbname=test;host=127.0.0.1", 'root', '');

$db->query('DROP TABLE IF EXISTS pdo_test');
$db->query('CREATE TABLE pdo_test (field1 int(11) default NULL, field2 varchar(20) default NULL)');

$query_that_should_not_fail = "SHOW CREATE TABLE pdo_test";

$result = $db->query($query_that_should_not_fail);
      
if (!$result) {
   $errorInfo = $db->errorInfo();
   print_r($errorInfo);
   exit;
}

$row = $result->fetch(PDO_FETCH_ASSOC);
echo count($row);
?>

Expected result:
----------------
2

Actual result:
--------------
Array
(
    [0] => HY000
    [1] => 1295
    [2] => This command is not supported in the prepared 
statement protocol yet
)