[sqlite] DELETE can fail with reverse_unordered_selects = true

2016-04-09 Thread Richard Hipp
On 4/9/16, Richard Hipp wrote: > On 4/9/16, Bradley Grainger wrote: >> In some circumstances "DELETE FROM x WHERE col = val" may fail to delete >> all >> rows if "PRAGMA reverse_unordered_selects = true;" has been executed. >> > > https://sqlite.org/src/info/a306e56ff68b8fa5 Should be fixed now

[sqlite] DELETE can fail with reverse_unordered_selects = true

2016-04-09 Thread Bradley Grainger
In some circumstances "DELETE FROM x WHERE col = val" may fail to delete all rows?if?"PRAGMA reverse_unordered_selects = true;" has been executed. Steps to repro: Open the test DB (https://downloads.logoscdn.com/temp/test.db 40KB)?with SQLite 3.12.1 Run: pragma reverse_unordered_selects =

[sqlite] DELETE can fail with reverse_unordered_selects = true

2016-04-09 Thread Richard Hipp
On 4/9/16, Bradley Grainger wrote: > In some circumstances "DELETE FROM x WHERE col = val" may fail to delete all > rows if "PRAGMA reverse_unordered_selects = true;" has been executed. > https://sqlite.org/src/info/a306e56ff68b8fa5 -- D. Richard Hipp drh at sqlite.org