Skip to content

MariaDB views not displayed in table list but are accessible via Execute SQL #2524

@GitXome

Description

@GitXome
  1. System Information:

    Webmin Version: 2.402

    Operating System: Ubuntu Linux 20.04.6

    MariaDB Version: 10.3.39-MariaDB

  2. 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.

  1. 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.

  2. Expected Behavior:
    The newly created test_view should appear in the "Edit view" dropdown list on the main database page.

  3. Actual Behavior:
    The view does not appear in the list. The issue persists even after restarting the MariaDB and Webmin services.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions