njnu-seafish opened a new issue, #17701: URL: https://github.com/apache/dolphinscheduler/issues/17701
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar issues. ### What happened When field names are duplicated in a query statement, the result set suffers from name collision, causing values to overwrite each other; For example: SELECT user.name AS display_name, admin.name AS display_name FROM user JOIN admin ON user.id = admin.user_id; ### What you expected to happen If field names are duplicated, the result set should automatically append suffixes to disambiguate them. ### How to reproduce When field names are duplicated in a query statement, the result set suffers from name collision, causing values to overwrite each other; For example: SELECT user.name AS display_name, admin.name AS display_name FROM user JOIN admin ON user.id = admin.user_id; ### Anything else _No response_ ### Version dev ### Are you willing to submit PR? - [x] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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]
