C API Prepared Statement Problems
Here follows a list of the currently known problems with prepared statements:
TIME,TIMESTAMP, andDATETIMEdo not support parts of seconds (for example, fromDATE_FORMAT()).- When converting an integer to string,
ZEROFILLis honored with prepared statements in some cases where the MariaDB server doesn't 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 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
CALLstatements are described in , "C API Support for PreparedCALLStatements".