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/'
|
|