[BUG] report.trace_flag_changes fails with bit-to-nvarchar conversion error #1635

docker pull mcr.microsoft.com/mssql/server:2022-latest

docker run -e ACCEPT_EULA=Y -e MSSQL_SA_PASSWORD='HopeThisIsGoodEnough123!' \
  --name sqltest -p 1433:1433 -d mcr.microsoft.com/mssql/server:2022-latest

# brief pause for sql service to start up
sleep 15

docker exec -it sqltest /opt/mssql-tools18/bin/sqlcmd \
  -S localhost -U sa -P 'HopeThisIsGoodEnough123!' -C -Q \
  "CREATE TABLE tempdb.dbo.history (
     collection_time datetime2,
     trace_flag      int,
     status          bit,
     is_global       bit,
     is_session      bit
   );
   /* Initial capture: TF 1222 off */
   INSERT tempdb.dbo.history VALUES ('2026-07-24 00:00:00', 1222, 0, 1, 0);
   /* Second capture: TF 1222 toggled on */
   INSERT tempdb.dbo.history VALUES ('2026-07-24 01:00:00', 1222, 1, 1, 0);
   SELECT trace_flag, status, is_global, collection_time FROM tempdb.dbo.history;"

docker exec -it sqltest /opt/mssql-tools18/bin/sqlcmd \
  -S localhost -U sa -P 'HopeThisIsGoodEnough123!' -C -Q \
  "WITH ranked AS (
     SELECT
       status,
       is_global,
       is_session,
       trace_flag,
       previous_status =
         LAG(status, 1) OVER (PARTITION BY trace_flag, is_global ORDER BY collection_time),
       change_number   =
         ROW_NUMBER()  OVER (PARTITION BY trace_flag, is_global ORDER BY collection_time)
     FROM tempdb.dbo.history
   )
   SELECT
     trace_flag,
     change_description =
       CASE
         WHEN previous_status = N'OFF' AND status = N'ON'
         THEN N'Trace flag ' + CONVERT(nvarchar(10), trace_flag) + N' ENABLED'
         WHEN previous_status = N'ON' AND status = N'OFF'
         THEN N'Trace flag ' + CONVERT(nvarchar(10), trace_flag) + N' DISABLED'
         ELSE N'Status unchanged'
       END
   FROM ranked
   WHERE change_number > 1;"

docker exec -it sqltest /opt/mssql-tools18/bin/sqlcmd \
  -S localhost -U sa -P 'HopeThisIsGoodEnough123!' -C -Q \
  "WITH ranked AS (
     SELECT
       status,
       is_global,
       is_session,
       trace_flag,
       previous_status =
         LAG(status, 1) OVER (PARTITION BY trace_flag, is_global ORDER BY collection_time),
       change_number   =
         ROW_NUMBER()  OVER (PARTITION BY trace_flag, is_global ORDER BY collection_time)
     FROM tempdb.dbo.history
   )
   SELECT
     trace_flag,
     change_description =
       CASE
         WHEN previous_status = 0 AND status = 1
         THEN N'Trace flag ' + CONVERT(nvarchar(10), trace_flag) + N' ENABLED'
         WHEN previous_status = 1 AND status = 0
         THEN N'Trace flag ' + CONVERT(nvarchar(10), trace_flag) + N' DISABLED'
         ELSE N'Status unchanged'
       END
   FROM ranked
   WHERE change_number > 1;"

docker rm -f sqltest