Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-4036

ROCKSDB table creation accepts INNODB tablespace.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Done
    • Affects Version/s: 5.7.19-17
    • Fix Version/s: 5.7.20-18
    • Component/s: MyRocks
    • Labels:
      None

      Description

      RocksDB does not support CREATE/ALTER TABLESPACE command. But ROCKSDB table creation accepts INNODB tablespace. Could you please confirm whether it is default behaviour or not? 

      Please find the attached testcase.

      PS : Default storage engine is ROCKSDB with this testcase.

      mysql> CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' ;
      ERROR 1478 (HY000): Table storage engine 'ROCKSDB' does not support the create option 'TABLESPACE or LOGFILE GROUP'
      mysql> CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' engine=innodb;
      Query OK, 0 rows affected (3.34 sec)
      mysql> ALTER TABLESPACE ts1 ADD DATAFILE 'ts2.ibd';
      ERROR 1478 (HY000): Table storage engine 'ROCKSDB' does not support the create option 'TABLESPACE or LOGFILE GROUP'
      mysql>
      mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY) TABLESPACE ts1 ;
      Query OK, 0 rows affected (3.72 sec)
      mysql> show create table t1\G
      *************************** 1. row ***************************
      Table: t1
      Create Table: CREATE TABLE `t1` (
      `c1` int(11) NOT NULL,
      PRIMARY KEY (`c1`)
      ) /*!50100 TABLESPACE `ts1` */ ENGINE=ROCKSDB DEFAULT CHARSET=utf8
      1 row in set (0.15 sec)
      mysql>
      

       

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  george.lorch George Lorch
                  Reporter:
                  ramesh.sivaraman Ramesh Sivaraman
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: