Unexpected SELECT * with Join

[zhang2014]

Steps to reproduce the behavior

SELECT * FROM (SELECT 1 AS id, 2 AS value) ANY INNER JOIN (SELECT 1 AS id, 2 AS values) USING id;

Expected Result

1 2 2

Actual Result

1 2

[alesapin]

Yes, this is weird, but this behaviour is documented and works according to documentation:

All columns that are not needed for the JOIN are deleted from the subquery.

subquery here is right part of join. Currently you have to specify all required columns.

[zhang2014]

I am currently trying to fix this problem, but it is not compatible with the version.

[TimonKK]

It is same problem