MySQL Bugs: #111121: Workbench remove backticks on the new computer (windows home -> pro)

Bug #111121	Workbench remove backticks on the new computer (windows home -> pro)
Submitted:	23 May 2023 13:57	Modified:	24 May 2023 11:18
Reporter:	denton cuh	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	8.0.33, 8.0.36	OS:	Windows (Microsoft Windows 10 Pro)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Guillaume\AppData\Roaming\MySQL\Workbench\log\wb.log]

SHORT VERSION

Workbench 8.0.33 remove VIEWS backticks on my new computer. So tables with some exotic field name that requiere backticks don' work. It worked normally on my old one.
Direct selects or stored procedures are not concerned.

DETAIL

I use MySQL Workbench for a long time (windows 10 home). For some reason, some of our old table have "human reading" field name, like "mobile phone 1". So far Workbench always use back tick, and this is how we registred our views.

Now I installed a new computer (windows 10 pro), with a new installation of workbench. But everytime I want to open a view, there are no backtick and workbench recognise it as an error (obviously), saying "Error Parsing DDL for .... There was an error while parsing the DDL retrived from the server. Do you want to view the DDL or cancel processing it?"

So I went on the old computer, same database. Views works normally. I can edit them, backticks are there.
So :
1. I opened the view create query (with backtick)
2. I copy/paste it into the other computer workbench, to create the same query blablamyquery2. The text is fine, the editor shows no error
3. I save the query : error "Error Parsing DDL for .... There was an error while parsing the DDL retrived from the server. Do you want to view the DDL or cancel processing it?"
4. I click yes : a query window open, and backticks are gone, so of course query is invalid.
5. If I refresh views or go on the old computer, the view is here. I can refresh and see it. I can open it from the other computer, but not from the new one.

How to repeat:
Edit a view which refer to a table with spaces or accents => backticks are gone from the registered query, and it throws an error

wb.1.log

Attachment: wb.1.log (application/octet-stream, text), 6.33 KiB.

wb.2.log

Attachment: wb.2.log (application/octet-stream, text), 5.25 KiB.

wb.log

Attachment: wb.log (application/octet-stream, text), 20.28 KiB.

Hello,

Thank you for the bug report.
Imho this is duplicate of Bug #105646, please see Bug #105646.

Regards,
Ashwini Patil