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

Forcing materialize in query used to create view

    XMLWordPrintable

Details

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

    Description

      I would like to use materialization in CTE construction:

      WITH a as (select ...)

      to materialize results of some inline query.
      This could be done by setting optimizer_switch in previous separate command. But is it possible to use some hint in the statement to use such CTE select to create view?

      Attachments

        Activity

          People

            Unassigned Unassigned
            balta Tadas Balaišis
            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.