[GitHub] [dolphinscheduler] ruanwenjun opened a new issue, #13197: [Bug] [ProceducerTask] Remove datasource in procedure task

[GitBox <gi...@apache.org>]

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: commits-unsubscribe@dolphinscheduler.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #13197: [Bug] [ProceducerTask] Remove datasource in procedure task

[GitBox <gi...@apache.org>]

github-actions[bot] commented on issue #13197:
URL: https://github.com/apache/dolphinscheduler/issues/13197#issuecomment-1352613377

   Thank you for your feedback, we have received your issue, Please wait patiently for a reply.
   * In order for us to understand your request as soon as possible, please provide detailed information、version or pictures.
   * If you haven't received a reply for a long time, you can [join our slack](https://s.apache.org/dolphinscheduler-slack) and send your question to channel `#troubleshooting`


-- 
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-unsubscribe@dolphinscheduler.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [dolphinscheduler] caishunfeng closed issue #13197: [Bug] [ProceducerTask] Remove datasource in procedure task

[GitBox <gi...@apache.org>]

caishunfeng closed issue #13197: [Bug] [ProceducerTask] Remove datasource in procedure task 
URL: https://github.com/apache/dolphinscheduler/issues/13197


-- 
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-unsubscribe@dolphinscheduler.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org