Re: [sqlite] segmentation fault with 3.8.0

2013-08-29 Thread kenichi ishigaki
mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp > Sent: Thursday, August 29, 2013 11:58 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] segmentation fault with 3.8.0 > > On Thu, Aug 29, 2013 at 11:47 AM, Marc L. Allen <mlal...@outsitenetworks.co

Re: [sqlite] segmentation fault with 3.8.0

2013-08-29 Thread Marc L. Allen
Database Subject: Re: [sqlite] segmentation fault with 3.8.0 On Thu, Aug 29, 2013 at 11:47 AM, Marc L. Allen <mlal...@outsitenetworks.com > 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

Re: [sqlite] segmentation fault with 3.8.0

2013-08-29 Thread Dan Kennedy
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

Re: [sqlite] segmentation fault with 3.8.0

2013-08-29 Thread Richard Hipp
On Thu, Aug 29, 2013 at 11:47 AM, 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? > The

Re: [sqlite] segmentation fault with 3.8.0

2013-08-29 Thread Marc L. Allen
] 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 doub

Re: [sqlite] segmentation fault with 3.8.0

2013-08-29 Thread Richard Hipp
On Thu, Aug 29, 2013 at 11:38 AM, Richard Hipp wrote: > > > 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. > > Complete set of diffs for the proposed patch

Re: [sqlite] segmentation fault with 3.8.0

2013-08-29 Thread Richard Hipp
On Thu, Aug 29, 2013 at 11:32 AM, Stephen Chrzanowski 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:

Re: [sqlite] segmentation fault with 3.8.0

2013-08-29 Thread Stephen Chrzanowski
My guess is single quotes instead of double quotes. Where exactly is the seg fault? Untested but other than the quotes, everything looks fine. On Thu, Aug 29, 2013 at 4:07 AM, kenichi ishigaki <kishig...@gmail.com>wrote: > Hi. I've just got a segmentation fault report with SQLite 3

[sqlite] segmentation fault with 3.8.0

2013-08-29 Thread kenichi ishigaki
Hi. I've just got a segmentation fault report with SQLite 3.8.0 from one of the perl binding users. The following set of SQL statements should reporduce the issue. Regards, Kenichi Ishigaki CREATE TABLE "twokeys" ( "artist" integer NOT NULL, "cd" integer NOT NU