Here follows a list of the currently known problems with prepared statements:
DATETIMEdo not support parts of seconds (for example, from
When converting an integer to string,
ZEROFILLis 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 support multi-statements (that is, multiple statements within a single string separated by
The capabilities of prepared
CALLstatements are described in Section 3.6.5, “Prepared CALL Statement Support”.