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

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

Open
2 tasks done
zhaoyvli opened this issue Oct 26, 2023 · 2 comments
Open
2 tasks done
Labels
bug Something isn't working

Comments

@zhaoyvli
Copy link

Search before asking

  • I searched the issues and found no similar issues.

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?

  • Yes I am willing to submit a PR!
@zhaoyvli zhaoyvli added the bug Something isn't working label Oct 26, 2023
@github-actions
Copy link

😊 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
👉 How to Participate in Project Contribution.

Community

WeChat Assistant WeChat Public Account

Mailing Lists

Name Description Subscribe Unsubscribe Archive
[email protected] community activity information subscribe unsubscribe archive

@zhaoyvli zhaoyvli changed the title Scripts An SQL error occurs when limit is added at the end of the SQL server sql execution Scripts Adding limit at the end of SQL server SQL results in an SQL error Oct 26, 2023
@casionone
Copy link
Contributor

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

@apache apache deleted a comment Aug 13, 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
Projects
None yet
Development

No branches or pull requests

2 participants