I created a table?with the Porter tokenizer: "CREATE VIRTUAL TABLE fts_translations USING fts3(name, tokenize=porter)"
Then I execute a select statement, which before?text substitution looks like this: SELECT [symbols].`id`, [symbols].`rid` FROM [symbols] ?INNER JOIN [symbol_translations] ON [symbol_translations].`symbol_id` = [symbols].`id` ?INNER JOIN [translations] ON [translations].`id` = [symbol_translations].`translation_id` ?INNER JOIN [fts_translations] ON [fts_translations].`docid` = [translations].`id` ?WHERE [fts_translations].`name` MATCH ?1 AND [translations].`locale_id` = ?2 When passing in "Actions1BP80" as the first argument (?1), the result contains three documents with the following values in the `name` column: "Actions1BP80", "Actions2BP80" and "ActionsAtoZBP80". While I expected the first, I didn't expect the other two. Why are they included in?the result? Thanks,G. Laubli
