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

Window functions: support being in a subquery

Details

    • 10.2.0-9

    Description

      Current code assumes that window function computation is a once-in-a-query
      event. It creates Item and Cached_item objects, and allocates things on
      thd->mem_root.

      This task is separate the computations into

      • Stage #1: a part that is done once
      • Stage #2: a part that is re-run for every select re-execution.

      Also, all 'cursor' objects must be created at stage #1.

      Attachments

        Issue Links

          Activity

            psergei Sergei Petrunia created issue -
            psergei Sergei Petrunia made changes -
            Field Original Value New Value
            psergei Sergei Petrunia made changes -
            Description Current code assumes that window function computation is a once-in-a-query
            event. It creates Item and Cached_item objects, and allocates things on
            thd->mem_root.

            This task is separate the computations into
            * a part that is done once
            * a part that is re-run for every select re-execution.
            Current code assumes that window function computation is a once-in-a-query
            event. It creates Item and Cached_item objects, and allocates things on
            thd->mem_root.

            This task is separate the computations into
            * Stage #1: a part that is done once
            * Stage #2: a part that is re-run for every select re-execution.

            Also, all 'cursor' objects must be created at stage #1.
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9 [ 43 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            psergei Sergei Petrunia made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9 [ 43 ] 10.2.0-9, 10.2.0-10 [ 43, 46 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10 [ 43, 46 ] 10.2.0-9 [ 43 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            elenst Elena Stepanova made changes -
            Component/s Optimizer - Window functions [ 13502 ]
            Component/s Optimizer [ 10200 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 74568 ] MariaDB v4 [ 131815 ]
            julien.fritsch Julien Fritsch made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]

            People

              psergei Sergei Petrunia
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.