On Sat, Jul 21, 2012 at 2:05 PM, AJ ONeal <coola...@gmail.com> wrote:

> According do
> http://www.sqlite.org/fts3.html#matchinfo
>
> sqlite3 test.sqlite3
>
> CREATE VIRTUAL TABLE t1 USING fts4(a, b);
> INSERT INTO t1 VALUES('transaction default models default', 'Non
> transaction reads');
> INSERT INTO t1 VALUES('the default transaction', 'these semantics
> present');
> INSERT INTO t1 VALUES('single request', 'default data');
>
> SELECT matchinfo(t1) FROM t1 WHERE t1 MATCH 'default transaction "these
> semantics"';
>

matchinfo returns a blob.  Try running "hex(matchinfo(t1))" so that you can
see the blob content.


>
> Should result in:
>
> 3 2  1 3 2  0 1 1  1 2 2  0 1 1  0 0 0  1 1 1
>
> However, I get back an empty string.
>
> SELECT matchinfo(t1, 'ns') FROM t1 WHERE t1 MATCH 'default transaction';
>
> returns two empty strings
>
> sqlite3 --version
> 3.7.13 2012-06-11 02:05:22 f5b5a13f7394dc143aa136f1d4faba6839eaa6dc
>
> AJ ONeal
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to