I am unsure about how the amatch extension works. According to the documentation, I believe that the SQL below should return at least one record, but it does not. No errors are reported either.
I compiled the shell executable with the 201304290917 draft amalgamation and today's amatch.c from Fossil trunk. Is there something I am missing? Ralf ------------------------ DROP TABLE IF EXISTS f; DROP TABLE IF EXISTS c; DROP TABLE IF EXISTS v; CREATE TABLE v (w TEXT, l INTEGER); CREATE INDEX v_index ON v(w); INSERT INTO v VALUES ('abc', 0); INSERT INTO v VALUES ('bcd', 0); INSERT INTO v VALUES ('def', 0); CREATE TABLE c(iLang INTEGER, cFrom TEXT, cTo TEXT, Cost INTEGER); INSERT INTO c VALUES(0, '', 'a', 100); INSERT INTO c VALUES(0, 'b', '', 87); INSERT INTO c VALUES(0, 'o', 'oe', 38); INSERT INTO c VALUES(0, 'oe', 'o', 40); INSERT INTO c VALUES(0, '?', '', 97); INSERT INTO c VALUES(0, '', '?', 98); INSERT INTO c VALUES(0, '?', '?', 99); CREATE VIRTUAL TABLE f USING approximate_match( vocabulary_table=v, vocabulary_word=w, vocabulary_language=l, edit_distances=c ); SELECT * FROM f WHERE word MATCH 'abc'; _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users