Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

MultiCriteria throws exception when trying to do a paging query

Description

I'm tried to implement a method that will create all the criterias I needed to execute and return the data as paged list, but it fails if the pageIndex is equal to 0 (the first page).

Here's the method.

Environment

None

Activity

Frédéric Delaporte 
July 17, 2018 at 10:31 AM

Moved here.

In fact, this has been fixed for SQL server "by the way" when was implemented (NH v3.4). But the trouble remains for other dialects, like Firebird, Sybase, Informix, SqlServerCe.

This trouble is not bound to multi-query/criteria.

Julian Maughan 
April 6, 2012 at 5:13 AM

Since there is a simple workaround for this issue - i.e. 'use_sql_comments' to false - I'm changing the priority of this issue.

Julian Maughan 
April 6, 2012 at 5:12 AM

Maybe Skip(0) should be removed from the query before it gets to the dialect - its completely redundant.

Luis Fernando 
January 17, 2012 at 11:21 PM

Of course I can do it, maybe in one or two days, ok.

Oskar Berggren 
January 17, 2012 at 9:56 AM

Luis, would you mind creating simple test case that expose the problem?

Details

Assignee

Reporter

Labels

Components

Affects versions

Priority

Who's Looking?

Open Who's Looking?
Created January 16, 2012 at 9:13 PM
Updated July 17, 2018 at 10:32 AM
Who's Looking?