[MDEV-22199] Add VISIBLE attribute for indexes in CREATE TABLE Created: 2020-04-08  Updated: 2020-04-20  Resolved: 2020-04-20

Status: Closed
Project: MariaDB Server
Component/s: Parser
Fix Version/s: 10.5.3

Type: Task Priority: Major
Reporter: Michael Widenius Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-7317 Make an index ignorable to the optimizer Closed

 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.



 Comments   
Comment by Sergei Golubchik [ 2020-04-10 ]

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

Comment by Michael Widenius [ 2020-04-20 ]

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.

Generated at Thu Feb 08 09:12:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.