Rails filter_parameters is not respected when logging queries.

[b-nik]

It seems like the config option Rails.application.config.filter_parameters is not respected when logging queries - all queries are logged with the parameters unfiltered.

(Tested on Rails 8.0 with activerecord-sqlserver-adapter 8.0.7)

My current workaround for production is to disabled logging of queries completely.

[aidanharan]

Could you test the issue with SQLite to see if it is a Rails issue rather than an MSSQL adapter issue?

If it is an adapter issue, could you provide steps to recreate the issue or a bug script? https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/wiki/How-to-report-a-bug

[b-nik]

I know it works with the postgres adapter, do you think I should check with SQLite too?

As for a bug script, I have no idea how to set it up so that I can set the configuration option.

The reproduction is easy, add some sensitive field names to Rails.application.config.filter_parameters and then run a create or an update statement on a model. Here's what the postgres adapter logs:

> admin.update(password: "1234123124213124")

  TRANSACTION (0.2ms)  BEGIN
  Admin Update (0.8ms)  UPDATE "admins" SET
 "encrypted_password" = $1, "updated_at" = $2 WHERE "admins"."id" = $3 
 [["encrypted_password", "[FILTERED]"], ["updated_at", "2025-06-25 11:43:06.254490"], ["id", 2]]
  TRANSACTION (15.3ms)  COMMIT

However, here's what the sqlserver adapter logs:

> admin.update(password: "1234123124213124")

  TRANSACTION (0.6ms)  BEGIN TRANSACTION
  Admin Update (4.5ms)  UPDATE [admins] SET
[encrypted_password] = N'$2a$12$2ASFqqhQk1imqZlIjlV5XuhEKeXxeIPZBbKW8mBrd2aK6EgtM54m2',
 [updated_at] = '06-25-2025 11:46:06.325978' WHERE [admins].[id] = 5; SELECT @@ROWCOUNT AS AffectedRows
  TRANSACTION (18.4ms)  COMMIT TRANSACTION

If I had to guess, maybe Rails is applying the filtering logic to parameterized queries - and sqlserver doesn't generate such queries.