ruanwenjun opened a new issue, #13197: URL: https://github.com/apache/dolphinscheduler/issues/13197
### 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 Right now, we use datasource in procedure task, this will cause we cannot use TEMPORARY TABLE in procedure, since the temporary table will be release after the connection session close. But in datasource the session will not be closed, so the temporary will be share in different task. ### What you expected to happen xx ### How to reproduce In different task call the procedure. ``` CREATE PROCEDURE `temporary_table`() BEGIN CREATE TEMPORARY TABLE str_spilt_result ( id BIGINT(20) NOT NULL ); SELECT * from str_spilt_result; END; ``` ### 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]
