Java language extension v1.1.1 (Linux)

This release mitigates a delay in script execution you may experience when running sp_execute_external_script targeting the JavaExtension on SQL Server for Linux.

R language extension v1.2.0

Bug Fixes and Updates

• Remove dependency on cv2pdb.exe
• Fix the return type of rows number, changed from SQLUSMALLINT to SQLULEN
• Update version of R used in the pipeline to 4.0.5
• Update version of Rcpp and RInside used in the pipeline to be latest from the cran archive
• Bug fix for truncation of output for varchar(max), nvarchar(max), and varbinary(max)
• Added new tests for above fixes

.NET C# language extension v1.1.0

.NET runtime update to .NET 6 and following bug fixes and changes:

• Resolving the issue with empty input columns: Now, when adding columns, empty input columns will be handled properly.
• Enhancing the extension to automatically utilize the latest next major runtime if .NET 6 is not installed.

Python language extension v1.2.0

Bug fixes and updates

• Fix versions of Pandas and Numpy to the version shipped by SQL. (version 1.15.4)
• Update Boost version for Windows to 1.69.0.1457
• Update Python version for Windows to 3.10
• Update Boost version for Linux to 1.79.0
• Update Python version for Linux to 3.10
• Bug fix for truncation of output for varchar(max), nvarchar(max), and varbinary(max)
• Added tests for above fixes

Java language extension v1.1.0

• Java version update to Java 17.
  (Note: Starting from JDK 11, Java Runtime Environment (JRE) is no longer available as a separate installation option. Instead, the JDK includes everything that was previously included in the JRE, and additional development tools and libraries. Therefore, you can set JRE_HOME to be the same as the JDK directory if needed.)
• Restore scripts restore-packages.cmd for windows and restore-packages.sh for linux added to easier get JDK and packages.

.NET Core C# language extension v1.0.0

Initial release of .NET Core C# language extension. Works with SQL Server 2019 CU 3+

R language extension v1.1.0

Bug fixes and some underlying changes:

• Return sizeof(SQLCHAR) as the min columnSize for output character column
• Fix output char param for empty strings
• Add decimal/numeric input/output parameter support
• Add numeric column InputDataSet support for RExtension
• Fixing DateTime issues: allowing mix of NULL and non-NULL values for InputDataset, and setting maximum datetime/datetime2 precision to 6
• Interpret NULL binary/varbinary as row(0)
• Adding streaming and partitionBy support to RExtension
• Adding check for validity of utf8/16 characters
• Adding new tests

Python Language Extension v1.1.0

Bug fixes and some underlying changes

• Fix empty string nullptr output param
• Use PyUnicode_DecodeUTF8/16 instead of PyUnicode_FromKindAndData, which didn't work correctly for UTF-8
• Fix DateTime2 precision bug (originally had 0 precision after decimal point)
• Change how we deal with None in columns - if there are Nones the column is considered "string" type, unless python auto-converts to NaN or NaT.
• object type columns are always considered "string" columns, instead of searching down the column for the first item of non-None and assigning the whole column to that type.
• Fix and remove vector<>* construction for char/binary, which leaks memory.
• Add streaming and partitionby support and tests for same
• Modify the pip temp location in external library to prevent instance name $NAME issues
• Change linux version to so.1.1 instead of so.1.0

R language extension v1.0.0

Initial release of R language extension. Works with SQL Server 2019 CU 3+

Python language extension v1.0.0

Initial release of Python language extension. Works with SQL Server 2019 CU 3+