On 08/29/2013 10:47 PM, Marc L. Allen wrote:
Silly question.. I looked at the fix. Why ignore indexes with greater than 4
fields? Isn't that a bit risky? Wouldn't it be better to ignore the fields
after the 4th one for planning?
SQLite 3.8.0 really contains two query planners. The first
(in function whereShortcut()) is very fast but only handles
simple cases. The second takes longer to run but handles much
more complicated queries. So, to speed up sqlite3_prepare_v2(),
SQLite tries to use the first planner as much as possible.
The change just has the first planner ignore such indexes. Any
cases that can benefit from using a primary key or unique index
will be handled by the second planner.
-----Original Message-----
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Richard Hipp
Sent: Thursday, August 29, 2013 11:38 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] segmentation fault with 3.8.0
On Thu, Aug 29, 2013 at 11:32 AM, Stephen Chrzanowski
<pontia...@gmail.com>wrote:
My guess is single quotes instead of double quotes. Where exactly is
the seg fault? Untested but other than the quotes, everything looks fine.
The problem is described here: http://www.sqlite.org/src/info/9f2eb3abac
The fix is here: http://www.sqlite.org/src/info/c1152bdcbb
A patch release 3.8.0.1 that includes this fix and fixes for two other equally
obscure corner cases is currently in test and is expected to go out later today.
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
This email and any attachments are only for use by the intended recipient(s)
and may contain legally privileged, confidential, proprietary or otherwise
private information. Any unauthorized use, reproduction, dissemination,
distribution or other disclosure of the contents of this e-mail or its
attachments is strictly prohibited. If you have received this email in error,
please notify the sender immediately and delete the original.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
