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”.