This is a class of problems I started seeing around 3.8.x. Any insights
would be much appreciated. Sometimes it happens when there are more than a
few INNER JOINS, others, in the case, happen when I ORDER BY the virtual
table's docid. I feel like this used to work.
SQLite version 3.8.2 2013-12-06 14:53:30
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> CREATE VIRTUAL TABLE Terms USING fts3 (term)
> ...> ;
> sqlite> INSERT INTO Terms VALUES ('hello tim');
> sqlite> INSERT INTO Terms VALUES ('goodbye tim');
> sqlite> CREATE TEMP TABLE Combos (combo);
> sqlite> INSERT INTO Combos VALUES ('hello');
> sqlite> SELECT * FROM Terms t INNER JOIN Combos c ON t.term MATCH c.combo;
> hello tim|hello
> sqlite> SELECT * FROM Terms t INNER JOIN Combos c ON t.term MATCH c.combo
> ORDER BY t.docid;
> Error: unable to use function MATCH in the requested context
> sqlite>
I know ordering by t.docid is probably redundant, but it is an example of
the issue I'm encountering. This is an issue in 3.8.0 also. The last time
it worked was 3.7.17
SQLite version 3.7.17 2013-05-20 00:56:22
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> CREATE VIRTUAL TABLE Terms USING fts3 (term)
> ...> ;
> sqlite> INSERT INTO Terms VALUES ('hello tim');
> sqlite> INSERT INTO Terms VALUES ('goodbye tim');
> sqlite> CREATE TEMP TABLE Combos (combo);
> sqlite> INSERT INTO Combos VALUES ('hello');
> sqlite> SELECT * FROM Terms t INNER JOIN Combos c ON t.term MATCH c.combo;
> hello tim|hello
> sqlite> SELECT * FROM Terms t INNER JOIN Combos c ON t.term MATCH c.combo
> ORDER
> BY t.docid;
> hello tim|hello
> sqlite>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
