[sqlite] sqlite 3.22.0 walro2 test failures on ppc64

2018-02-04 Thread Petr Kubat
Hi all, hitting some failures when building 3.22.0 on ppc64 boxes (both big-endian and little-endian) running Fedora Rawhide (full logs in [1][2]): Time: walro.test 135 ms ! walro2-1.3.2.2 expected: [0 32768] ! walro2-1.3.2.2 got: [0 65536] ! walro2-1.3.3.0 expected: [4224 32768] ! walro2

Re: [sqlite] fts5 giving results for substring searches for Hindi content.

2018-02-04 Thread Clemens Ladisch
raj Singla wrote: > create virtual table idx4 using "fts4" (content); > create virtual table idx5 using "fts5" (content); > ... > select * from idx4 where idx4 match 'पाकि';-- no results returned > select * from idx5 where idx5 match 'पाकि';-- returns नीरजा भनोट के FTS4 and FTS5 have different def

[sqlite] fts5 giving results for substring searches for Hindi content.

2018-02-04 Thread raj Singla
Hi, -- create fts4 and fts5 tables create virtual table idx4 using "fts4" (content); create virtual table idx5 using "fts5" (content); -- insert 1 sample rows into eachinsert into idx4 (content) values ('नीरजा भनोट के कातिल पाकिस्तान की जेल में थे, फिर वे एफबीआई आए?');insert into idx5 (content) va