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 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 [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 -~----------~----~----~----~------~----~------~--~---
