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

    XMLWordPrintable

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

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

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.