[MDEV-12702] CREATE TABLESPACE in 10.2 Created: 2017-05-05  Updated: 2019-04-19  Resolved: 2017-06-06

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: 10.2
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Andrii Nikitin (Inactive) Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-19294 Remove TABLESPACE-related commands Closed

 Description   

This page shall be adjusted in 10.2:

https://mariadb.com/kb/en/mariadb/create-tablespace

according to:
https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html#create-tablespace-innodb-examples



 Comments   
Comment by Ian Gilfillan [ 2017-06-06 ]

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)

Comment by Andrii Nikitin (Inactive) [ 2017-06-06 ]

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.

Comment by Ian Gilfillan [ 2017-06-06 ]

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.

Generated at Thu Feb 08 07:59:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.