Uploaded image for project: 'NHibernate [Moved to GitHub]'
  1. NH-2925

Improper SQL is generated for Take (pagination) for dialects which have UseMaxForLimit = true (like Oracle)

    Details

    • Sprint:

      Description

      This is the Clone of NH-2924 Closed

      QueryTakeParameterSpecification has a flaw in Bind because it does not take into account the absolute limit for certain dialects which have the flag UseMaxForLimit = true. The generated SQL does not return any results when executed for a query with Take(10).Skip(10) for example.

      The issue still persists for Query and it can cause huge sneaky problems

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                flukefan Richard Brown
                Reporter:
                reverseblade Onur Gumus
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Who's Looking?