Problem executing delete statement

[usamaalam]

Hello everybody,

When I run the following statement, it returns 3660 rows.

select * from symbols where code = 'AAHSY00';

But when I run the following statement, it doesn't do anything and goes in a never ending loop.

delete from symbols where code = 'AAHSY00';

Any idea on how to fix this?

Thanks.

[Fumigator]

Try adding LIMIT 1; if that works, then the delete query may just be taking a really really really really long time.