Re: [sqlite] R-tree query regression, in SQLite library on latest Mac OS X beta

[Jens Alfke]

> On Sep 11, 2014, at 1:44 AM, Tim Streater  wrote:
> 
> In OS X 10.9.4, the SQLite version in PHP is 3.7.7.1, for example.

Yes, as I already said, there are some open-source components not developed by 
Apple that embed their own copies of sqlite. But the really important copy of 
the library is the shared one in /usr/lib that is used by all Apple OS 
components and (nearly all) native apps.

Anyway, my point is just that (speaking from experience) it's not a simple 
matter for Apple to update the version of SQLite in its OS, contrary to what 
was asserted. I really hope they do, though; there may still be enough time for 
10.10.

—Jens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] R-tree query regression, in SQLite library on latest Mac OS X beta

[Tim Streater]

On 11 Sep 2014 at 00:50, Simon Slavin  wrote: 

> Don't worry too much about this.  In the last count of an OS X version I
> counted seven different copies of SQLite being used in various places,
> integrated into programs, or as libraries, or as the shell tool.  And these
> are not all the same version as one-another.  Apple considers each one of
> these separately and doesn't have to test every single use when only one is
> replaced.  So if you've been clear about which copy "the built-in SQLite
> library" is they can replace that one without having to retest everything else
> that uses SQLite.

In OS X 10.9.4, the SQLite version in PHP is 3.7.7.1, for example.

--
Cheers  --  Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] R-tree query regression, in SQLite library on latest Mac OS X beta

[Jens Alfke]

> On Sep 10, 2014, at 4:50 PM, Simon Slavin  wrote:
> 
> Don't worry too much about this.  In the last count of an OS X version I 
> counted seven different copies of SQLite being used in various places, 
> integrated into programs, or as libraries, or as the shell tool.  And these 
> are not all the same version as one-another.  Apple considers each one of 
> these separately and doesn't have to test every single use when only one is 
> replaced.  So if you've been clear about which copy "the built-in SQLite 
> library" is they can replace that one without having to retest everything 
> else that uses SQLite.

I'm sure there are multiple copies of SQLite inside OS X since there are a lot 
of low-level open source components not written by Apple, which probably link 
in their own copies. But the version in /usr/lib/libsqlite3.dylib is the one 
all Apple's software uses, and the one nearly all 3rd party apps use (because 
it's easier to, and they probably don't want to take the hit in code size for 
linking in their own copy), and the one used by Apple's Core Data framework.

I can say this with some degree of authority because I worked at Apple for 15 
years, six of those in the OS X group, although I left in 2007 so I'm not up to 
date with the way everything's currently built. But back then, if I'd built a 
custom copy of SQLite into my project, the integration team would have asked me 
some tough questions about why I wasn't using the shared system library.

(BTW, I just confirmed that the final iOS 8 release is still using 3.7.13, so 
it's safe.)

—Jens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] R-tree query regression, in SQLite library on latest Mac OS X beta

[Simon Slavin]

On 11 Sep 2014, at 12:35am, Jens Alfke  wrote:

> On Sep 10, 2014, at 4:28 PM, Simon Slavin  wrote:
> 
>> Please post a followup to your bugreport mentioning that /the SQLIte 
>> developers/ say that the bug is fixed in build 3.8.6.  Apple's report 
>> readers will notice it and note the easy fix.
> 
> I've just done so.

Good.  Thanks.

> It's not exactly an easy fix, though; SQLite is a core OS X system component, 
> used by a lot of OS services and Apple apps, so changing it late in the 
> release cycle isn't something they'd do lightly. Especially since there are a 
> lot of other changes in 3.8.6, not just this one bug-fix.

Don't worry too much about this.  In the last count of an OS X version I 
counted seven different copies of SQLite being used in various places, 
integrated into programs, or as libraries, or as the shell tool.  And these are 
not all the same version as one-another.  Apple considers each one of these 
separately and doesn't have to test every single use when only one is replaced. 
 So if you've been clear about which copy "the built-in SQLite library" is they 
can replace that one without having to retest everything else that uses SQLite.

Simon
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] R-tree query regression, in SQLite library on latest Mac OS X beta

[Jens Alfke]

> On Sep 10, 2014, at 4:28 PM, Simon Slavin  wrote:
> 
> Please post a followup to your bugreport mentioning that /the SQLIte 
> developers/ say that the bug is fixed in build 3.8.6.  Apple's report readers 
> will notice it and note the easy fix.

I've just done so. 

It's not exactly an easy fix, though; SQLite is a core OS X system component, 
used by a lot of OS services and Apple apps, so changing it late in the release 
cycle isn't something they'd do lightly. Especially since there are a lot of 
other changes in 3.8.6, not just this one bug-fix.

(My new worry is whether the final released version of iOS 8 has SQLite 3.8.5. 
It wasn't in beta 6, but that build is from over a month ago and Apple didn't 
release any subsequent builds to developers until the final build this week. I 
haven't tested it yet, but if it's got the bug then there's no hope of a fix 
until 8.0.1. Apps will just have to link in their own builds of SQLite as a 
workaround.)

—Jens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] R-tree query regression, in SQLite library on latest Mac OS X beta

[Simon Slavin]

On 11 Sep 2014, at 12:14am, Jens Alfke  wrote:

> I filed a bug report with Apple a few days ago

Please post a followup to your bugreport mentioning that /the SQLIte 
developers/ say that the bug is fixed in build 3.8.6.  Apple's report readers 
will notice it and note the easy fix.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] R-tree query regression, in SQLite library on latest Mac OS X beta

[Jens Alfke]

> On Sep 10, 2014, at 4:06 PM, Richard Hipp  wrote:
> 
> The problem was fixed in SQLite version 3.8.6 released on 2014-08-15.

Thanks for the confirmation! I hadn't caught the notice that the bug fix is in 
3.8.6; I must not have read far enough down the release notes.

I filed a bug report with Apple a few days ago and tried to impress on them 
that this is a serious problem. Hopefully they'll update. Unfortunately their 
bug tracking system is very opaque, so I probably won't know the answer until I 
get the final 10.10 release and run "sqlite --version".

—Jens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] R-tree query regression, in SQLite library on latest Mac OS X beta

[Richard Hipp]

On Wed, Sep 10, 2014 at 6:58 PM, Jens Alfke  wrote:

> I've run into an R-tree query regression in the latest beta of  Mac OS X
> 10.10. 
> I've got a test case in the form of a SQL file [2] that demonstrates my
> problem. I'm not 100% sure this is the same as the reported ticket, though.
> I'd appreciate it if someone could take a look and confirm whether I've run
> into the same problem.


It is the same problem.


> And if it is the same problem, then the question becomes when the fix will
> appear in a release. Hopefully in time for Apple to upgrade their SQLite
> library, otherwise R-tree queries are going to be broken in 10.10.
>

The problem was fixed in SQLite version 3.8.6 released on 2014-08-15.
Unfortunately, I cannot control when Apple will pull the fix downstream.


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users