SQLite.au3 and SQL 'MATCH' condition

[sshrum]

According to what I've read about SQlite, the'match' eval has been supported by SQLite since 2006-Oct-9, Version 3.3.8.

When I send a SQL statement with 'match' in it, I get a SQLite.au3 error back "unable to use function MATCH in the requested context".

Here is my SQL statement: Select * from metadata where Author MATCH "collins";

Nothing special...straight forward and on 1 table.

Any ideas why the SQLite.au3 is returning this error?

[PsaltyDS]

According to what I've read about SQlite, the'match' eval has been supported by SQLite since 2006-Oct-9, Version 3.3.8.

When I send a SQL statement with 'match' in it, I get a SQLite.au3 error back "unable to use function MATCH in the requested context".

Here is my SQL statement: Select * from metadata where Author MATCH "collins";

Nothing special...straight forward and on 1 table.

Any ideas why the SQLite.au3 is returning this error?

Are you sure that's available without "Full-text tables" and the fts1 "Full-text Search" module loaded?

Using fts1

Full-text tables store one or more columns of fully indexed text. You can create a full-text table using the CREATE VIRTUAL TABLE statement. For example, the following creates a table with columns name and ingredients:

sqlite>create virtual table recipe using fts1(name, ingredients);

You can insert rows into a full-text table in the same way as into an ordinary table with columns of type TEXT:

sqlite>insert into recipe (name, ingredients) values ('broccoli stew', 'broccoli peppers cheese tomatoes');

sqlite>insert into recipe (name, ingredients) values ('pumpkin stew', 'pumpkin onions garlic celery');

sqlite>insert into recipe (name, ingredients) values ('broccoli pie', 'broccoli cheese onions flour');

sqlite>insert into recipe (name, ingredients) values ('pumpkin pie', 'pumpkin sugar flour butter');

The MATCH operator performs a full-text match on a column in a full-text table:

sqlite> select rowid, name, ingredients from recipe where name match 'pie';

3|broccoli pie|broccoli cheese onions flour

4|pumpkin pie|pumpkin sugar flour butter

sqlite>

I don't know myself, I just Googled that up to see what the proper context for the MATCH operator was.