Are these statements supposed to work in MariaDB 10.2?
SELECT VERSION();
|
+----------------+
|
| VERSION() |
|
+----------------+
|
| 10.2.6-MariaDB |
|
+----------------+
|
1 row in set (0.00 sec)
|
|
|
mysql [localhost] {msandbox} (test) > CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' ENGINE=INNODB;
|
Query OK, 0 rows affected, 1 warning (0.00 sec)
|
|
|
mysql [localhost] {msandbox} (test) > SHOW WARNINGS;
|
+---------+------+------------------------------------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+------------------------------------------------------------------------------------------------+
|
| Warning | 1478 | Table storage engine 'InnoDB' does not support the create option 'TABLESPACE or LOGFILE GROUP' |
|
+---------+------+------------------------------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
Yes, that is the point. The page https://mariadb.com/kb/en/mariadb/create-tablespace says 'command is only used in MySQL Cluster' , which is not true anymore since 5.7 . So probably we should explicitly confirm that MariaDB doesn't support the command in InnoDB as well.
Oh I see, I misunderstood this to mean it was to be supported in MariaDB, but kept looking for a trace of them and couldn't find anything 
I've updated the docs to say that this works in MySQL 5.7, but not in MariaDB.