Changes in MySQL Connector/ODBC 8.0.22 (2020-10-19, General Availability)

• Functionality Added or Changed

• Bugs Fixed

Functionality Added or Changed

• For enhanced security of the existing ENABLE_LOCAL_INFILE connection string option, the new ENABLE_LOCAL_DIR option allows restricting LOCAL data loading to files located in this designated directory. Example usage:

  // LOAD LOCAL DATA DIR FROM /tmp
      SQLRETURN rc =
      SQLDriverConnect(
        hdbc1,NULL,
        "DSN=myDSN;UID=root;PWD=pwd;DATABASE=test;LOAD_DATA_LOCAL_DIR=/tmp",
        SQL_NTS, conn_out, sizeof(conn_out), &conn_out_len,
        SQL_DRIVER_NOPROMPT);
  
  // LOAD LOCAL DATA FROM EVERYWHERE
      SQLRETURN rc =
      SQLDriverConnect(
        hdbc1,NULL,
        "DSN=myDSN;UID=root;PWD=pwd;DATABASE=test;ENABLE_LOCAL_INFILE=1;",
        SQL_NTS, conn_out, sizeof(conn_out), &conn_out_len,
        SQL_DRIVER_NOPROMPT);

  (WL #13883)

• Connections made using the MySQL Enterprise Edition SASL LDAP authentication plugin now are supported on Windows and Linux, but not on macOS. Connector/ODBC implements the SCRAM-SHA-1 authentication method of the SASL authentication protocol. (WL #14114)

Bugs Fixed

• Fixed an issue where a parameterized query could cause memory corruption. (Bug #31678876, Bug #100329)

• Under some circumstances when using server-side prepared statements, the first row of a multi-row match was not returned with the result; while it was returned when using client-side prepared statements instead. (Bug #31373948, Bug #95423)

• Inserting binary data (BLOBs) using SQLPutData() would report a syntax error. (Bug #31349038)