I can confirm the fix. Our unit tests work with 1.3.170 fail with 1.3.171 work with latest build from 2013-05-14.
Thanks for the quick response and fix. regards, F. Am Montag, 13. Mai 2013 14:34:22 UTC+2 schrieb Noel Grandin: > > This was fixed in SVN a little while ago, so it'll be in the next release. > Please test with the nightly build to confirm. > > On 2013-05-13 10:29, Flo Schwarz wrote: > > Hi, > > > > we are using EclipseLink 2.4.1 as ORM layer and H2 1.3.170 as database. > > > > When we tried to update to the latest H2 version 1.3.171, we got a > > couple of failing unit tests. > > > > This is the query that is executed by one of our tests: > > SELECT DISTINCT t1.ID AS a1, ... > > FROM CATEGORYEJB t0, TERMEJB_CATEGORYEJB t2, TERMEJB t1 > > WHERE (((t0.type = ?) AND (t0.ID = ?)) AND ((t2.TERMEJB_ID = t1.ID) > > AND (t0.ID = t2.CATEGORIES_ID))) > > ORDER BY t1.ID ASC LIMIT ? OFFSET ? > > > > This is the error message: > > [EL Warning]: 2013-05-13 > > 09:43:54.977--UnitOfWork(1493807900)--Exception [EclipseLink-4002] > > (Eclipse Persistence Services - 2.4.1.v20121003-ad44345): > > org.eclipse.persistence.exceptions.DatabaseException > > Internal Exception: org.h2.jdbc.JdbcSQLException: General error: > > "java.lang.IllegalArgumentException: fromIndex(1000) > toIndex(1)"; > > SQL statement: > > SELECT DISTINCT t1.ID AS a1,... FROM CATEGORYEJB t0, > > TERMEJB_CATEGORYEJB t2, TERMEJB t1 WHERE (((t0.type = ?) AND (t0.ID = > > ?)) AND ((t2.TERMEJB_ID = t1.ID) AND (t0.ID = t2.CATEGORIES_ID))) > > ORDER BY t1.ID ASC LIMIT ? OFFSET ? [50000-171] > > Error Code: 50000 > > Call: SELECT DISTINCT t1.ID AS a1, ... FROM CATEGORYEJB t0, > > TERMEJB_CATEGORYEJB t2, TERMEJB t1 WHERE (((t0.type = ?) AND (t0.ID = > > ?)) AND ((t2.TERMEJB_ID = t1.ID) AND (t0.ID = t2.CATEGORIES_ID))) > > ORDER BY t1.ID ASC LIMIT ? OFFSET ? > > bind => [4 parameters bound] > > Query: ReadAllQuery(referenceClass=TermEjb sql="SELECT DISTINCT t1.ID > > AS a1,... FROM CATEGORYEJB t0, TERMEJB_CATEGORYEJB t2, TERMEJB t1 > > WHERE (((t0.type = ?) AND (t0.ID = ?)) AND ((t2.TERMEJB_ID = t1.ID) > > AND (t0.ID = t2.CATEGORIES_ID))) ORDER BY t1.ID ASC LIMIT ? OFFSET ?") > > > > > > I can reproduce that the tests fail with version 1.3.170 and succeed > > with version 1.3.171, without doing any other change to the code. > > We are using an in-memory database instance for the unit-tests. > > Meaning that there are not artifacts from previous versions/tests. > > > > Sorry that I can't provide a minimal and executable example. But maybe > > this information already enables you to find the problem. > > > > best regards, > > Felix > > -- > > You received this message because you are subscribed to the Google > > Groups "H2 Database" group. > > To unsubscribe from this group and stop receiving emails from it, send > > an email to [email protected] <javascript:>. > > To post to this group, send email to > > [email protected]<javascript:>. > > > Visit this group at http://groups.google.com/group/h2-database?hl=en. > > For more options, visit https://groups.google.com/groups/opt_out. > > > > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
