Unit testing is not about running an SP and reading the results. It is all about mocking, stubbing and faking and running in CI. That's why I do not use Microsoft's solution.
But now it appeared that the solution I use is not compatible with Columnstore indexes. That is sad to me.