Re: [sqlite] Crash when querying a unique index containing 12 columns using sub-selects

2018-01-17 Thread Matthew Towler
Hi > I think it is now back to Matthew to come up with a new test case that > actually demonstrates his problem. I believe I stated in my earlier message that the example test code did not show the issue - apologies that you spent time re-proving this. What would really help me to achieve a

Re: [sqlite] Crash when querying a unique index containing 12 columns using sub-selects

2018-01-16 Thread Matthew Towler
Hello again, Thanks for the responses, here is some additional information. > Is it hanging, or is it crashing? Your statement of the problem is unclear > on this point. It depends on the version. 3.8.0 gives an access violation (a crash) the other versions I have tried hang, in that the call

[sqlite] Crash when querying a unique index containing 12 columns using sub-selects

2018-01-11 Thread Matthew Towler
Hi I believe I have found a bug in sqlite, which my tests show was introduced between versions 3.7.17 and 3.8.0 and remains present in all versions up to and including 3.21.0 (I have also tested 3.8.11, 3.9.3, 3.12.2 all of which hang. I believe it closely related to, and probably just a