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

ORDER BY in DIR CONNECT tables does not always work

    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

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

                Dates

                • Created:
                  Updated:
                  Resolved: