Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug] 3.2.2 version cannot call pl/pgsql #16603

Open
2 of 3 tasks
sp1022 opened this issue Sep 10, 2024 · 1 comment
Open
2 of 3 tasks

[Bug] 3.2.2 version cannot call pl/pgsql #16603

sp1022 opened this issue Sep 10, 2024 · 1 comment
Labels
bug Something isn't working help wanted Extra attention is needed

Comments

@sp1022
Copy link

sp1022 commented Sep 10, 2024

Search before asking

  • I had searched in the issues 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

@sp1022 sp1022 added bug Something isn't working Waiting for reply Waiting for reply labels Sep 10, 2024
@github-actions github-actions bot changed the title [Bug] Bug title 3.2.2版本无法调用pl/pgsql [Bug] Bug title 3.2.2 version cannot call pl/pgsql Sep 10, 2024
Copy link

Search before asking

  • I had searched in the issues 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

@SbloodyS SbloodyS removed the Waiting for reply Waiting for reply label Sep 11, 2024
@SbloodyS SbloodyS changed the title [Bug] Bug title 3.2.2 version cannot call pl/pgsql [Bug] 3.2.2 version cannot call pl/pgsql Sep 11, 2024
@SbloodyS SbloodyS added the help wanted Extra attention is needed label Sep 11, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working help wanted Extra attention is needed
Projects
None yet
Development

No branches or pull requests

2 participants