Bug #109039 Unable to modify db table from MySQL Workbench
Submitted: 9 Nov 2022 10:11 Modified: 9 Nov 2022 14:14
Reporter: Torin Torin Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0.31 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[9 Nov 2022 10:11] Torin Torin
Description:
11:52:12 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: There was an error while applying the SQL script to the database.
11:52:12 [ERR][  GRTDispatcher]: worker: task 'wizard task' has failed with error:.There was an error while applying the SQL script to the database.
11:57:56 [ERR][SQL Editor Form]: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 2
SQL Statement:
ALTER TABLE `dev`.`device_partner_pair` 
ADD UNIQUE INDEX `idx_unique_fields` (`uid` ASC, `device_id` ASC) VISIBLE

How to repeat:
try to add a new unique index to db table.

Suggested fix:
Fix the query to modify table, bay be remove 'VISIBLE' frm query
[9 Nov 2022 10:17] Torin Torin
No error if I remove VISIBLE but MySQL Workbench auto generates that. How can I stop MySQL Workbench from doing that?
[9 Nov 2022 10:24] Torin Torin
I'm using MariaDB 10.3.36
[9 Nov 2022 10:35] MySQL Verification Team
Please note that server MariaDB isn't supported by MySQL Workbench. Thanks.
[9 Nov 2022 10:59] Torin Torin
MariaDB is MySQL 5.7.
It needs only to remove 'VISIBLE' from the workbench queries on create index.
How can I achieve it? There are a lot of questions with the same problem in the forum.
[9 Nov 2022 11:09] MySQL Verification Team
Please see Bug #95804. Thanks.
[9 Nov 2022 14:14] Torin Torin
Rolled back to Workbench 6.8, it works for me.
It is sad what new versions don't work properly, not all users use MySQL 8.
Best wishes.