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

CONNECT VIR tables return inconsistent error for UPDATE

    XMLWordPrintable

    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

            People

            Assignee:
            bertrandop Olivier Bertrand
            Reporter:
            f_razzoli Federico Razzoli
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration