Documentation Home
MySQL 8.4 C API Developer Guide
Download this Manual
PDF (US Ltr) - 1.4Mb
PDF (A4) - 1.4Mb


3.6.6 Prepared Statement Problems

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 preparedCALL statements are described inSection 3.6.5, “Prepared CALL Statement Support”.