Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
None
-
None
Description
Support COM_MULTI protocol, and implement server prepare statement PREPARE+EXECUTE in one call if supported
Support COM_MULTI protocol, and implement server prepare statement PREPARE+EXECUTE in one call if supported
Prepare cannot work on all query actually : Query like "select TMP.field1 from (select ? `field1` from dual) TMP" that use temporary table cannot be prepared (see
MDEV-5535).Actual implementation of PreparedStatement (using "Connection.preparedStatement(String sql)" ) fall back ClientPreparedStatement when prepare cannot be done.
Since "PREPARE" execution will be defered using COM_MULTI to the first execution to avoid one round-trip to server, driver will not be able to know if PREPARE can be done or not (or parsing query, but that will take to much additional time for each query).
COM_MULTI will wait
MDEV-5535so all queries can be prepared.