Confusing error "is not real-time or percolate"

[sanikolaev]

Bug Description:

When performing the following query against a plain table I got:

mysql> select * from idx where match('abcef') option fuzzy=1;
ERROR 1064 (42000): table 'idx' is not real-time or percolate

It's confusing, because:

• it's not clear why I can't perform this query against a plain table
• why it mentions "percolate"

Manticore Search Version:

Manticore 6.3.7 bedf3c9d0@24111812 dev (columnar 2.3.1 30ad2d6@24100914) (secondary 2.3.1 30ad2d6@24100914) (knn 2.3.1 30ad2d6@24100914)

Operating System Version:

macos

Have you tried the latest development version?

Yes

Internal Checklist:

^{To be completed by the assignee. Check off tasks that have been completed or are not applicable.}

- [ ] Implementation completed - [ ] Tests developed - [ ] Documentation updated - [ ] Documentation reviewed - [ ] Changelog updated

[sanikolaev]

As discussed, instead of fixing the error let's just use show table NAME settings instead of show create table. It should enable fuzzy search for plain tables.