Re: [sqlite] inserted row isn't deleted after rollback?

2014-10-29 Thread Richard Hipp
On Wed, Oct 29, 2014 at 6:35 AM, d...@gmx.com wrote: > Hello! > > I have met the situation, which looks like sqlit3 bug. The full script > can be found at [1]. To reproduce it, I just type: > > sqlite3 -batch /tmp/db-2.tmp < /tmp/x.sql > > Where /tmp/x.sql is the saved to disk

[sqlite] inserted row isn't deleted after rollback?

2014-10-29 Thread d...@gmx.com
Hello! I have met the situation, which looks like sqlit3 bug. The full script can be found at [1]. To reproduce it, I just type: sqlite3 -batch /tmp/db-2.tmp < /tmp/x.sql Where /tmp/x.sql is the saved to disk script [1]. So, the essential problem lies in the last lines: PRAGMA