Typo prevents from publishing to Case sensitive server

[andreassundstrom]

In the procedure tSQLt.Private_NoTransactionHandleTable there is a typo preventing us from publishing tSQLt to case sensitive server. Should be @cmd.

tSQLt/Source/tSQLt.Private_NoTransactionHandleTable.ssp.sql

Line 25 in c63e2d2

EXEC (@Cmd);

Variable declaration:

  DECLARE @cmd NVARCHAR(MAX);

I can submit PR for fix if you want, but I'm not very faimiliar with the project.

[mbt1]

Marking this as a bug. We'll work on getting a case-sensitive server into the build pipeline. (To clarify, all build databases are already case sensitive. That SQL Server shows different behavior when the server collation is case sensitive I was not aware of.)

[lizbaron]

Fixed and tested. Merged to main. Will publish shortly.

[andreassundstrom]

@lizbaron Will this be available from the tSQLt website, or do you scheduele releases?

[mbt1]

The release (V1.0.8083.3529) is now available on tSQLt.org. Please go to the download page to get it.

[andreassundstrom]

Wow amazing, awesome work. This will really help our company implementing sql server unit testing in our Swedish health care environment. Thank you so much for quick response!