Good day, I have installed MariaDB 10.3 on Windows OS, and on another port MySQL DB.
In MySQL I create simple database from example https://github.com/datacharmer/test_db ( load_employees.dump - only 30 row insert)
Next I use connect storage engine by next query:
After this, I try to select data from created table, and everything nice
but when I try also SORT
I get error: SQL (1031): Not supported by this table type
If I created this sample database and table in MariaDB (not in external database with connect engine) everything works and sorts.
And also if I was not created a varchar *field and an *int - also everything works and sorts by connect engine...
That is, what is the problem when sorting varchar fields in connect storage engine?