I just verified that the newer h2 fixes the problem. Thanks for investigating!
On Nov 5, 6:33 pm, David Pollak <feeder.of.the.be...@gmail.com> wrote: > On Wed, Nov 4, 2009 at 10:02 AM, jon <jonhoff...@gmail.com> wrote: > > > Hi, > > > I just noticed OrderBy statements cause Inner selects to break in h2: > > > I query such as: User.findAll(In(User.id, Dog.owner, OrderBy(Dog.name, > > Ascending)), MaxRows(5)) > > > Produces: > > > Message: org.h2.jdbc.JdbcSQLException: Order by expression NAME must > > be in the result list in this case; SQL statement: > > SELECT DISTINCT OWNER AS _0 > > FROM PUBLIC.DOG /* PUBLIC.DOG_TABLE_SCAN */ > > ORDER BY =NAME [90068-117] > > This is an issue in H2 1.1. Please upgrade to 1.2.121 and the problem goes > away. > > If it's not possible for you to upgrade to 1.2.121, let's discuss by phone > or privately. > > > > > Code to duplicate here: > > >http://github.com/hoffrocket/lift_1_1_sample/commit/0093e2585e0d9d799... > > > This works in M5. Any chance a workaround or fix could be put out > > before M7? Sorry, I didn't notice until today. > > > Thanks, > > > Jon > > -- > Lift, the simply functional web frameworkhttp://liftweb.net > Beginning Scalahttp://www.apress.com/book/view/1430219890 > Follow me:http://twitter.com/dpp > Surf the harmonics --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Lift" group. To post to this group, send email to liftweb@googlegroups.com To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~----------~----~----~----~------~----~------~--~---