Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
I am testing V20 with a view to buying
I have an issue where if I select a View and then select Alter, Create, Script object to window, or any other option, i just get a blank editor window, the view is not loaded.
I need this to be able to use the program, is there a way to fix it please.
I am using V 20.0 on a Mac
No doubt the fact that the definition is not being picked up is the problem. However, the issue MUST be something wrong with ADS.
I have tried the exact same thing in SQLYog (in Windows) and it works just fine. Also, their ‘Alter View’ option works too. Here is a screenshot of the result of your query in SQLYog.
Here is the result of the same thing in ADS (also on Windows)
I think it is something to do with the different way that MySQL stores information about views, Procedures etc as described in this MySQL manual page here
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-information-schema.html <https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-information-schema.html>
The views are not directly stored in the information_schema, instead the definition in information_schema is itself a view into the data dictionary.
Other tools like SQLYog use a different extract query. They use the query "SHOW CREATE TABLE `db`.`viewname`; " to fetch the view information. We extract the information using the catalog tables.
Other tools like SQLYog use a different extract query. They use the query "SHOW CREATE TABLE `db`.`viewname`; " to fetch the view information. We extract the information using the catalog tables.
Issue #15727 |
| Closed |
| Won't Fix |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
No doubt the fact that the definition is not being picked up is the problem. However, the issue MUST be something wrong with ADS.
I have tried the exact same thing in SQLYog (in Windows) and it works just fine. Also, their ‘Alter View’ option works too. Here is a screenshot of the result of your query in SQLYog.
Here is the result of the same thing in ADS (also on Windows)
I think it is something to do with the different way that MySQL stores information about views, Procedures etc as described in this MySQL manual page here
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-information-schema.html <https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-information-schema.html>
The views are not directly stored in the information_schema, instead the definition in information_schema is itself a view into the data dictionary.