-
Notifications
You must be signed in to change notification settings - Fork 94
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
Pagination doesn't work with MSSQL for some query #1342
Comments
DavideD
added a commit
to DavideD/hibernate-reactive
that referenced
this issue
Jun 17, 2022
The MSSQL dialect generates set the pagination in the query in different ways depending on the presence of the order by clause.
DavideD
added a commit
to DavideD/hibernate-reactive
that referenced
this issue
Jun 17, 2022
DavideD
added a commit
to DavideD/hibernate-reactive
that referenced
this issue
Jun 17, 2022
The MSSQL dialect generates set the pagination in the query in different ways depending on the presence of the order by clause.
DavideD
added a commit
to DavideD/hibernate-reactive
that referenced
this issue
Jun 17, 2022
DavideD
added a commit
to DavideD/hibernate-reactive
that referenced
this issue
Jun 17, 2022
blafond
pushed a commit
that referenced
this issue
Jun 22, 2022
The MSSQL dialect generates set the pagination in the query in different ways depending on the presence of the order by clause.
blafond
pushed a commit
that referenced
this issue
Jun 22, 2022
DavideD
added a commit
to DavideD/hibernate-reactive
that referenced
this issue
Jun 30, 2022
The MSSQL dialect generates set the pagination in the query in different ways depending on the presence of the order by clause.
DavideD
added a commit
to DavideD/hibernate-reactive
that referenced
this issue
Jun 30, 2022
blafond
pushed a commit
to blafond/hibernate-reactive
that referenced
this issue
Sep 30, 2022
The MSSQL dialect generates set the pagination in the query in different ways depending on the presence of the order by clause.
blafond
pushed a commit
to blafond/hibernate-reactive
that referenced
this issue
Sep 30, 2022
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
In Sql Server, we run different queries for pagination based on the type of query.
Here's an extract from
SQLServer2012LimitHandler#processSql
:The error happens for queries without an order-by clause.
Here's a test case to add to
FilterWithPaginationTest
:This will fail because we don't replace the parameters placeholder (
?
) with the one for MSSQL (@P1
).Quarkus issue: eclipse-vertx/vertx-sql-client#1203
The text was updated successfully, but these errors were encountered: