strongduanmu commented on issue #22355: URL: https://github.com/apache/shardingsphere/issues/22355#issuecomment-1324795697
According to PostgreSQL document, when we use using condition, it will only return one join field in result. So we should be compatible with this behavior. Besides, after testing, openGauss has the same behavior. ``` USING ( join_column [, ...] ) [ AS join_using_alias ] A clause of the form USING ( a, b, ... ) is shorthand for ON left_table.a = right_table.a AND left_table.b = right_table.b .... Also, USING implies that only one of each pair of equivalent columns will be included in the join output, not both. If a join_using_alias name is specified, it provides a table alias for the join columns. Only the join columns listed in the USING clause are addressable by this name. Unlike a regular alias, this does not hide the names of the joined tables from the rest of the query. Also unlike a regular alias, you cannot write a column alias list — the output names of the join columns are the same as they appear in the USING list. ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
