On Thu, Nov 5, 2009 at 3:47 PM, jon <jonhoff...@gmail.com> wrote: > > I just verified that the newer h2 fixes the problem. Thanks for > investigating! >
Sure thing. Party on! > > 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 > > > -- Lift, the simply functional web framework http://liftweb.net Beginning Scala http://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 -~----------~----~----~----~------~----~------~--~---