Details
-
Bug
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Fixed
-
10.5.5
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
Field | Original Value | New Value |
---|---|---|
Assignee | Anel Husakovic [ anel ] |
Fix Version/s | 10.4 [ 22408 ] |
Status | Open [ 1 ] | Confirmed [ 10101 ] |
Assignee | Anel Husakovic [ anel ] | Olivier Bertrand [ bertrandop ] |
Status | Confirmed [ 10101 ] | In Review [ 10002 ] |
Link |
This issue relates to |
Link |
This issue relates to |
Workflow | MariaDB v3 [ 113076 ] | MariaDB v4 [ 143771 ] |
Assignee | Olivier Bertrand [ bertrandop ] | Anel Husakovic [ anel ] |
Status | In Review [ 10002 ] | In Testing [ 10301 ] |
Status | In Testing [ 10301 ] | Stalled [ 10000 ] |
Status | Stalled [ 10000 ] | Open [ 1 ] |
Status | Open [ 1 ] | Confirmed [ 10101 ] |
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 ] |