[sqlite] Best way to terminate a dead-transaction: commit or rollback?

2016-01-15 Thread Olivier Mascia
> Le 15 janv. 2016 ? 19:13, James K. Lowden a > ?crit : > >> Let a transaction (started with BEGIN TRANSACTION) which did only >> reads. Is it any better to end it by COMMIT TRANSACTION or ROLLBACK >> TRANSACTION, or is it completely insignificant? > > Why not do the right thing and remove the

[sqlite] Best way to terminate a dead-transaction: commit or rollback?

2016-01-15 Thread Dominique Devienne
On Fri, Jan 15, 2016 at 7:25 PM, Keith Medcalf wrote: > While it is true that without further action each statement is carried out > in a separate transaction, it may very well be that the OP wants to have > what is called Repeatable-Read. The only way to obtain Repeatable-Read > between stateme

[sqlite] Best way to terminate a dead-transaction: commit or rollback?

2016-01-15 Thread James K. Lowden
On Fri, 15 Jan 2016 20:39:15 +0100 Olivier Mascia wrote: > write transactions committed after the read transaction began, are > not seen by that read transaction. Allowing it to have a stable view > on the whole database. As Keith correctly surmised, you need repeatable read. Never having had

[sqlite] Best way to terminate a dead-transaction: commit or rollback?

2016-01-15 Thread James K. Lowden
On Thu, 14 Jan 2016 16:54:04 +0100 Olivier Mascia wrote: > Let a transaction (started with BEGIN TRANSACTION) which did only > reads. Is it any better to end it by COMMIT TRANSACTION or ROLLBACK > TRANSACTION, or is it completely insignificant? Why not do the right thing and remove the begin & c

[sqlite] Best way to terminate a dead-transaction: commit or rollback?

2016-01-15 Thread Keith Medcalf
On Friday, 15 January, 2016 11:14, James K. Lowden , > On Thu, 14 Jan 2016 16:54:04 +0100 Olivier Mascia wrote: > > Let a transaction (started with BEGIN TRANSACTION) which did only > > reads. Is it any better to end it by COMMIT TRANSACTION or ROLLBACK > > TRANSACTION, or is it completely insig

[sqlite] Best way to terminate a dead-transaction: commit or rollback?

2016-01-14 Thread R Smith
On 2016/01/14 5:54 PM, Olivier Mascia wrote: > Hello, > > Let a transaction (started with BEGIN TRANSACTION) which did only reads. > Is it any better to end it by COMMIT TRANSACTION or ROLLBACK TRANSACTION, or > is it completely insignificant? > Those two statements do very different things, bu

[sqlite] Best way to terminate a dead-transaction: commit or rollback?

2016-01-14 Thread Olivier Mascia
Hello, Let a transaction (started with BEGIN TRANSACTION) which did only reads. Is it any better to end it by COMMIT TRANSACTION or ROLLBACK TRANSACTION, or is it completely insignificant? -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om