thanks: http://github.com/dpp/liftweb/issues/#issue/91
On Oct 8, 10:21 pm, David Pollak <[email protected]> wrote: > On Thu, Oct 8, 2009 at 7:01 PM, jon <[email protected]> wrote: > > > Uh, oh, > > Crud. Can you open a ticket with a repro case and I'll add it to the test > suite and make sure it gets fixed. > > > > > > > > > I just updated to M6 from M5 and it Seems that PreCache is broken > > under H2 when there is an OrderBy: > > > org.h2.jdbc.JdbcSQLException: Order by expression CREATED_AT must be > > in the result list in this case; SQL statement: > > SELECT DISTINCT foos.id, foos.name FROM foos WHERE id IN (SELECT > > foo_id FROM bars WHERE (created_by = ?) ORDER BY created_at DESC > > LIMIT 100 ) [90068-117] > > at org.h2.message.Message.getSQLException(Message.java:105) > > at org.h2.message.Message.getSQLException(Message.java:116) > > at org.h2.message.Message.getSQLException(Message.java:75) > > at org.h2.command.dml.Query.initOrder(Query.java:323) > > at org.h2.command.dml.Select.init(Select.java:637) > > at org.h2.command.Parser.parseSelect(Parser.java:1343) > > at org.h2.command.Parser.parsePrepared(Parser.java:394) > > at org.h2.command.Parser.parse(Parser.java:290) > > at org.h2.command.Parser.parse(Parser.java:262) > > at org.h2.command.Parser.prepare(Parser.java:204) > > at org.h2.engine.Session.prepare(Session.java:400) > > at org.h2.engine.Session.prepare(Session.java:387) > > at org.h2.table.TableView.recompileQuery(TableView.java:70) > > at org.h2.table.TableView.initColumnsAndTables(TableView.java:83) > > at org.h2.table.TableView.<init>(TableView.java:60) > > at org.h2.table.TableView.createTempView(TableView.java:340) > > at org.h2.expression.ConditionInSelect.optimizeInJoin > > (ConditionInSelect.java:150) > > at org.h2.command.dml.Select.prepare(Select.java:725) > > at org.h2.command.CommandContainer.recompileIfRequired > > (CommandContainer.java:62) > > at org.h2.command.CommandContainer.query(CommandContainer.java:78) > > at org.h2.command.Command.executeQueryLocal(Command.java:142) > > at org.h2.command.Command.executeQuery(Command.java:123) > > at org.h2.jdbc.JdbcPreparedStatement.executeQuery > > (JdbcPreparedStatement.java:99) > > at net.liftweb.mapper.DB$$anonfun$exec$3.apply(DB.scala:295) > > at net.liftweb.mapper.DB$$anonfun$exec$3.apply(DB.scala:294) > > at > > net.liftweb.util.TimeHelpers$class.calcTime(TimeHelpers.scala:241) > > at net.liftweb.util.Helpers$.calcTime(Helpers.scala:29) > > at net.liftweb.mapper.DB$.exec(DB.scala:294) > > at net.liftweb.mapper.MetaMapper$$anonfun$findMapFieldDb$1$$anonfun > > $apply$9.apply(MetaMapper.scala:317) > > at net.liftweb.mapper.MetaMapper$$anonfun$findMapFieldDb$1$$anonfun > > $apply$9.apply(MetaMapper.scala:315) > > at net.liftweb.mapper.DB$$anonfun$runPreparedStatement$1.apply > > (DB.scala:375) > > at net.liftweb.mapper.DB$$anonfun$runPreparedStatement$1.apply > > (DB.scala:372) > > at > > net.liftweb.util.TimeHelpers$class.calcTime(TimeHelpers.scala:241) > > at net.liftweb.util.Helpers$.calcTime(Helpers.scala:29) > > at net.liftweb.mapper.DB$.runPreparedStatement(DB.scala:372) > > at net.liftweb.mapper.DB$.prepareStatement(DB.scala:316) > > at net.liftweb.mapper.MetaMapper$$anonfun$findMapFieldDb$1.apply > > (MetaMapper.scala:314) > > at net.liftweb.mapper.MetaMapper$$anonfun$findMapFieldDb$1.apply > > (MetaMapper.scala:306) > > at net.liftweb.mapper.DB$.use(DB.scala:389) > > at net.liftweb.mapper.MetaMapper$class.findMapFieldDb > > (MetaMapper.scala:305) > > at me.model.foo$.findMapFieldDb(foo.scala:17) > > at net.liftweb.mapper.MetaMapper$class.findMapDb(MetaMapper.scala: > > 301) > > at me.model.foo$.findMapDb(foo.scala:17) > > at net.liftweb.mapper.MetaMapper$class.findAll(MetaMapper.scala:267) > > at me.model.foo$.findAll(foo.scala:17) > > at net.liftweb.mapper.MetaMapper$$anonfun$dealWithPrecache$1.apply > > (MetaMapper.scala:235) > > at net.liftweb.mapper.MetaMapper$$anonfun$dealWithPrecache$1.apply > > (MetaMapper.scala:228) > > at scala.List.foreach(List.scala:841) > > at net.liftweb.mapper.MetaMapper$class.dealWithPrecache > > (MetaMapper.scala:228) > > at net.liftweb.mapper.MetaMapper$class.findAll(MetaMapper.scala:267) > > > On Oct 8, 9:22 pm, jon <[email protected]> wrote: > > > Woo! Updating now... > > > > On Oct 8, 8:25 pm, David Pollak <[email protected]> wrote: > > > > > Charles, > > > > Thanks for spinning another build. I owe you a beverage or three. > > > > > The rest of you committers, it's time to dump all those pent-up, > > > > review-board approved changes on master. > > > > > Thanks, > > > > > David > > > > > On Thu, Oct 8, 2009 at 5:13 PM, Charles F. Munat <[email protected]> > > wrote: > > > > > > The Lift team is pleased to announce the lift-1.1-M6 release! > > > > > > Lift is an expressive and elegant framework for writing web > > > > > applications. Lift stresses the importance of security, > > maintainability, > > > > > scalability and performance while allowing for high levels of > > developer > > > > > productivity. Lift is a scala web framework. > > > > > > No changes defined in this version. > > > > > > Have fun! > > > > > -Lift team > > > > > -- > > > > 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 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~----------~----~----~----~------~----~------~--~---
