TRUNCATE TABLE on distributed

[donhardman]

Bug Description:

We support DELETE operations on distributed tables, while TRUNCATE is not supported. It should be relatively easy to implement TRUNCATE, and we should add support for it.

MRE:

mysql> create table dist type='distributed' local='test';
mysql> truncate table dist;
ERROR 1064 (42000): TRUNCATE RTINDEX requires an existing RT table
mysql> delete from dist where id > 0;
mysql>

Manticore Search Version:

Latest dev version

Operating System Version:

Ubuntu Jammy

Have you tried the latest development version?

None

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