Binary values output in AssertEqualsTable #216

Activity

1. ovcharenko-di commented on Jul 16, 2025

   

   ovcharenko-di

   on Jul 16, 2025

   Author

   More actions

   DeepSeek gave me a workaround:

   In the test, after populating expected and actual tables, create views in which binary values are converted to the desired format. In AssertEqualsTable, replace original tables with views.

   -- above this line goes your test and then:
   
   EXEC(
     'CREATE VIEW TableActual_Converted AS
        SELECT 
           a,
           CONVERT(varchar(32), b, 2) AS b_hex, -- here comes the conversion
           c
       FROM TableActual;'
   );
   
   EXEC(
     'CREATE VIEW TableExpected_Converted AS
        SELECT 
           a,
           CONVERT(varchar(32), b, 2) AS b_hex, -- here comes the conversion
           c
       FROM TableExpected;'
   );
   
   EXEC tSQLt.AssertEqualsTable 'TableExpected_Converted ',  'TableActual_Converted ';

   It clutters the test a little bit, but works just fine.
   I think the issue can be closed if there is no better solution in place. If there is - please, let me know.