[sqlite] FTS5 "constraint failed"

2016-03-23 Thread Dan Kennedy
On 03/23/2016 12:06 AM, Domingo Alvarez Duarte wrote: > Hello ! > > After seeing several times work/commits on fts5 I decided to try it on a > table shown bellow, and when trying to populate it I get this error message: > > > sqlite> INSERT INTO fts_idx_items(fts_idx_items) VALUES('rebuild'); > Err

[sqlite] FTS5 "constraint failed"

2016-03-22 Thread Domingo Alvarez Duarte
22 2016 06:23:53 PM CET from "Dan Kennedy" > Subject: Re: [sqlite] FTS5 "constraint failed" > > On 03/23/2016 12:06 AM, Domingo Alvarez Duarte wrote: > >>Hello ! >> >> After seeing several times work/commits on fts5 I decided to try it on a &g

[sqlite] FTS5 "constraint failed"

2016-03-22 Thread Domingo Alvarez Duarte
? -ledit -ldl -lpthread -lm -Wl,-rpath -Wl,/usr/local/lib ? > Tue Mar 22 2016 06:06:55 PM CET from "Domingo Alvarez Duarte" > Subject: [sqlite] FTS5 "constraint failed" > > Hello ! > > After seeing several times work/commits on fts5 I decided to try it on a

[sqlite] FTS5 "constraint failed"

2016-03-22 Thread Domingo Alvarez Duarte
Hello ! After seeing several times work/commits on fts5 I decided to try it on a table shown bellow, and when trying to populate it I get this error message: sqlite> INSERT INTO fts_idx_items(fts_idx_items) VALUES('rebuild'); Error: constraint failed The table has 12,000,000 records and it