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

fuzzy error message on attempt to insert data in DIR type CONNECT engine

    XMLWordPrintable

Details

    Description

      Error message is "COLBLK SetBuffer: undefined Access Method" on attempt to insert data in a table of DIR type (CONNECT engine)

      create table t3 (
        fpath varchar(255) NOT NULL flag=1,
        fname varchar(255) NOT NULL flag=2
      )engine=CONNECT table_type=DIR file_name='/home/alice/Downloads/*' option_list='subdir=1'
      --------------
      Query OK, 0 rows affected (0.02 sec)
       
      --------------
      select * from t3
      --------------
      +------------------------+-------+
      | fpath                  | fname |
      +------------------------+-------+
      | /home/alice/Downloads/ | xx1   |
      | /home/alice/Downloads/ | xx1   |
      | /home/alice/Downloads/ | 1     |
      +------------------------+-------+
      3 rows in set (0.00 sec)
       
      --------------
      INSERT INTO t3 VALUES ("a","a")
      --------------
      ERROR 1296 (HY000) at line 25 in file: '/home/alice/t/c.sql': Got error 174 'COLBLK SetBuffer: undefined Access Method' from CONNECT
      

      Attachments

        Activity

          People

            bertrandop Olivier Bertrand
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.