Database::findFreeTable() does not work

Problem/Motivation

There is a problem with Drupal\search_api_db\Plugin\search_api\backend\Database.

If the default table name for a text table - i.e. search_api_db_[index_name]_text - is already taken in the database then Database::findFreeTable() will return e.g. search_api_db_[index_name]_text_1.

However, when indexing the items Database::indexItem() tries to compute the text table name by doing $text_table = $denormalized_table . '_text';. This does not match the previously generated table name. $denormalized_table is e.g. search_api_db_[index_name]_1 at this point.

So to summarize:
search_api_db_[index_name]_text_1 gets created.
search_api_db_[index_name]_1_text gets queried.

This makes the indexing fail completely.

Proposed resolution

Remaining tasks

User interface changes

API changes

Estimated Value and Story Points

This issue was identified as a Beta Blocker for Drupal 8. We sat down and figured out the value proposition and amount of work (story points) for this issue.

Value and Story points are in the scale of fibonacci. Our minimum is 1, our maximum is 21. The higher, the more value or work a certain issue has.

Value : 2
Story Points: 3