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 -- 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.
