This works: select orgid, case when status = 'y' then '1' else '0' end from vend
This doesn't: select distinct orgid, case when status = 'y' then '1' else '0' end from vend
The only difference is the absence of distinct clause.bug?