Re: [sqlite] Row is not fetched with PRAGMA reverse_unordered_selects=true

2019-05-09 Thread Manuel Rigger
Hi E. Pasma, Thanks for your interest in this! The test case failed on trunk, after the previous bug that you are referring to was fixed. It seems that the bug I newly reported has been fixed in https://www.sqlite.org/src/info/ebe4845cd0ffb96b. In order to trigger it, this more complex (and admitt

Re: [sqlite] Row is not fetched with PRAGMA reverse_unordered_selects=true

2019-05-09 Thread E.Pasma
> Op 9 mei 2019, om 00:07 heeft Manuel Rigger het > volgende geschreven: > Hi, > > I discovered another bug that is triggered when "PRAGMA > reverse_unordered_selects=true" is used. It's similar to a previous bug > that I reported [1], but the statement triggering the bug has a compound > expre

[sqlite] Row is not fetched with PRAGMA reverse_unordered_selects=true

2019-05-08 Thread Manuel Rigger
Hi, I discovered another bug that is triggered when "PRAGMA reverse_unordered_selects=true" is used. It's similar to a previous bug that I reported [1], but the statement triggering the bug has a compound expression that should always be true (for values that are not NULL) in the WHERE clause: CR