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] > > Code to duplicate here: > > > http://github.com/hoffrocket/lift_1_1_sample/commit/0093e2585e0d9d799b503f32da7496e212efd873 > > This works in M5. Any chance a workaround or fix could be put out > before M7? Sorry, I didn't notice until today. >
How about a branch off M7 that fixes this one bug? > > Thanks, > > Jon > > > -- 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 -~----------~----~----~----~------~----~------~--~---