MySQL Bugs: #92464: Alter View

Bug #92464	Alter View
Submitted:	17 Sep 2018 13:29	Modified:	24 Oct 2018 14:02
Reporter:	Danilo Priore	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	8.0.12, 8.0.13	OS:	MacOS (High Sierra 10.13.6)
Assigned to:		CPU Architecture:	x86

Description:
From the menu, when ask to alter the view, this does not do anything, it does not display the sql of the view to edit.

note: a one alias column name contains a dot like 'branch.name'.

How to repeat:
Select an existing view and open menu with mouse right button and after select alter view.

Thank you for the bug report. Please provide the create view statement which presents this issue. Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Thank you for the feedback, running your dump file I got below error, please provide the create table to complete the test case. Thanks.

ERROR 1146 (42S02): Table 'expensenotes.expense' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Thank you for the feedback. I couldn't repeat on macOS Mojave version 10.14.

The script already contains the "expenses" table, the script is generated automatically by Workbench and is full database structure with all tables, views and store procedures.

Thank you for the feedback.
Observed the reported issue only when
(i) Provided dump is imported on MySQL Server running on macOS 10.13.x High Sierra x86_64

umshastr-mac:mysql-8.0.11 umshastr$ bin/mysql -uroot < ../Dump20181019.sql 
umshastr-mac:mysql-8.0.11 umshastr$ bin/mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 8.0.11 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 
mysql> use ExpenseNotes
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+------------------------+
| Tables_in_expensenotes |
+------------------------+
| Accounting             |
| BankCheck              |
| Beneficiary            |
| Branch                 |
| BranchBankCheck        |
| BranchBeneficiary      |
| BranchExpense          |
| DocumentType           |
| Expense                |
| expensedetails         |
| Group                  |
| GroupDocumentType      |
| GroupOperationCode     |
| GroupOperationType     |
| OperationCode          |
| OperationType          |
| Order                  |
| Plan                   |
| Team                   |
| User                   |
| userbeanches           |
| UserBranch             |
| UserDevice             |
| UserGroup              |
| UserSettings           |
| UserTeam               |
+------------------------+
26 rows in set (0.00 sec)

(ii) With MySQL Workbench Community (GPL) for Mac OS X version 8.0.13 CE build 13780177 (64 bit), navigate to any of the Views, right click -> Alter View

# Issue not observed in below cases

i) Provided dump imported on MySQL server hosted on Linux (while restoring dump it complains for missing tables - noted that in view definition table names are referenced with small case, in order to restore I had to manually change it to actual case and restore worked)
ii) MySQL Workbench 8.0.13 on macOS 10.13.x High Sierra x86_64 - Alter view works
iii) MySQL Workbench 8.0.13 on Win7 - Alter view works

MySQL WB 8.0.13 + MySQL Server on macOS 10.13.x High Sierra x86_64

Attachment: Screen Shot 2018-10-23 at 12.39.11 PM.png (image/png, text), 225.76 KiB.

You are using the hierarchy separator (dot) in your object names? This calls for trouble, no doubt. You wouldn't use path separators in your filenames, would you?

I'm not sure this can be handled properly in Workbench, since all quote chars are stripped before any other processing takes place and aftwards you cannot tell if the dot belongs to the name or the hierarchy.

yes, but usually is written 'table-name' dot 'field-name', but in this case the aliases are 'prefix.name', full name closed from apexs.

however I replaced the alias 'prefix.name' with 'prefix_name' (with backslash), but the result is the same, the view is no longer editable.

thk.

sorry i write wrong before.

I replaced the alias 'prefix.name' with 'prefix_name' (with underscore), but the result is the same, the view is no longer editable