tSQLt.AssertEqualsTable is not showing whole value for DATETIME2(7) columns

[Radamonas]

We were running tests where comparison is made between two tables which store data about date time in DATETIME2(7). It appeared, that then tSQLt.AssertEqualsTable stored procedure is used the output on the mismatches is not presenting all details about, so the "Unexpected/missing resultset rows!" table showing that there are some rows which don't match, but when looking in to output results it is not so obvious what is the difference because values are rounded to seconds while the purpose of the test was to check precision of nanoseconds.

The output example:

m	id	BoundaryToCreate	BaseType	Real values
<-	4	19/02/2000 23:59:59	datetime2	19/02/2000 23.59.59.99999
->	4	19/02/2000 23:59:59	datetime2	19/02/2000 23.59.59.9999999

[TheSQLGuru]

I don't have time to dig into it, but my guess would be the issue lies in one of these:

tSQLt.Private_CreateResultTableForCompareTables

tSQLt.Private::TableToString

[mbt1]

Thanks, Radamonas for reporting this. TheSQLGuru is likely correct with his assumption. I will take a look.