Bug #118234 A potential bugs in Mysql Connector/J

• Submitted: 21 May 3:59
• Modified: 21 May 7:03
• Reporter: 策 吕
• Status: Verified
• Category: Connector / J
• Severity: S3 (Non-critical)
• Version: 9.0.0, 9.3.0
• OS: Any
• CPU Architecture: Any

[21 May 3:59] 策 吕

Description:
The program runs normally when allowMultiQueries=true is used, and throws an exception when allowMultiQueries=true is not used or when allowMultiQueries=false is used.Theoretically adding &allowMultiQueries configuration or not should not affect the outcome of the program.

How to repeat:
import java.sql.*;

public class test {
    public static void main(String[] args) throws SQLException {
        String url1 = "jdbc:mysql://localhost:3306/test?user=root&password=1234";
        Connection con = null;
        Statement stmt = null;
        con = DriverManager.getConnection(url1);
        stmt = con.createStatement();

        stmt.executeUpdate("DROP TABLE IF EXISTS table0;");
        stmt.executeUpdate("CREATE TABLE table0(id INT PRIMARY KEY);");

        stmt.addBatch("DESC table0;");

        stmt.executeBatch();

    }

}

[21 May 7:03] MySQL Verification Team

Hello 策 吕,

Thank you for the report and feedback.
Verified as described.

regards,
Umesh