微軟 SQL Server PHP 驅(qū)動(dòng) 5.3.0 發(fā)布了，該驅(qū)動(dòng)程序允許從 Linux、Windows 和 macOS 上的 PHP 7.0-7.2 應(yīng)用程序訪問(wèn) SQL Server、Azure SQL 數(shù)據(jù)庫(kù)、Azure SQL 托管實(shí)例和 Azure SQL DW。

此次更新內(nèi)容如下：

Added

• Added support for Azure Key Vault for Always Encrypted functionality. Always Encrypted functionality is supported on Linux and macOS through Azure Key Vault

• Added support for connection resiliency on Linux and macOS (requires version 17.2 or higher of the ODBC driver)

• Added support for macOS High Sierra (requires version 17 or higher of the ODBC driver)

• Added support for Ubuntu 18.04 (requires version 17.2 or higher of the ODBC driver)

Fixed

• Issue #577 - Idle Connection Resiliency doesn't work with Column Encryption enabled connections (fixed in MS ODBC Driver 17.1)

• Issue #678 - Idle Connection Resiliency doesn't work with Connection Pooling (fixed in MS ODBC Driver 17.1)

• Issue #699 - Binding output parameters fails when the query in the stored procedure returns no data. The test case has been added to the test lab.

• Issue #705 - Always Encrypted - Retrieving a negative decimal value (edge case) as output parameter causes truncation

• Issue #706 - Always Encrypted - Cannot insert double with precision and scale (38, 38)

• Issue #707 - Always Encrypted - Fetching decimals / numerics as output parameters bound to PDO::PARAM_BOOL or PDO::PARAM_INT returns floats, not integers

• Issue #735 - Extended the buffer size for PDO::lastInsertId so that data types other than integers can be supported

• Pull Request #759 - Removed the limitation of binding a binary as inout param as PDO::PARAM_STR with SQLSRV_ENCODING_BINARY

• Pull Request #775 - Fixed the truncation problem for output params with SQL types specified as SQLSRV_SQLTYPE_DECIMAL or SQLSRV_SQLTYPE_NUMERIC

Limitations

• No support for inout / output params when using sql_variant type

• In Linux and macOS, setlocale() only takes effect if it is invoked before the first connection. Attempting to set the locale after connecting will not work

• Always Encrypted requires MS ODBC Driver 17+

• Only Windows Certificate Store and Azure Key Vault are supported. Custom Keystores are not supported

• Issue #716 - With Always Encrypted enabled, named parameters in subqueries are not supported

• Always Encrypted limitations

Known Issues

• Connection pooling on Linux or macOS is not recommended with unixODBC < 2.3.6

• When pooling is enabled in Linux or macOS

• unixODBC <= 2.3.4 (Linux and macOS) might not return proper diagnostic information, such as error messages, warnings and informative messages

• due to this unixODBC bug, fetch large data (such as xml, binary) as streams as a workaround. See the examples here

• With ColumnEncryption enabled, calling stored procedures with XML parameters does not work (Issue #674)

發(fā)布公告

下載地址：

•  Source code (zip)

•  Source code (tar.gz)

標(biāo)簽： linux 數(shù)據(jù)庫(kù)

版權(quán)申明：本站文章部分自網(wǎng)絡(luò)，如有侵權(quán)，請(qǐng)聯(lián)系：west999com@outlook.com
特別注意：本站所有轉(zhuǎn)載文章言論不代表本站觀點(diǎn)！
本站所提供的圖片等素材，版權(quán)歸原作者所有，如需使用，請(qǐng)與原作者聯(lián)系。