search

apache / linkis

Apache Linkis builds a computation middleware layer to facilitate connection, governance and orchestration between the upper applications and the underlying data engines.
https://linkis.apache.org/
Apache License 2.0
3.3k stars 1.17k forks source link

Scripts Adding limit at the end of SQL server SQL results in an SQL error #4953

Open zhaoyvli opened 11 months ago

zhaoyvli commented 11 months ago

Search before asking

Linkis Component

linkis-computation-governance

Steps to reproduce

Add a SQL server data source in the linkis admin console, create a jdbc in script, and execute SQL server queries sql.

Expected behavior

SQL server SQL does not support adding limit at the end, Correct SQL should be select top 1 * from table_name

Your environment

linkis1.4.0

Anything else

No response

Are you willing to submit a PR?

github-actions[bot] commented 11 months ago

:blush: Welcome to the Apache Linkis community!!

We are glad that you are contributing by opening this issue.

Please make sure to include all the relevant context. We will be here shortly.

If you are interested in contributing to our website project, please let us know! You can check out our contributing guide on :point_right: How to Participate in Project Contribution.

Community

WeChat Assistant WeChat Public Account

Mailing Lists

Name Description Subscribe Unsubscribe Archive
dev@linkis.apache.org community activity information subscribe unsubscribe archive
casionone commented 11 months ago

@MrZhao1024B can help to optimize this case and submit a PR?