Re: [sqlite] fstat warning with SQLite 3.8.1 on Android

2014-01-09 Thread Sascha Sertel
On Wed, Jan 8, 2014 at 12:11 PM, Richard Hipp wrote: > On Tue, Jan 7, 2014 at 3:55 PM, Sascha Sertel >wrote: > > > Hello, > > > > > > I'm hoping someone has any ideas what to do about the error messages I'm > > getting from SQLite 3.8.1 when run

Re: [sqlite] fstat warning with SQLite 3.8.1 on Android

2014-01-08 Thread Richard Hipp
On Tue, Jan 7, 2014 at 3:55 PM, Sascha Sertel wrote: > Hello, > > > I'm hoping someone has any ideas what to do about the error messages I'm > getting from SQLite 3.8.1 when run on Android: > > > Getting warning: "cannot fstat db file " > > -- p

Re: [sqlite] fstat warning with SQLite 3.8.1 on Android

2014-01-08 Thread Sascha Sertel
gt;wrote: > > > Hello, > > > > > > I'm hoping someone has any ideas what to do about the error messages I'm > > getting from SQLite 3.8.1 when run on Android: > > > > > > Getting warning: "cannot fstat db file " > > > > -- please t

Re: [sqlite] fstat warning with SQLite 3.8.1 on Android

2014-01-07 Thread Richard Hipp
Can you turn on warning and error logging to get additional information: http://www.sqlite.org/errlog.html On Tue, Jan 7, 2014 at 3:55 PM, Sascha Sertel wrote: > Hello, > > > I'm hoping someone has any ideas what to do about the error messages I'm > getting from

[sqlite] fstat warning with SQLite 3.8.1 on Android

2014-01-07 Thread Sascha Sertel
Hello, I'm hoping someone has any ideas what to do about the error messages I'm getting from SQLite 3.8.1 when run on Android: Getting warning: "cannot fstat db file " -- please take note that there is a blank inserted for the file name This is on Android 4.3 KitKat wi

[sqlite] JOIN failure in sqlite 3.8.1

2013-12-05 Thread Mark Brand
Hi, I noticed that some of my views were not working with sqlite 3.8.1. I managed to isolate the problem in the simple test case below. Then I discovered that the 3.8.2 pre-release seems to do it right. I suspect it was fixed along with https://www.sqlite.org/src/tktview?name=c620261b5b but I

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

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 l

Re: [sqlite] 3.8.1

2013-10-04 Thread Warren Young
On 10/4/2013 12:32, Peter Haworth wrote: I've seen emntion of version 3.8.1 of sqlite - is there a document somwhere that describes the changes? https://www.sqlite.org/draft/releaselog/current.html You could have found that link yourself from the SQLite download page, right next to the link t

Re: [sqlite] 3.8.1

2013-10-04 Thread Richard Hipp
On Fri, Oct 4, 2013 at 2:32 PM, Peter Haworth wrote: > I've seen emntion of version 3.8.1 of sqlite - is there a document somwhere > that describes the changes? > http://www.sqlite.org/draft/releaselog/current.html -- D. Richard Hipp d...@sqlite.org

[sqlite] 3.8.1

2013-10-04 Thread Peter Haworth
I've seen emntion of version 3.8.1 of sqlite - is there a document somwhere that describes the changes? Thanks, Pete lcSQL Software ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinf