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].
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.
