Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.11
-
None
Description
The following testcase will pass before MDEV-5215:
--let $SOCKET=`SELECT @@global.socket`
|
--source include/have_innodb.inc
|
INSTALL PLUGIN Spider SONAME 'ha_spider.so'; |
CREATE USER u@localhost IDENTIFIED BY 'a'; |
eval CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET "$SOCKET",DATABASE 'test',user 'u',PASSWORD 'a'); |
CREATE TABLE ti (c INT) ENGINE=InnoDB; |
CREATE TABLE ts ENGINE=Spider COMMENT='WRAPPER "mysql", srv "srv", TABLE "ti"'; |
But not afterwards, yielding:
10.11.1 b4e7803a6f4c734fc5f06a0b0d78285510ae0f48 |
mysqltest: At line 7: query 'CREATE TABLE ts ENGINE=Spider COMMENT='WRAPPER "mysql", srv "srv", TABLE "ti"'' failed: ER_DBACCESS_DENIED_ERROR (1044): Access denied for user 'u'@'localhost' to database 'test'
|
Adding:
GRANT ALL ON test.* TO u@localhost; |
Directly after the user creation fixes the test on 10.11.
The same happens for Federated. Testcase (with GRANT present for convenience but commented):
--let $SOCKET= `SELECT @@global.socket`
|
--source include/have_innodb.inc
|
INSTALL SONAME 'ha_federatedx.so'; |
CREATE USER u@localhost IDENTIFIED BY 'a'; |
#GRANT ALL ON test.* TO u@localhost; |
eval CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET "$SOCKET",DATABASE 'test',user 'u',PASSWORD 'a'); |
CREATE TABLE ti (c INT) ENGINE=InnoDB; |
CREATE TABLE tf CONNECTION='srv/ti' ENGINE=FEDERATED; |
Attachments
Issue Links
- is caused by
-
MDEV-5215 Granted to PUBLIC
- Closed