pardom-zz / ActiveAndroid

Active record style SQLite persistence for Android
http://www.activeandroid.com
4.7k stars 1.03k forks source link

fts not work properly #489

Open yeganehaym opened 8 years ago

yeganehaym commented 8 years ago

i have a fts model an when i get query doesn't results SELECT * FROM poems INNER JOIN rhyme_fts ON poems.id=rhyme_fts.poem_id WHERE rhyme_fts.group_id=? AND rhyme_fts.rhyme_text MATCH '*طاهر' i removed fts property and used like statement instead of match and worked but i want fts speed i used fts of active android before and worked properly but i dont know why no working now

this is my fts model


@Table(name="rhyme_fts",fts = "4")
public class RhymeFts extends Model {

    public static String TableName="rhyme_fts";
    public static String PoemColumn="poem_id";
    public static String GroupColumn="group_id";
    public static String RhymeColumn="rhyme_id";
    public static String RhymeTextColumn="rhyme_text";

    @Column(name = "group_id")
    private long groupId;
    @Column(name = "rhyme_id")
    private long rhymeId;
    @Column(name = "poem_id")
    private long poemId;
    @Column(name = "rhyme_text",length = 200)
    private String rhymeText;

    public long getGroupId() {
        return groupId;
    }

    public void setGroupId(long groupId) {
        this.groupId = groupId;
    }

    public long getRhymeId() {
        return rhymeId;
    }

    public void setRhymeId(long rhymeId) {
        this.rhymeId = rhymeId;
    }

    public long getPoemId() {
        return poemId;
    }

    public void setPoemId(long poemId) {
        this.poemId = poemId;
    }

    public String getRhymeText() {
        return rhymeText;
    }

    public void setRhymeText(String rhymeText) {
        this.rhymeText = rhymeText;
    }
}