Different error on insert for distributed table or missing table

[donhardman]

Proposal:

Currently, when a table does not exist or it does not support inserts, we have the following error:

table 'hello2' absent, or does not support INSERT

Unfortunately, we now use Buddy to support auto-schema inserts and distributed inserts, but this makes it impossible to detect which table we're performing inserts on.

Therefore, we should split the error message into two distinct messages:

For missing tables:

table 'test' absent

For distributed tables:

table `test` does not support INSERT

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
• OpenAPI YAML updated and issue created to rebuild clients

[sanikolaev]

This issue blocks manticoresoftware/manticoresearch-buddy#392

[tomatolog]

fixed at b7992be

Now insert into missed table generates error table 'test' absent if the table is not RT or Percolate the error is table test does not support INSERT.

Not sure does this ticket need the test cases and what cases should be covered.

[PavelShilin89]

@donhardman @tomatolog The test is created in this PR - #2809 but at the moment the errors are not as expected.
Current result:
For distributed tables - ERROR 1064 (42000) at line 1: table 'dist_table' absent
For missing tables - no error

[tomatolog]

I will check the case at the test/clt-tests/core/test-errors-insert-for-distributed-missing-table.rec as daemon seems generate wrong error message

[tomatolog]

seems the case that table is distributed is not covered by initial fix and fixed at 1e36108

Need to rerun the #2809 and make sure the error messages look good now or fix the test outputs

[PavelShilin89]

@sanikolaev Test updated in PR - #2809
Review and approval to merge with a master is required.