Re: [sqlite] possible join bug/regression with sqlite-3.8.1

2013-11-02 Thread Ferdinand Hübner
On Mon, Oct 28, 2013 at 9:44 PM, Richard Hipp wrote: > The fix for this problem has been checked in: > > http://www.sqlite.org/src/info/9aac4e588c > > This problem was actually introduced in 3.8.0 but it was unreachable until > some additional enhancements were added in 3.8.1. So 3.8.1 didn't

Re: [sqlite] possible join bug/regression with sqlite-3.8.1

2013-10-28 Thread Richard Hipp
On Sat, Oct 26, 2013 at 11:17 AM, Ferdinand Hübner < ferdinand.hueb...@gmail.com> wrote: > A query against the xbmc database doesn't return results anymore when > sqlite-3.8.1 is used. With sqlite-3.8.0.2, the query returns results > against the identical database just fine. > Confirming that the

Re: [sqlite] possible join bug/regression with sqlite-3.8.1

2013-10-26 Thread Ferdinand Hübner
On Sat, Oct 26, 2013 at 6:17 PM, Richard Hipp wrote: > > We are looking into the problem. > > Meanwhile, I noticed some rather egregious inefficiencies in the XBMC > schema and would like to contract the XBMC developers about this. I spent > 5 minutes clicking around on various XBMC websites tryi

Re: [sqlite] possible join bug/regression with sqlite-3.8.1

2013-10-26 Thread Richard Hipp
On Sat, Oct 26, 2013 at 11:17 AM, Ferdinand Hübner < ferdinand.hueb...@gmail.com> wrote: > > Please note that I'm just an xbmc user, not a developer. > We are looking into the problem. Meanwhile, I noticed some rather egregious inefficiencies in the XBMC schema and would like to contract the XBM

Re: [sqlite] possible join bug/regression with sqlite-3.8.1

2013-10-26 Thread Simon Slavin
On 26 Oct 2013, at 4:17pm, Ferdinand Hübner wrote: > If you need any more information, don't hesitate to ask. Ignoring the fact that two different versions of SQLite give different results, for a minute, can you answer these questions: Is one of these results clearly right and the other clear

[sqlite] possible join bug/regression with sqlite-3.8.1

2013-10-26 Thread Ferdinand Hübner
Hello, A query against the xbmc database doesn't return results anymore when sqlite-3.8.1 is used. With sqlite-3.8.0.2, the query returns results against the identical database just fine. Please note that I'm just an xbmc user, not a developer. It's been quite a while since I last posted to a mail