Here follows a list of the currently known problems with prepared statements:
When converting an integer to string,
ZEROFILL is honored with prepared
statements in some cases where the MySQL server does not print
the leading zeros. (For example, with
When converting a floating-point number to a string in the client, the rightmost digits of the converted value may differ slightly from those of the original value.
Prepared statements do not use the query cache, even in cases where a query does not contain any placeholders. See Section 126.96.36.199, “How the Query Cache Operates”.
Prepared statements do not support multi-statements (that is,
multiple statements within a single string separated by
In MySQL 5.0, prepared
CALL statements cannot invoke
stored procedures that return result sets because prepared
statements do not support multiple result sets. Nor can the
calling application access a stored procedure's
when the procedure returns. These capabilities are supported
beginning with MySQL 5.5.
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices