MySQL Connector/ODBC Release Notes

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

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);    
    
  • 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.

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)