You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by "sp1022 (via GitHub)" <gi...@apache.org> on 2024/09/10 06:04:16 UTC

[I] [Bug] Bug title 3.2.2版本无法调用pl/pgsql [dolphinscheduler]

sp1022 opened a new issue, #16603:
URL: https://github.com/apache/dolphinscheduler/issues/16603

   ### 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
   
   在3.X版本之前我可以使用非查询调用如下脚本(创建工作流->SQL->数据源类型:postgres, sql类型:非查询)
   do $func$ 
   declare
      v_sql text;
   begin
      XXXXXXXX
   end
   $func$;
   当我升级到3.2.2以后,程序报错:
   [error] sql task error 
     org.apache.dolphinscheduler.plugin.task.api.TaskException:sql task prepareStatmentAndBind error
   
   ### What you expected to happen
   
   在创建工作流->SQL->数据源类型:postgres, sql类型:非查询。可以调用pl/pgsql块
   
   ### How to reproduce
   
   使用最新版的就可以复现:
   创建工作流->SQL->数据源类型:postgres, sql类型:非查询
   
   ### Anything else
   
   no
   
   ### 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-unsubscribe@dolphinscheduler.apache.org.apache.org

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


Re: [I] [Bug] Bug title 3.2.2 version cannot call pl/pgsql [dolphinscheduler]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #16603:
URL: https://github.com/apache/dolphinscheduler/issues/16603#issuecomment-2339725244

   ### 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
   
   Before version 3.X, I could call the following script using non-query (Create workflow->SQL->Data source type: postgres, sql type: non-query)
   do $func$
   declare
      v_sql text;
   begin
      XXXXXXXX
   end
   $func$;
   When I upgraded to 3.2.2, the program reported an error:
   [error] sql task error
     org.apache.dolphinscheduler.plugin.task.api.TaskException:sql task prepareStatmentAndBind error
   
   ### What you expected to happen
   
   Create workflow->SQL->Data source type: postgres, sql type: non-query. The pl/pgsql block can be called
   
   ### How to reproduce
   
   You can reproduce it using the latest version:
   Create workflow->SQL->Data source type: postgres, sql type: non-query
   
   ### Anything else
   
   no
   
   ### 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-unsubscribe@dolphinscheduler.apache.org

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


Re: [I] [Bug] 3.2.2 version cannot call pl/pgsql [dolphinscheduler]

Posted by "chaz6chez (via GitHub)" <gi...@apache.org>.
chaz6chez commented on issue #16603:
URL: https://github.com/apache/dolphinscheduler/issues/16603#issuecomment-2668463029

   SAME HERE!


-- 
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


Re: [I] [Bug] 3.2.2 version cannot call pl/pgsql [dolphinscheduler]

Posted by "SbloodyS (via GitHub)" <gi...@apache.org>.
SbloodyS closed issue #16603: [Bug] 3.2.2 version cannot call pl/pgsql
URL: https://github.com/apache/dolphinscheduler/issues/16603


-- 
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