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.

Sign up for GitHub

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

Jump to bottom

In MsSql ORDER BY queries fail #255

Open
andicuko opened this issue Jan 22, 2024 · 0 comments
Open

In MsSql ORDER BY queries fail #255

andicuko opened this issue Jan 22, 2024 · 0 comments
Assignees
@andicuko

Comments

@andicuko
Copy link
Contributor

DP rewritten queries can have ORDER BY statements and executing such queries in mssql it fails with:

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.

Fix the MsSqlTranslator to handle such cases.
@andicuko andicuko self-assigned this Jan 22, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@andicuko andicuko

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@andicuko