[Lift] Re: 1.1-SNAPSHOT In() with OrderBy mapper bug
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/0093e2585e0d9d799b503f32da7496e212efd873 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 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 -~--~~~~--~~--~--~---
[Lift] Re: 1.1-SNAPSHOT In() with OrderBy mapper bug
I just verified that the newer h2 fixes the problem. Thanks for investigating! 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 --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[Lift] Re: 1.1-SNAPSHOT In() with OrderBy mapper bug
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 -~--~~~~--~~--~--~---
[Lift] Re: 1.1-SNAPSHOT In() with OrderBy mapper bug
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 -~--~~~~--~~--~--~---
[Lift] Re: 1.1-SNAPSHOT In() with OrderBy mapper bug
That would be great. Would it also be published to the scala-tools repo? On Nov 4, 1:18 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] 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. How about a branch off M7 that fixes this one bug? 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 --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[Lift] Re: 1.1-SNAPSHOT In() with OrderBy mapper bug
Wow, congrats! On Nov 4, 1:46 pm, David Pollak feeder.of.the.be...@gmail.com wrote: On Wed, Nov 4, 2009 at 10:36 AM, jon jonhoff...@gmail.com wrote: That would be great. Would it also be published to the scala-tools repo? Dunno. Got to figure out how to get it published. But we can work on that tomorrow (today's release day, plus I turn into a dad @ 1pm PST) On Nov 4, 1:18 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] 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. How about a branch off M7 that fixes this one bug? 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 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 -~--~~~~--~~--~--~---
[Lift] Re: 1.1-SNAPSHOT In() with OrderBy mapper bug
On Wed, Nov 4, 2009 at 11:04 AM, jon jonhoff...@gmail.com wrote: Wow, congrats! No... not that way... I've got 5 year old twins... but our nanny's on vacation and my wife http://www.orrick.com/lawyers/Bio.asp?ID=227282 is way too busy on a huge case, so I'm primary childcare. On Nov 4, 1:46 pm, David Pollak feeder.of.the.be...@gmail.com wrote: On Wed, Nov 4, 2009 at 10:36 AM, jon jonhoff...@gmail.com wrote: That would be great. Would it also be published to the scala-tools repo? Dunno. Got to figure out how to get it published. But we can work on that tomorrow (today's release day, plus I turn into a dad @ 1pm PST) On Nov 4, 1:18 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] 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. How about a branch off M7 that fixes this one bug? 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 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 -~--~~~~--~~--~--~---
