Hi!

I have a SY_REPORT_WRITER_REPORTS table that loosely looks like:

NBR STATE
1 'C'
2 'P'
2 'N'
3 'N'

I run:

delete from SY_REPORT_WRITER_REPORTS t1 where t1.NBR in (select
t2.NBR from SY_REPORT_WRITER_REPORTS t2 where ACTIVE_RECORD='N')

After that data looks like:
NBR STATE
1 'C'
2 'P'

It looks like a huge bug to me. Or is it a feature?