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

select_type=MATERIALIZED is not documented

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • N/A
    • N/A
    • Documentation
    • None

    Description

      Hi Ian,

      select_type = MATERIALIZED is not documented in https://mariadb.com/kb/en/mariadb/explain/ - I was able to get this from this query:

      explain extended select * from dept_emp where dept_no in (select dept_no from departments where dept_no='D001' order by dept_no) \G

      Thanks,
      Michaël

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            michaeldg Michaël de groot
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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