Re: [sqlite] Problem with FTS4 - Floating point error.

2011-10-25 Thread Mohd Radzi Ibrahim
On 25-Oct-2011, at 2:53 PM, Dan Kennedy wrote: > This was fixed and then I forgot to follow up here. I should have. > Sorry about that. It's fixed here: > > http://www.sqlite.org/src/ci/3126754c72?sbs=0 > > Either updating to the latest trunk or just applying the linked > patch to fts3.c

Re: [sqlite] Problem with FTS4 - Floating point error.

2011-10-25 Thread Dan Kennedy
On 10/25/2011 12:49 PM, Mohd Radzi Ibrahim wrote: On 18-Oct-2011, at 6:52 PM, Dan Kennedy wrote: On 10/18/2011 05:02 PM, Mohd Radzi Ibrahim wrote: Hi, This is my table schema: CREATE VIRTUAL TABLE LocationFTS using FTS4 ( name text, address text, email text,

Re: [sqlite] Problem with FTS4 - Floating point error.

2011-10-24 Thread Mohd Radzi Ibrahim
On 18-Oct-2011, at 6:52 PM, Dan Kennedy wrote: > > > On 10/18/2011 05:02 PM, Mohd Radzi Ibrahim wrote: >> Hi, >> >> This is my table schema: >> >> CREATE VIRTUAL TABLE LocationFTS using FTS4 >> ( >> name text, >> address text, >> email text, >> remark text, >> telno

Re: [sqlite] Problem with FTS4 - Floating point error.

2011-10-18 Thread Dan Kennedy
On 10/18/2011 05:02 PM, Mohd Radzi Ibrahim wrote: Hi, This is my table schema: CREATE VIRTUAL TABLE LocationFTS using FTS4 ( name text, address text, email text, remark text, telno text, contact text, isDeleted text ); This select

[sqlite] Problem with FTS4 - Floating point error.

2011-10-18 Thread Mohd Radzi Ibrahim
Hi, This is my table schema: CREATE VIRTUAL TABLE LocationFTS using FTS4 ( name text, address text, email text, remark text, telno text, contact text, isDeleted text ); This select statement gives floating point error in both