Re: [sqlite] SQLite's FAIL ALGORITHM IN ONCONFLICT CLAUSE

2011-12-02 Thread Jay A. Kreibich
On Fri, Dec 02, 2011 at 12:44:53AM -0800, destiny12 scratched on the wall: > > I m facing some problem in execution of sqlite's fail algorithm. Its > definition says that it don't rollback changes made prior to encountering > constraint voilation and changes to that row where constraint voilation

Re: [sqlite] SQLite's FAIL ALGORITHM IN ONCONFLICT CLAUSE

2011-12-02 Thread Igor Tandetnik
destiny12 wrote: > I m facing some problem in execution of sqlite's fail algorithm. Its > definition says that it don't rollback changes made prior to encountering > constraint voilation and changes to that row where constraint voilation is > occured and beyond never

[sqlite] SQLite's FAIL ALGORITHM IN ONCONFLICT CLAUSE

2011-12-02 Thread destiny12
I m facing some problem in execution of sqlite's fail algorithm. Its definition says that it don't rollback changes made prior to encountering constraint voilation and changes to that row where constraint voilation is occured and beyond never occur. I executed it. But when I update values after