Re: [sqlite] spellfix1 is unable to match words beginning with 'Kn' and 'Gn'

[Richard Hipp]

On 10/20/16, Thomas David Baker  wrote:
> Is this the right list to report issues with the spellfix1 extension?
>
> Here's a complete repro case:

lowercase your vocabulary and it should work fine.  The special case
logic for unusual letter combinations like "kn" and "gn" only works
for lowercase letters.

>
> [deepthought ~] ls -l newdb
> ls: newdb: No such file or directory
> [deepthought ~] sqlite3 newdb
> SQLite version 3.14.2 2016-09-12 18:50:49
> Enter ".help" for usage hints.
> sqlite> SELECT LOAD_EXTENSION('spellfix1.dylib');
> sqlite> CREATE VIRTUAL TABLE IF NOT EXISTS fuzzy USING spellfix1;
> sqlite> INSERT INTO fuzzy (word) VALUES ('Knight');
> sqlite> SELECT word, distance FROM fuzzy WHERE word = 'Knight';
> Knight|
> sqlite> SELECT word, distance FROM fuzzy WHERE word MATCH 'Knight';
> sqlite> SELECT word, distance FROM fuzzy WHERE word MATCH 'Night';
> Knight|100
> sqlite>
>
> Is this something configurable? Is it a bug?
>
> Thanks!
>
> Tom
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


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

[sqlite] spellfix1 is unable to match words beginning with 'Kn' and 'Gn'

[Thomas David Baker]

Is this the right list to report issues with the spellfix1 extension?

Here's a complete repro case:

[deepthought ~] ls -l newdb
ls: newdb: No such file or directory
[deepthought ~] sqlite3 newdb
SQLite version 3.14.2 2016-09-12 18:50:49
Enter ".help" for usage hints.
sqlite> SELECT LOAD_EXTENSION('spellfix1.dylib');
sqlite> CREATE VIRTUAL TABLE IF NOT EXISTS fuzzy USING spellfix1;
sqlite> INSERT INTO fuzzy (word) VALUES ('Knight');
sqlite> SELECT word, distance FROM fuzzy WHERE word = 'Knight';
Knight|
sqlite> SELECT word, distance FROM fuzzy WHERE word MATCH 'Knight';
sqlite> SELECT word, distance FROM fuzzy WHERE word MATCH 'Night';
Knight|100
sqlite>

Is this something configurable? Is it a bug?

Thanks!

Tom
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users