This is a bug and its weird that changing the literal in the condition makes it work. Can you go ahead and raise a jira for the same?
On Thu, Nov 10, 2016 at 10:58 AM, Josson Paul <jossonp...@gmail.com> wrote: > Hi, > > My query is below > > select MIN(case when (CMP__acIds like '%6%') then A__ln__intrRt else > null end) acID2,MIN(case when (A__ln__intrRt > 4.0) then 1 else null > end) acID1,MIN(case when (A__ln__intrRt > 4.0) and CMP__acIds like > '%6%' then 1 else null end) acID3 from <table name> > > > The above query returns > org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: > CompileException: Line 151, Column 22: Statement "break AndOP0" is not > enclosed by a breakable statement with label "AndOP0" Fragment 1:0 > > I am using drill 1.8 > > If I make different values for A__ln__intrRt greater than condition, then > the query works. If both values are same, the query gives above error. > Currently as you see in the query, both have 4.0 as values. Another way to > make this query works is to remove one of the select field > -- > Thanks > Josson >
