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

[17 Sep 2018 13:29] Danilo Priore
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.
[17 Sep 2018 14:11] MySQL Verification Team
Thank you for the bug report. Please provide the create view statement which presents this issue. Thanks.
[18 Oct 2018 1:00] Bugs System
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".
[18 Oct 2018 10:47] MySQL Verification Team
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)
[22 Oct 2018 12:27] MySQL Verification Team
Thank you for the feedback. I couldn't repeat on macOS Mojave version 10.14.
[22 Oct 2018 15:10] Danilo Priore
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.
[23 Oct 2018 7:22] MySQL Verification Team
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
[23 Oct 2018 7:26] MySQL Verification Team
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.

[24 Oct 2018 8:17] Mike Lischke
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.
[24 Oct 2018 13:56] Danilo Priore
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.
[24 Oct 2018 14:02] Danilo Priore
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