Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.2(EOL)
    • N/A
    • Documentation
    • None

    Attachments

      Issue Links

        Activity

          greenman Ian Gilfillan added a comment -

          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)
          

          greenman Ian Gilfillan added a comment - 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.

          anikitin Andrii Nikitin (Inactive) added a comment - 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.
          greenman Ian Gilfillan added a comment -

          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.

          greenman Ian Gilfillan added a comment - 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.

          People

            greenman Ian Gilfillan
            anikitin Andrii Nikitin (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.