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

ORDER BY in DIR CONNECT tables does not always work

    XMLWordPrintable

Details

    Description

      ORDER BY on 2 varchar columns of DIR CONNECT table shows error message
      "Can't find record ".

      create table t2 (
        fpath varchar(255) NOT NULL flag=1,
        fname varchar(255) NOT NULL flag=2,
        ftype varchar(255) NOT NULL flag=3,
        size double(12,0) NOT NULL flag=5
      )engine=CONNECT table_type=DIR file_name='/home/alice/Downloads/*' option_list='subdir=1'
      --------------
      Query OK, 0 rows affected (0.06 sec)
       
      --------------
      select * from t2
      --------------
      +------------------------+---------------------+-------+------+
      | fpath                  | fname               | ftype | size |
      +------------------------+---------------------+-------+------+
      | /home/alice/Downloads/ | Untitled Document 3 |       |    0 |
      | /home/alice/Downloads/ | Untitled Document 2 |       |    0 |
      | /home/alice/Downloads/ | Untitled Document   |       |    0 |
      +------------------------+---------------------+-------+------+
      3 rows in set (0.00 sec)
       
      --------------
      SELECT fname, ftype, size FROM t2 ORDER BY fname,ftype
      --------------
      ERROR 1032 (HY000) at line 15 in file: '/home/alice/t/c.sql': Can't find record in 't2'
      

      Attachments

        Issue Links

          Activity

            People

              bertrandop Olivier Bertrand
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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