MySQL workbench can’t deal with MariaDB’s new Invisible columns

mariadbmysql-workbench

Recently upgraded to MariaDB 10.3 which has a new feature whereby we can create an invisible column like so:

ALTER TABLE MyTable ADD COLUMN `TestA` INT INVISIBLE;

But once I create this column, MySql Workbench will error on this table. Is there any way to workaround this? Or is there another GUI tool that can deal with this new column type?

Best Answer

MySQL Workbench currently supports MySQL version 5.6, 5.7 and 8.0 and has support for MySQL invisible columns indexes, (recursive) CTEs, JSON and all other (for a GUI relevant) features added to MySQL (like cached sha2 passwords).

Related Question