Why does INSERTing to a federatedx table fail silently?

Question

For testing, I've set up a XAMPP portable 8.1.12 with 10.4.27-MariaDB and enabled the FederatedX engine using this trick.

When I now set up a SERVER that is not existing and a federated table that is "using" that server, running a SELECT against that table fails as it should, but INSERT behaves as if it has worked. Why is that?

Example:

CREATE SERVER `nonexistentserver`
FOREIGN DATA WRAPPER `nonexistentserverwrapper`
OPTIONS (
    HOST '127.0.0.1',
    DATABASE 'thereIsNoServerSoThereIsNoDatabase', 
    USER 'andNoUser',
    PASSWORD 'AndNoPassword!',
    PORT 12345
);
CREATE TABLE mytable (
    theLine INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    theContent VARCHAR(255) NOT NULL
) ENGINE=FEDERATED CONNECTION='nonexistentserver/mytable';

SELECT behaves as I would expect:

MariaDB [testdb]> SELECT * FROM mytable;
ERROR 1296 (HY000): Got error 10000 'Error on remote system: 0: ' from FEDERATED

But INSERT does not:

MariaDB [testdb]> INSERT INTO mytable VALUES (NULL, "Hey!");
Query OK, 1 row affected (0.005 sec)

Is that a bug or is it supposed to do that?

Additum 1:

When I do not use install plugin federated soname 'ha_federatedx'; but remove the x first (inspiration from this answer plus comment), thus use the old federated but federatedX, the INSERT gives the expected error.

Why does INSERTing to a federatedx table fail silently?

0 Answers0