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

CONNECT VIR tables return inconsistent error for UPDATE

Details

    Description

      CONNECT tables of type VIRT are read-only. They return the same error for TRUNCATE, DELETE, INSERT statements, but a different error for UPDATE (same number, different message).

      MariaDB [test]> CREATE OR REPLACE TABLE numbers
          ->     ENGINE = CONNECT,
          ->     TABLE_TYPE = VIR,
          ->     BLOCK_SIZE = 3
          -> ;
      Query OK, 0 rows affected (0.005 sec)
       
      MariaDB [test]> TRUNCATE TABLE numbers;
      ERROR 1296 (HY000): Got error 174 'Virtual tables are read only' from CONNECT
      MariaDB [test]> DELETE FROM numbers WHERE n = 1;
      ERROR 1296 (HY000): Got error 174 'Virtual tables are read only' from CONNECT
      MariaDB [test]> INSERT INTO numbers (n) VALUES (1);
      ERROR 1296 (HY000): Got error 174 'Virtual tables are read only' from CONNECT
      MariaDB [test]> UPDATE numbers SET n = 10 WHERE n = 1;
      ERROR 1296 (HY000): Got error 174 'Table numbers invalid for update' from CONNECT
      

      Attachments

        Activity

          f_razzoli Federico Razzoli created issue -
          anel Anel Husakovic made changes -
          Field Original Value New Value
          Assignee Anel Husakovic [ anel ]
          anel Anel Husakovic made changes -
          Fix Version/s 10.4 [ 22408 ]
          anel Anel Husakovic made changes -
          Status Open [ 1 ] Confirmed [ 10101 ]
          anel Anel Husakovic made changes -
          Assignee Anel Husakovic [ anel ] Olivier Bertrand [ bertrandop ]
          Status Confirmed [ 10101 ] In Review [ 10002 ]
          alice Alice Sherepa made changes -
          alice Alice Sherepa made changes -
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 113076 ] MariaDB v4 [ 143771 ]
          anel Anel Husakovic made changes -
          Assignee Olivier Bertrand [ bertrandop ] Anel Husakovic [ anel ]
          anel Anel Husakovic made changes -
          Status In Review [ 10002 ] In Testing [ 10301 ]
          anel Anel Husakovic made changes -
          Status In Testing [ 10301 ] Stalled [ 10000 ]
          anel Anel Husakovic made changes -
          Status Stalled [ 10000 ] Open [ 1 ]
          anel Anel Husakovic made changes -
          Status Open [ 1 ] Confirmed [ 10101 ]
          anel Anel Husakovic made changes -
          Fix Version/s 10.4.25 [ 27510 ]
          Fix Version/s 10.5.16 [ 27508 ]
          Fix Version/s 10.6.8 [ 27506 ]
          Fix Version/s 10.7.4 [ 27504 ]
          Fix Version/s 10.8.3 [ 27502 ]
          Fix Version/s 10.9.1 [ 27114 ]
          Fix Version/s 10.4 [ 22408 ]
          Resolution Fixed [ 1 ]
          Status Confirmed [ 10101 ] Closed [ 6 ]

          People

            anel Anel Husakovic
            f_razzoli Federico Razzoli
            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.