Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.0.7
-
Fix Version/s: 10.0.8
-
Component/s: None
-
Labels:None
Description
The same CREATE statement works fine if a default db is selected. If a db is not selected, but it is specified in CREATE, the statement returns an error.
Note that:
- only happens with CONNECT
- the same applies to DROP TABLE
MariaDB [(none)]> CREATE TABLE `test`.`tdir`
-> (
-> DRIVE CHAR(2) NOT NULL,
-> PATH VARCHAR(256) NOT NULL,
-> FNAME VARCHAR(256) NOT NULL,
-> FTYPE CHAR(4) NOT NULL,
-> SIZE DOUBLE(12,0) NOT NULL FLAG=5,
-> MODIFIED DATETIME NOT NULL
-> )
-> ENGINE = CONNECT
-> TABLE_TYPE = DIR
-> FILE_NAME = '/tmp'
-> ;
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> USE `test`;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [test]> CREATE TABLE `test`.`tdir`
-> (
-> DRIVE CHAR(2) NOT NULL,
-> PATH VARCHAR(256) NOT NULL,
-> FNAME VARCHAR(256) NOT NULL,
-> FTYPE CHAR(4) NOT NULL,
-> SIZE DOUBLE(12,0) NOT NULL FLAG=5,
-> MODIFIED DATETIME NOT NULL
-> )
-> ENGINE = CONNECT
-> TABLE_TYPE = DIR
-> FILE_NAME = '/tmp'
-> ;
Query OK, 0 rows affected (0.09 sec)
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
as rev-3939