Here follows a list of the currently known problems with prepared statements:
TIME
,TIMESTAMP
, andDATETIME
do not support parts of seconds (for example, fromDATE_FORMAT()
).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, withMIN(
).number-with-zerofill
)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
;
characters).The capabilities of prepared
CALL
statements are described in Section 28.7.25, “C API Prepared CALL Statement Support”.