'DELETE FROM t1' failed: 1296: Got error 174 'DBF file t1.dbf is corrupted' from CONNECT

connect.updelx                           w4 [ fail ]

        Test ended at 2021-06-17 05:54:43

CURRENT_TEST: connect.updelx

mysqltest: In included file "/home/mdborg/mariadb-server/storage/connect/mysql-test/connect/t/updelx.inc": 

included from /home/mdborg/mariadb-server/storage/connect/mysql-test/connect/t/updelx.test at line 66:

At line 1: query 'DELETE FROM t1' failed: 1296: Got error 174 'DBF file t1.dbf is corrupted' from CONNECT

The result from queries just before the failure was:

< snip >

id

7

8

10

DELETE FROM t1 WHERE id IN (7,10);

SELECT * FROM t1;

id      msg

8       updated

DELETE FROM t1 WHERE id = 8;

SELECT * FROM t1;

id      msg

DROP TABLE t1;

# DBF table

CREATE TABLE t1 (

id INT(4) KEY NOT NULL,

msg VARCHAR(16))

ENGINE=CONNECT TABLE_TYPE=DBF BLOCK_SIZE=12;

Warnings:

Warning 1105    No file name. Table will use t1.dbf

DELETE FROM t1;

More results from queries before failure can be found in /home/mdborg/build-mariadb-server/mysql-test/var/4/log/updelx.log

 - saving '/home/mdborg/build-mariadb-server/mysql-test/var/4/log/connect.updelx/' to '/home/mdborg/build-mariadb-server/mysql-test/var/log/connect.updelx/'

connect.grant                            w2 [ fail ]

        Test ended at 2021-06-17 05:54:38

CURRENT_TEST: connect.grant

/home/mdborg/build-mariadb-server/client/mysqltest: Error on delete of '/home/mdborg/build-mariadb-server/mysql-test/var/2/mysqld.1/data//test/t1.BIN' (Errcode: 2 "No such file or directory")

/home/mdborg/build-mariadb-server/client/mysqltest: Error on delete of '/home/mdborg/build-mariadb-server/mysql-test/var/2/mysqld.1/data//test/t1.CSV' (Errcode: 2 "No such file or directory")

mysqltest: In included file "/home/mdborg/mariadb-server/storage/connect/mysql-test/connect/t/grant.inc": 

included from /home/mdborg/mariadb-server/storage/connect/mysql-test/connect/t/grant.test at line 87:

At line 15: query 'DELETE FROM t1' failed: 1296: Got error 174 'DBF file t1.dbf is corrupted' from CONNECT

The result from queries just before the failure was:

< snip >

CREATE USER user@localhost;

GRANT ALL PRIVILEGES ON *.* TO user@localhost;

REVOKE FILE ON *.* FROM user@localhost;

connect user,localhost,user,,;

connection user;

SELECT user();

user()

user@localhost

CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=DBF;

Warnings:

Warning 1105    No file name. Table will use t1.dbf

INSERT INTO t1 VALUES (10);

SELECT * FROM t1;

a

10

UPDATE t1 SET a=20;

SELECT * FROM t1;

a

20

DELETE FROM t1;

More results from queries before failure can be found in /home/mdborg/build-mariadb-server/mysql-test/var/2/log/grant.log

 - saving '/home/mdborg/build-mariadb-server/mysql-test/var/2/log/connect.grant/' to '/home/mdborg/build-mariadb-server/mysql-test/var/log/connect.grant/'