system.errors contains errors about UNKNOWN_IDENTIFIER but result of query correctly returns

[Slach]

Describe what's wrong

https://fiddle.clickhouse.com/c84cacb1-52da-48e2-9847-b9c825822adf

SELECT *
FROM
(
    SELECT *
    FROM system.numbers
    LIMIT 2
) AS n1
INNER JOIN
(
    SELECT *
    FROM system.numbers
    LIMIT 2
) AS n2 ON n1.number = n2.number
FORMAT Vertical;

return good result

but

SELECT * FROM system.errors FORMAT Vertical;

Row 1:
──────
name:               UNKNOWN_IDENTIFIER
code:               47
value:              1
last_error_time:    2023-06-27 14:14:10
last_error_message: Missing columns: 'n2.number' 'number' while processing query: 'number = n2.number', required columns: 'number' 'n2.number' 'number' 'n2.number'
last_error_trace:   [238324885,142758764,333694553,333731958,334242974,333710837,330390322,330372317,331033798,331024595,330082110,334346583,334332846,348996900,349085817,398655028,398659665,400219399,400209724,140092740037443,140092740631476]
remote:             0

Doesn't reproduce with analyzer

https://fiddle.clickhouse.com/3460c127-cf5b-451d-9b17-1b3948e9cc99

[tavplubix]

Introduced in #25894, related to tryEvaluateConstCondition

[tavplubix]

Another report: #54296