apache / apache/linkis

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

Open
#4,953 2 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
Java
Stars
3.4k
Forks
1.2k
PR merge metrics
No merged PRs in 30d

Description

### Search before asking

- [X] I searched the [issues](https://github.com/apache/linkis/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?

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

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.