MySQL 5.6 C API Developer Guide  /  C API Prepared Statement Problems

Chapter 19 C API Prepared Statement Problems

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 use the query cache under the conditions described in How the Query Cache Operates.

  • 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 Chapter 18, C API Prepared CALL Statement Support.