Details

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

    Attachments

      Issue Links

        Activity

          anikitin Andrii Nikitin (Inactive) created issue -
          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.
          greenman Ian Gilfillan made changes -
          Field Original Value New Value
          Fix Version/s N/A [ 14700 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          GeoffMontee Geoff Montee (Inactive) made changes -
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 80621 ] MariaDB v4 [ 152097 ]

          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.