On May 7, 2012, at 2:48 PM, Igor Tandetnik wrote: > begin; > update numbers set num = -num; > update numbers set num = -num + 1; > end;
Right… now… out of curiosity… what happen when you do the following: update or replace numbers set num=num+1; Note the 'or replace'. Did that 'update or replace' just managed to delete a row or two?!??!? Bug or feature? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users