View does not work for MySQL

[since19861019]

Describe the bug
Views cannot be queried, showing no data.
For example, a simple view based on t, "select * from t" does not show any data in DATA tab, saying "unknown table t in information_schema" or showing busy cursor.

To Reproduce

1. Create a simple table and input some rows.
2. Create a simple view referencing the table above.
3. Select DATA tab to display the data.
4. Error is shown or the operation does not finish.

Expected behavior
A View works like a table.

Screenshots
None

Application (please complete the following information):

• Version 0.1.9
• Distribution: Snap Store

Desktop (please complete the following information):

• OS: Ubuntu
• Version 21.04

Additional context
This problem is OS irrelevant.

[Fabio286]

Thanks for your report 😀
Just fixed!

[since19861019]

View cannot be opend yet.
The following message appears when I try to show a simple view like "SELECT * from T".

TypeError: Cannot read property 'split' of undefined

[Fabio286]

It seems that MySQL for some views (maybe directly derived from a table) returns a table-like structure object, this was breaking views data visualization.
Thanks for the report, i've fixed!