Can someone help me on this?
On Mon, Dec 21, 2015 at 2:19 PM, Nirav Shah <nirav.s...@games24x7.com> wrote: > Hi, > > > I am put up in strange situation. > > select count(distinct case when misfmg = 'true' then sessionid end) nnn > from t196 t where channelid = 2 and id = '/confirmDrop/btnYes/' and > event='click' and mprizetype= 1 and mgametype = 'cfp' ; > > is running fine and giving expected results but > > select count(distinct sessionid) from t196 t where channelid = 2 and id > = '/confirmDrop/btnYes/' and event='click' and mprizetype= 1 and > mgametype = 'cfp' and misfmg is null ; > > is giving below error. > > Error: SYSTEM ERROR: StringIndexOutOfBoundsException: String index out of > range: -5 > > while I remove this where condition it works fine. > > select count(distinct sessionid) from t196 t where channelid = 2 and id > = '/confirmDrop/btnYes/' and event='click' and mprizetype= 1 and > mgametype = 'cfp' ; > > Something really strange to me. > > Thanks in advance. > > Regards, > Nirav >