Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5650

FLUSH FOR EXPORT: missing error if engine does not support it

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Not a Bug
        • Affects Version/s: 10.0.8
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None

          Description

          On MySQL 5.6:

          MySQL [test]> CREATE TABLE t (c INT) ENGINE=MyISAM;
Query OK, 0 rows affected (0.09 sec)

MySQL [test]> FLUSH TABLES t FOR EXPORT;
ERROR 1031 (HY000): Table storage engine for 't' doesn't have this option

          On MariaDB 10.0.8:

          MariaDB [test]> CREATE TABLE t (c INT) ENGINE=MyISAM;
Query OK, 0 rows affected (0.07 sec)

MariaDB [test]> FLUSH TABLES t FOR EXPORT;
Query OK, 0 rows affected (0.00 sec)

          If FOR EXPORT behaves like in MySQL, an error should be issued...

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                In MariaDB 10.0, MyISAM supports FLUSH .. FOR EXPORT.

                /*
                Storage engine supports table export using the
                FLUSH TABLE <table_list> FOR EXPORT statement
                (meaning, after this statement one can copy table files out of the
                datadir and later "import" (somehow) in another MariaDB instance)
                */

                Show
                elenst Elena Stepanova added a comment - In MariaDB 10.0, MyISAM supports FLUSH .. FOR EXPORT. /* Storage engine supports table export using the FLUSH TABLE <table_list> FOR EXPORT statement (meaning, after this statement one can copy table files out of the datadir and later "import" (somehow) in another MariaDB instance) */
                Hide
                Permalink
                serg Sergei Golubchik added a comment -

                I've amended the manual as well, it does not say that FLUSH …FOR EXPORT is InnoDB only.

                Show
                serg Sergei Golubchik added a comment - I've amended the manual as well, it does not say that FLUSH …FOR EXPORT is InnoDB only.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    f_razzoli Federico Razzoli
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: