v.19.3Improvements
SELECT * FROM a JOIN B USING A, B Now Return a and B Columns Only from the Left Table
SELECT * FROM a JOIN b USING a, bnow returnaandbcolumns only from the left table. #4141 (Artem Zuikov)
Why it matters
This change addresses the ambiguity inJOIN USING by ensuring that columns specified in the USING clause are included exclusively from the left table in the result set. This provides more predictable and consistent query results to users.How to use it
When performing a join with theUSING clause, such as SELECT * FROM a JOIN b USING (a, b), the resulting columns a and b will be selected from the left table a. No additional user action is needed to enable this behavior; it is applied by default in queries using JOIN USING.