"Index" column in SHOW TABLES is gone

TomW · July 7, 2025, 5:23pm

The time has finally arrived for me to upgrade from v3.1.1.

So far I noticed one incompatibility with the fine yii2-sphinx client library and I’m not sure the right approach to fixing it.

SHOW TBALES used to say

+-------+-------+
| Index | Type  |
+-------+-------+
| amf   | local |
+-------+-------+

But now it says

+-------+-------+
| Table | Type  |
+-------+-------+
| amf   | local |
+-------+-------+

Which unsurprisingly causes an error in client code that interrogates the schema like this:

github.com/yiisoft/yii2-sphinx

src/Schema.php

master


      
          
          /**
           * Initializes information about name and type of all index in the Sphinx.
           */
          protected function initIndexesInfo()
          {
              $this->_indexNames = [];
              $this->_indexTypes = [];
              $indexes = $this->findIndexes();
              foreach ($indexes as $index) {
                  $indexName = $index['Index'];
                  $this->_indexNames[] = $indexName;
                  $this->_indexTypes[$indexName] = $index['Type'];
              }
          }
          
          /**
           * Returns all index names in the Sphinx.
           * @return array all index names in the Sphinx.
           */
          protected function findIndexes()

It shouldn’t be hard to hack a patch for yii2-sphinx, e.g. change that line to $indexName = $index['Table'] ?? $index['Index']; but I wonder if that’s most appropriate. e.g. is there a compatibility mode in searchd configs? (Is this difference even in searchd or written into the indexes?) What would you the expert do?

And if I’m going to prepare a PR for yii2-sphinx is there a handy list of known backwards incompatible changes somewhere?

tomat · July 8, 2025, 7:06am

index > table replacement was done long time ago and there is no config option to turn conversion back

You have to fix your client for the new column names or use any of the officials client we provide Repository search results · GitHub there no such issue

tomat · July 8, 2025, 7:08am

We has such list for version ManticoreSearch-3.0 however since when we do not keep it and do not track changes since Sphinx anymore.

TomW · July 8, 2025, 11:52am

Thanks, Stas. I will submit a PR for yii2-sphinx with testing against MS 10. I can’t complete without help for a couple of things so we will see how much interest there is in it going forwards.

yii2-sphinx is unusual in that it has features that fit nicely in the Yii Framework, like query builder, Active Record, and a data provider with familiar APIs.

My own work uses only the query builder and it looks like the Manticore PHP client would be just as convenient.

If people want the high-level Yii Framework APIs for Manticore going forwards it’s likely better to build them on top of the Manticore PHP client rather than on top of SQL.