How to fix error 1031 in MariaDB Connect Storage Engine when sorting a large table?

Question

MariaDB

Good afternoon, there is MariaDB with the Connect Storage Engine module installed, which, as it were, makes DBLINK to another database.
A third-party database created a database with an employees table ( https://github.com/datacharmer/test_db) with 300,000 records.
Mary's Connect storage engine successfully created a connection, however, when entering the data and trying to sort by any of the fields, it crashes with an error
SQL error (1031): Not supported by this table type
If this test database is imported into Maria's database itself (i.e. .do not take it through a module from another database), then everything is sorted successfully.
What can be wrong?
UPD : It turns out that with 30 rows of records it is similar, it seems that the matter is not in the number

Answer 1

well so SQL Error (1031): Not supported by this table type
make select ? rake it into memory and sort it there))
through the view it can work