-
Notifications
You must be signed in to change notification settings - Fork 728
Description
-
System Information:
Webmin Version: 2.402
Operating System: Ubuntu Linux 20.04.6
MariaDB Version: 10.3.39-MariaDB
-
Description of the Bug:
In the "MySQL Database Server" module, any MariaDB VIEWs that exist in a database are not displayed in the "Edit table" or "Edit view" dropdown lists. This gives the impression that the views do not exist.
However, these same views are fully accessible and return data correctly when queried directly using the "Execute SQL" feature on the same page. The issue appears to be a display bug in how Webmin populates the list of database objects.
-
Steps to Reproduce:
Navigate to Servers > MySQL Database Server and select a database.
Go to the "Execute SQL" page.
Create a simple view using the following command: CREATE OR REPLACE VIEW test_view AS SELECT * FROM an_existing_table LIMIT 5;
Return to the main page for that database.
Observe that test_view does not appear in any of the dropdown lists for tables or views.
Go back to the "Execute SQL" page.
Run the command: SELECT * FROM test_view;
Observe that the query succeeds and returns data, proving the view exists and is accessible.
-
Expected Behavior:
The newly created test_view should appear in the "Edit view" dropdown list on the main database page. -
Actual Behavior:
The view does not appear in the list. The issue persists even after restarting the MariaDB and Webmin services.