C API 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 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
CALL
statements are described in , "C API Support for PreparedCALL
Statements".