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

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

        Details

        • Type: Task
        • Status: Open
        • Priority: Major
        • Resolution: Unresolved
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          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?

            Gliffy Diagrams

              Attachments

                Activity

                There are no comments yet on this issue.

                  People

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

                    Dates

                    • Created:
                      Updated: