github-actions[bot] commented on issue #15787: URL: https://github.com/apache/dolphinscheduler/issues/15787#issuecomment-2029427466
### 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 The SQL job uses the oracle data source type, and the task error occurs when union all is used in sql. Execute the following sql: select a,b,c,b-c as d from (select 1 as a,2 as b,3 as c from dual) union all select 1 as a,2 as b,3 as c,4 as d from dual By querying the log, you can see that the above sql is parsed as: SELECT a, b, c, b - c AS d FROM ( SELECT 1 AS a, 2 AS b, 3 AS c FROM dual UNION ALL SELECT 1 AS a, 2 AS b, 3 AS c, 4 AS d FROM dual ) ### What you expected to happen Display the merged result set normally ### How to reproduce Execute the following sql in the SQL task: select a,b,c,b-c as d from (select 1 as a,2 as b,3 as c from dual) union all select 1 as a,2 as b,3 as c,4 as d from dual ### Anything else _No response_ ### Version 3.2.x ### Are you willing to submit PR? - [ ] 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: commits-unsubscr...@dolphinscheduler.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
