MySQL 8.0 C API Developer Guide
Here follows a list of the currently known problems with prepared statements:
TIME,
TIMESTAMP, and
DATETIME do not support parts
of seconds (for example, from
DATE_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, with
MIN().
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 3.6.5, “Prepared CALL Statement Support”.