Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.10, 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
-
Windows 7
Description
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:
 |
create table employees ( |
last_name varchar(255) ) |
|
engine=CONNECT table_type=MYSQL |
connection='mysql://mysql:mysql@127.0.0.1:3306/employees/employees'; |
After this, I try to select data from created table, and everything nice
SELECT * FROM `connect_engine`.`employees`; |
but when I try also SORT
SELECT * FROM `connect_engine`.`employees` ORDER BY `last_name` ASC; |
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?