BUG FIXES:

N/A

NEW FEATURES:

1. SpyProcedure has a new optional parameter, @CallOriginal
2. SpyProcedure provides the variable @SpyProcedureOriginalObjectName within the CommandToExecute
3. NoTransaction test annotation –@tSQLt:NoTransaction
   This annotation causes the test to be executed outside of a transaction. The @CleanUpProcedureName procedure is executed after the test completes.
4. UndoTestDoubles, useful when test double procedures like tSQLt.FakeTable are executed outside of a transaction
5. FakeFunction allows FakeDataSource to be a “VALUES” clause

MISCELLANEOUS:

1. Reduced the complexity of building and testing tSQLt
2. Removed dependency on Private_NullCellTable table
3. Installation of tSQLt can handle more edge cases
4. Standardized error messages
5. For tSQLt contributors: New build target ‘tSQLtOnly’, which skips Facade validation steps

BUG FIXES:

• Removed unexpected facade objects (aka ufos) from tSQLt dacpacs.

NEW FEATURES:

N/A

MISCELLANEOUS:

N/A

BUG FIXES:

N/A

NEW FEATURES:

1. tSQLt can now be installed using DACPACs as well as the original tSQLt.class.sql script. Note: Unlike the original tSQLt.class.sql script, DACPACs are SQL Server version specific.
2. tSQLt.FriendlySQLServerVersion function reports the SQL Server Version as a string with commonly used moniker e.g. 2008R2 or 2019.
3. tSQLt is now certified for SQL Server on Linux.

MISCELLANEOUS:

1. Created GitHub Action for building and testing tSQLt on MSSQL 2017 and 2019 using Redgate Spawn.
2. Refactored Azure DevOps Pipeline to use more powerful VMs and azcli to create the SQLVM with a bicep file.
3. Migrated parts of the tSQLt build from ant to PowerShell.
4. Prototyped using AKS (Azure Kubernetes Service) to host MSSQL 2014, 2016, 2017, and 2019.
5. Prototyped Facade dacpacs for use in Visual Studio when developing tests with tSQLt. Ultimately we chose a full tSQLt dacpac for this work, but continue to retain the original Facade code and tests.