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