0

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?

  • List on their kb no idea which ones keep up with later features sorry. – danblack Feb 27 at 4:08
  • Yes, and there is also a link to a list of tools that support MariaDB enhanced features (mariadb.com/kb/en/library/applications-supporting-mariadb). I've tried mysql maestro, and at least it doesn't error, but it also doesn't see its Invisible attribute. – ChrisF Feb 27 at 4:17
  • "error on this table" -- Please explain and show the message. – Rick James Mar 7 at 4:19
  • When I use the table structure tool on a table which contains an Invisible column, MysqlWorkbench generates the following message: Error Parsing DDL for tablename Then there is an option to view the DDL, which shows the full table CREATE statement with a red X marking the statement defining the Invisible colum – ChrisF Mar 7 at 4:30
0

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).

  • MySQL invisible columns? I've heard of MariaDB invisible columns, but MySQL? – dbdemon Feb 27 at 9:08
  • Oh, my fault, I confused columns with indexes. – Mike Lischke Feb 27 at 12:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.