How to fix the «Base table or view not found: catalog_category_product_index_replica» Magento 2.2 bug?

bin/magento indexer:reindex:

Category Products indexer process unknown error:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘catalog_category_product_index_replica’ doesn’t exist, query was: DESCRIBE catalog_category_product_index_replica

Magento\Catalog\Model\Indexer\Category\Product\AbstractAction::getMainTable()

Magento\Catalog\Model\Indexer\Category\Product\Action\Full::getMainTable()

Magento\Catalog\Setup\UpgradeSchema::upgrade()

Magento\Catalog\Setup\UpgradeSchema::addReplicaTable()

How to fix

Step 1

UPDATE setup_module
SET schema_version = '2.1.99', data_version = '2.1.99'
WHERE 'Magento_Catalog' = `module` and '2.2.0' = schema_version and '2.2.0' = data_version;

Step 2

bin/magento setup:upgrade && bin/magento indexer:reindex

will this solution work for 2.3.3 . i have been getting following error when i attempt to run cron job manually.

SQLSTATE[42S02]: Base table or view not found: 1932 Table ‘dbperfixSrmdAuVe.catalog_product_index_price_replica’ doesn’t exist in engine, query was: TRUNCATE TABLE catalog_product_index_price_replica
Thanks