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

Allow derived tables update/insert

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      Make derived tables more close internally to views and allow its update.

      Derived can be checked and marked for update allowance in mysql_derived_init. All check procedures (like can_be_merged() and view updatability check) now connected to LEX, but easily can be moved to SELECT_LEX_UNIT.

      Single table insert/update processed in mysql_derived_merge_for_insert() with help of TABLE_LIST::single_table_updatable().

      Then insert/update specific procedures can be changed: check_view_insertability() check_key_in_view()

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              sanja Oleksandr Byelkin
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.