Awesome, works fine now. Cheers, Ryan
Thomas Mueller wrote: > Hi, > > This is probably the same as this issue here: > http://code.google.com/p/h2database/issues/detail?id=119 > > Could you try if the patch submitted there solves the problem for you? > > Regards, > Thomas > > > > On Sat, Sep 19, 2009 at 4:33 AM, Ryan How <r...@exemail.com.au> wrote: > >> I have this jaqu query, >> >> long okCount = db.from(msli) >> >> .innerJoin(ms).on(ms.maintenanceStatusId).is(msli.maintenanceStatusId) >> .innerJoin(sp).on(ms.samplePointId).is(sp.samplePointId) >> .whereTrue(Function.and(ms.latest, msli.itemStatus)) >> .and(msli.maintenanceStatusItemId).is(i.maintenanceStatusItemId) >> .and(sp.siteId).is(site.siteId) >> .selectCount(); >> >> I've tried different variations of this query, but the issue is that >> when there is more than 1 boolean (ms.latest and msli.itemStatus in this >> case) they are both resolved to the same one, so the sql is incorrect. >> >> The above query resolves to: >> >> SELECT COUNT(*) FROM MaintenanceStatusLineItem AS T269 INNER JOIN >> MaintenanceStatus AS T270 ON T270.maintenanceStatusId >> =T269.maintenanceStatusId INNER JOIN SamplePoint AS T271 ON >> T270.samplePointId =T271.samplePointId WHERE (T270.latest AND >> T270.latest) AND T269.maintenanceStatusItemId =? AND T271.siteId =? >> >> This is from H2 version 1.1.116 (I think!, That is the H2 version, but I >> may have built JaQu from an earlier version) >> >> I'm a bit strapped for time at the moment so I haven't got a standalone >> example, but I just wanted to inform of this bug. At the moment when I >> hit bugs I just replace it with SQL. JaQu is very nice when it works :) >> >> Cheers, >> >> Ryan >> >> >> > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---