"compile SQL failed" does not respect tidb_redact_log

[lance6716]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

mysql> set @@tidb_redact_log = 1;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from test.test where a = 1;
ERROR 1146 (42S02): Table 'test.test' doesn't exist

$ cat /Users/lance6716/.tiup/data/TXFmwk7/tidb-0/tidb.log | grep "a = 1"
[2023/03/01 20:09:51.214 +08:00] [WARN] [session.go:2204] ["compile SQL failed"] [conn=2897243925515338135] [error="[schema:1146]Table 'test.test' doesn't exist"] [SQL="select * from test.test where a = 1"]

2. What did you expect to see? (Required)

3. What did you see instead (Required)

4. What is your TiDB version? (Required)