planner/executor: internal missing-column error with JOIN ... USING + qualified column predicate

[hawkingrei]

Bug Report

1. Minimal reproduce step (Required)

Artifact: https://storage.googleapis.com/pingcap_bazel_cache/shiro/019c5558-d0de-704e-839c-7bcc503cfebf/case.tar.zst
Plan replayer: https://storage.googleapis.com/pingcap_bazel_cache/shiro/019c5558-d0de-704e-839c-7bcc503cfebf/plan_replayer.zip

Apply schema

DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t3;

CREATE TABLE t1 (
  id BIGINT NOT NULL,
  k0 BIGINT NOT NULL,
  d0 DATE NOT NULL,
  d1 FLOAT NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE t3 (
  id BIGINT NOT NULL,
  k2 VARCHAR(64) NOT NULL,
  k0 BIGINT NOT NULL,
  d0 DOUBLE NOT NULL,
  d1 DATE NOT NULL,
  PRIMARY KEY (id)
);

Load data

INSERT INTO t1 (id, k0, d0, d1) VALUES
  (10, 93, '2024-04-14', 14.19);

INSERT INTO t3 (id, k2, k0, d0, d1) VALUES
  (10, 's356', 749, 89.26, '2024-04-29');

Run the query:

SELECT
  id AS t0_id
FROM t1
JOIN t3 USING (id)
WHERE (
  (
    (t3.d1 = '2024-04-29')
    AND (t3.id = 10)
  )
  AND (t1.k0 = 93)
)
AND (
  t3.k0 = ALL (
    SELECT t3.k0 AS c0
    FROM t3
    WHERE t3.k0 = 749
  )
);

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

The query should not fail with internal schema binding failure during execution/planning.

3. What did you see instead (Required)

Error 1105 (HY000): Can't find column shiro_fuzz_r12.t3.id in schema Column: [shiro_fuzz_r12.t3.k0] PKOrUK: [] NullableUK: []

4. What is your TiDB version? (Required)

Release Version: v9.0.0-beta.2.pre-1235-g365184d563
Edition: Community
Git Commit Hash: 365184d56314e6844ae5240287ab3a69cb627fa3
Git Branch: HEAD
UTC Build Time: 2026-02-12 09:27:22
GoVersion: go1.25.6
Race Enabled: false
Check Table Before Drop: false
Store: tikv
Kernel Type: Classic

Additional context

• Oracle: PQS
• Error classification from fuzz runner: pqs:missing_column / tidb:schema_column_missing
• Case ID: 019c5558-d0de-704e-839c-7bcc503cfebf

[tiara-tidb-ai-bot-public]

🔗 Related Issues

I found some similar issues that might be related, please check them at first, if you think this issue is similar to them, please close this issue.

1. ✨ Similar DP Join reorder on the graph that is not totally connect may fail to execute #63353 (match via body)

2. ✨ Similar planner: fix join reorder schema mismatch causing Can't find column #66106 (match via body)

3. ✨ Similar planner: can't find column error for a nested join query #65454 (match via body)

4. ✨ Similar Tiflash mpp join generate physical plan failed in resolve index phase #52828 (match via body)

5. ✨ Similar Unexpected error Can't find column Column#3 in schema Column when construct prepared statement for EXPLAIN #63898 (match via body)

6. ✨ Similar Can't find column when to analyze virtual column with vector #62682 (match via body)

7. 📝 Related Selection on merge join could not find column #32160 (match via body)

8. 📝 Related Planner reports missing _tidb_rowid in schema for a valid query after NULL is added to an IN list #65791 (match via body)

9. 📝 Related Can't find column mpp_complex_sql1000.d.col_decimal_not_null in schema Column #66399 (match via body)

10. 📝 Related planner, executor: Correlated subqueries error when using indexing columns #13758 (match via title)

---

This comment was automatically generated based on semantic similarity analysis.