Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8529

EXPLAIN INSERT/UPDATE provides no information about views CHECK OPTION enforcing

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.1
    • 10.4
    • Optimizer, Views
    • None

    Description

      When an INSERT or UPDATE is performed on a view with CHECK OPTION, some check on data must be performed by MariaDB. MariaDB and MySQL documentation does not contain any specific information.

      Could EXPLAIN show which tables are read, which indexes are used, etc?

      Attachments

        Activity

          People

            Unassigned Unassigned
            f_razzoli Federico Razzoli
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.