Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17461

SQL (1031): Not supported by this table type - when try sort field from table by Connect storage engine

    Details

      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?

        Attachments

          Activity

            People

            • Assignee:
              bertrandop Olivier Bertrand
              Reporter:
              strelkovandreyvalerievich Strelkov Andrey
            • Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: