Hello, I was able to build the correct revision (with DistributedSQLStoreQuery present). I ran the query below and verified that a) the data was sorted correctly b) the aggregate (count) was correct and c) the query executed on the correct slice.
SELECT u.firstname, u.lastname, count(ce.uid) FROM users u LEFT JOIN userlists ce ON ce.userID = u.uid GROUP BY u.firstname, u.lastname ORDER BY u.lastname; On 08/02/2011 01:12 PM, Pinaki Poddar [via OpenJPA] wrote: > Hi, > I just cross checked with a native SQL query on Slice. It does run. > Though the new addition lacked thorough testing, I would not expect > the error you have reported provided the new changes are applied in > your environment. > > To ensure that the change is available in your environment, please do > the following: > > 1. $ java -jar /path/to/openjpa.jar > this will print the SVN reversion number openjpa is built with > > 2. Check whether following class is present in the distribution > (because this is the newly added class) > org.apache.openjpa.slice.jdbc.DistributedSQLStoreQuery > Pinaki Poddar > Chair, Apache OpenJPA Project > > > ------------------------------------------------------------------------ > If you reply to this email, your message will be added to the > discussion below: > http://openjpa.208410.n2.nabble.com/Native-SQL-Query-tp6432918p6646315.html > > To unsubscribe from Native SQL Query, click here > <http://openjpa.208410.n2.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=6432918&code=bGVzQGVkZWxlbWVudHMuY29tfDY0MzI5MTh8LTE3NTY0MTAyMjc=>. > > -- View this message in context: http://openjpa.208410.n2.nabble.com/Native-SQL-Query-tp6432918p6659066.html Sent from the OpenJPA Users mailing list archive at Nabble.com.