BUG #18307: system columns does not support using join - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      18307
Logged by:          RekGRpth
Email address:      rekgrpth@gmail.com
PostgreSQL version: 16.1
Operating system:   docker alpine
Description:

create table t(i int);

explain (costs off) select * from t join t tt on t.xmin = tt.xmin;
           QUERY PLAN            
---------------------------------
 Hash Join
   Hash Cond: (t.xmin = tt.xmin)
   ->  Seq Scan on t
   ->  Hash
         ->  Seq Scan on t tt
(5 rows)

explain (costs off) select * from t join t tt using (xmin);
ERROR:  column "xmin" specified in USING clause does not exist in left table