issue with where clause

[Nirav Shah]

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