Uh, oh,
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 <jonhoff...@gmail.com> wrote:
> Woo! Updating now...
>
> On Oct 8, 8:25 pm, David Pollak <feeder.of.the.be...@gmail.com> 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 <c...@munat.com> 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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
