ups... I'm sorry... I have to review your query On Mon, Jul 5, 2010 at 6:21 PM, Fabio Maulo <[email protected]> wrote:
> The bug was in 2.0 and previous versions. > "NOT EXISTS" is not in HQL syntax. > The previous parser was ignoring any "not know" words where the new parse > check the right syntax. > > > On Mon, Jul 5, 2010 at 6:18 PM, John Davidson <[email protected]>wrote: > >> I would suggest checking the JIRA bug tracker as http://216.121.112.228/to >> see if there is a reported bug. >> >> If not could you please complete a bug report with a failing test? >> >> Note: the web site appears to be down at this moment >> >> John Davidson >> >> >> On Mon, Jul 5, 2010 at 4:57 PM, gary lucas <[email protected]> wrote: >> >>> No responses so far, anyone have any resources at all? >>> >>> I've found quite a few references to this being an issue but with no >>> fixes so far that would apply to this issue. >>> >>> G >>> >>> On Jun 30, 1:31 pm, gary lucas <[email protected]> wrote: >>> > One more thing, this seems to run fine Nhibernate Query Analyzer. >>> > >>> > G >>> > >>> > On Jun 30, 1:21 pm, gary lucas <[email protected]> wrote: >>> > >>> > >>> > >>> > > I'm in the process of migrating a fairly large application to >>> > > nHibernate 2.1.2 and most queries work, however this one is >>> > > problematic. >>> > >>> > > ---------------------------------- >>> > > {"Exception of type 'Antlr.Runtime.NoViableAltException' was thrown. >>> > > [ >>> > > from Account act >>> > > left join fetch act.AccountTransactions actr >>> > > left join fetch actr.ChargeAppliedPayments cap >>> > > left join fetch actr.PaymentAppliedPayments pap >>> > > left join fetch actr.Type typ >>> > > where act.Id = :Id >>> > > and typ.ClassCode <> :payment >>> > > and ( >>> > > NOT EXISTS >>> > > (select >>> > > pmt1.Id >>> > > from >>> > > AppliedPayment pmt1 >>> > > join pmt1.ChargeAccountTransaction actr1 >>> > > where >>> > > actr1.Id = actr.Id >>> > > ) >>> > > OR >>> > > actr.GrossAmount > >>> > > -( >>> > > select >>> > > sum(pmt2.Amount) >>> > > from AppliedPayment pmt2 >>> > > join >>> pmt2.ChargeAccountTransaction actr2 >>> > > where >>> > > actr2.Id = actr.Id >>> > > ) >>> > > ) >>> > > ORDER BY actr.Id asc >>> > > -------------------------------------- >>> > >>> > > in searching the forums I couldn't find allot of definitive answers >>> on >>> > > the subject of antlr errors... I know the issue resides in the >>> > > subquery... However this worked in 1.2, and seems to have issues >>> > > now... >>> > >>> > > Thank you >>> > >>> > > Gary >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "nhusers" group. >>> To post to this group, send email to [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]<nhusers%[email protected]> >>> . >>> For more options, visit this group at >>> http://groups.google.com/group/nhusers?hl=en. >>> >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<nhusers%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/nhusers?hl=en. >> > > > > -- > Fabio Maulo > > -- Fabio Maulo -- You received this message because you are subscribed to the Google Groups "nhusers" 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/nhusers?hl=en.
