search

webyog / sqlyog-community

Webyog provides monitoring and management tools for open source relational databases. We develop easy-to-use MySQL client tools for performance tuning and database management. Webyog's solutions include SQL Diagnostic Manager for MySQL performance optimization and SQLyog for MySQL administration. More than 35,000 companies (including Amazon, IBM, Salesforce, AT&T, eBay, and GE) and 2.5 million users rely on Webyog's solutions to provide valuable insights into their databases. Webyog is an Idera, Inc. company.
https://webyog.com/
GNU General Public License v2.0
2.16k stars 318 forks source link

`Functional Index` not supported by Schema Synchronisation Tool in latest version v13.2.1 #2341

Closed Cow258 closed 6 months ago

Cow258 commented 6 months ago

Functional Index not supported by Schema Synchronisation Tool in latest version v13.2.1

ALTER TABLE users ADD INDEX flags ((
  CAST(flags AS CHAR(255) array)
));

Currently

image

Expected


ALTER TABLE `users` 
    ADD COLUMN `flags` json   NULL after `fromApp` , 
    ADD KEY `flags` ((cast(`flags` as char(255) array)));
sibwy commented 6 months ago

Please contact us by email at ideramysqlsupport@idera.com about this. The way we use GitHub is strictly as an issue tracker for known issues and not for support or discussions. This is necessary in order to keep the system manageable.