问在useServerPrepStmts连接器/J中将cachePrepStmts和MySQL设置为true时，“执行”之前的冗余“重置stmt”

EN

PreparedStatement ps = null;
String url = "jdbc:mysql://10.86.49.16:3306/test?useServerPrepStmts=true&cachePrepStmts=true";
...
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url, user, password);
String sql = "select * from test where id=?";
for (int i = 1; i <= 3; i++) {
    ps = conn.prepareStatement(sql);
    ps.setInt(1, i);
    ps.execute();
    ps.close();
}

6 Prepare   select * from test where id=?
6 Execute   select * from test where id=1
6 Close stmt
6 Prepare   select * from test where id=?
6 Execute   select * from test where id=2
6 Close stmt
6 Prepare   select * from test where id=?
6 Execute   select * from test where id=3
6 Close stmt

7 Prepare   select * from test where id=?
7 Execute   select * from test where id=1
7 Reset stmt
7 Execute   select * from test where id=2
7 Reset stmt
7 Execute   select * from test where id=3

com.mysql.cj.ServerPreparedQuery#clearParameters

/**
 * @param clearServerParameters
 *            flag indicating whether we need an additional clean up
 */
public void clearParameters(boolean clearServerParameters) {
    boolean hadLongData = false;
    if (this.queryBindings != null) {
        hadLongData = this.queryBindings.clearBindValues();
        this.queryBindings.setLongParameterSwitchDetected(clearServerParameters && hadLongData ? false : true);
    }
    ...
}

com.mysql.cj.ServerPreparedQuery#prepareExecutePacket

public NativePacketPayload prepareExecutePacket() {
    ServerPreparedQueryBindValue[] parameterBindings = this.que
    if (this.queryBindings.isLongParameterSwitchDetected()) {
        ...
        // Okay, we've got all "newly"-bound streams, so reset server-side state to clear out previous bindings
        serverResetStatement();
    }
    ...
}