This little program deletes all rows. Is this a bug, or perhaps I misunderstand how delete with an exists clause is supposed to work.
drop table if exists dummy; create table dummy ( var int ); insert into dummy (var) values (1); insert into dummy (var) values (2); insert into dummy (var) values (3); delete from dummy where exists (select * from dummy where var='2'); _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users