(mysql.info) c-api-prepared-statement-problems

Info Catalog

(mysql.info) c-api-prepared-statement-functions

(mysql.info) c

(mysql.info) c-api-multiple-queries

 
 22.2.8 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 doesn't
      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 use the Query Cache, even in cases
      where a query does not contain any placeholders_. See 
      query-cache-how.
 

Info Catalog

(mysql.info) c-api-prepared-statement-functions

(mysql.info) c

(mysql.info) c-api-multiple-queries