dolphinscheduler icon indicating copy to clipboard operation
dolphinscheduler copied to clipboard

[Bug] [SQL Task] Clickhouse SQL Task, Caused by: java.sql.SQLException: Prepared statement only supports one query but we got

Open luciyu opened this issue 2 years ago • 1 comments

Search before asking

  • [X] I had searched in the issues and found no similar issues.

What happened

I created a clickhouse SQL task on version 3.2.0 to execute multiple DDL statements, Return error "Prepared statement only supports one query but we got 21" but I did support it on version 3.0.0. Is this feature removed now in version 3.2.0?

What you expected to happen

I want to execute multiple DDL statements in a clickhouse SQL task.

How to reproduce

Create clickhouse SQL Task on version 3.2.0 to execute multiple DDL statements.

Anything else

No response

Version

3.2.x

Are you willing to submit PR?

  • [X] Yes I am willing to submit a PR!

Code of Conduct

luciyu avatar Jan 01 '24 02:01 luciyu

could you share your sql in sql task?

zhongjiajie avatar Jan 30 '24 07:01 zhongjiajie

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.

github-actions[bot] avatar Mar 01 '24 00:03 github-actions[bot]

This issue has been closed because it has not received response for too long time. You could reopen it if you encountered similar problems in the future.

github-actions[bot] avatar Mar 10 '24 00:03 github-actions[bot]

我也遇到这个问题了,是还没有修复吗

sqlboylove avatar Jul 05 '24 02:07 sqlboylove