This change fixes integration test issues that resulted from running tests against SQL Server 2022 with Python 3.10.5.
These changes confirm compatibility with SQL Server 2022 (CTP2.0+)
What is this change?
Updated SQLMLUtils Python package version to 1.2.0
Added support for special characters in connection string passwords.
Updated package dependencies used in integration tests where the old versions from a few years back caused failures.
Integration tests utilizing the test script (exec_script_out_param.py) now succeed as now properly sets the OutputDataSet.
Integration test (test_install_bad_package_badzipfile) now skipped as it is very long running due to PIP package resolution operation.
Added addition comments in integration test (test_scope) to clarify operations related to scope that will fail unless the test database is further configured to meet permissions requirements.
This test specifically requires SQL Logins/ Database accounts to be configured with permissions:
CREATE EXTERNAL LIBRARY - owner_name : permissions that allow "Execute As" or "Impersonate" of a dbo user to install packages for all users via the public scope. Non-dbo users cannot install packages to the public scope.
How was this tested?
[x] Ran and passed integration tests for Python on SQL MI, SQL Server 2019, and SQL Server 2022 (CTP2.0+)
Why this change?
What is this change?
dbouser to install packages for all users via the public scope. Non-dbousers cannot install packages to the public scope.How was this tested?