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

Add VISIBLE attribute for indexes in CREATE TABLE

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.5.3
    • Parser
    • None

    Description

      Allow importing of MySQL 8.0 dumps where VISIBLE attribute is used for indexes.

      https://germano.fedorapeople.org/canc/gestione-corsi-laurea.mwb seems to always include
      the default VISIBLE attribute and it would be good if MariaDB could read the dumps.

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-7317 Make an index ignorable to the optimizer

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik added a comment -

            This is MySQL Workbench file, of course it'll include all new MySQL features

            serg Sergei Golubchik added a comment - This is MySQL Workbench file, of course it'll include all new MySQL features
            monty Michael Widenius added a comment -

            1 hour coding and 2 hour discussions about the feature.

            Was added to 10.5 as it's important to make it easy to import data from MySQL 8.0 and we want it easy to move applications developed for MySQL 8.0 to MariaDB.

            monty Michael Widenius added a comment - 1 hour coding and 2 hour discussions about the feature. Was added to 10.5 as it's important to make it easy to import data from MySQL 8.0 and we want it easy to move applications developed for MySQL 8.0 to MariaDB.

            People

              monty Michael Widenius
              monty Michael Widenius
              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.