JPA Query Problem

Yes. In fact, the problem I've posted is a generalization of a more strange behaviur. The (cutted-off) schema is

Table Charter

idintegerprimary key

company integerforeign key (on 'id' of table 'company')

pricedecimal

Table Company

idintegerprimary key

nametext

Now, assume I have 10 records in table Charter referencing 10 records in table Company (each row in Charter reference a distinct row in Company).

This query returns me THE CORRECT RESULT (that is, each matching row is present in the result set only once):

SELECT o FROM Charter AS o WHERE o.company.id = :company AND 1=1

Instead, this query returns me each matching row, BUT REPEATED N TIMES, where N is the number of rows in Charter (10):

SELECT o FROM Charter AS o WHERE 1=1 AND o.company.id = :company

(Notice that the only difference is the order of the where clause)

(Notice also that I get the same behaviour even if I do a query on the 'price' field).

Also, this query that should return all the rows in the table (one time each), returns them N times:

SELECT o FROM Charter AS o WHERE 1=1

Any idea?

Really thank you

ps I forgot to say that, after translating those JPQL query in standard SQL and executing them in PostgreSQL console, they are, obiouvsly, equivalent and work correctly.

Message was edited by:

Konrad84

Konrad84a at 2007-7-12 15:08:27 >