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

Re-engineer the code for post-join operations

Details

    • 10.2.0-4, 10.2.0-5

    Description

      <SanjaByelkin> instead of creating new JOIN_TABs array (i.e. new plan) to process results in temporary table (GROUPING ORDERING)
      <SanjaByelkin> just additional JOIN_TABs added at the end which represent such operation
      <SanjaByelkin> so you never rewrite it
      <SanjaByelkin> it is backport from MySQL
      <SanjaByelkin> so you can add any number of postprocessing operations
      <SanjaByelkin> and he need it for window functions

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-6115 window functions as in the SQL standard

          • Major - Major loss of function.
          • Closed
          includes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9477 delete_returning.test fails in mdev8646 tree

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            igor Igor Babaev (Inactive) created issue -
            igor Igor Babaev (Inactive) made changes -
            Field Original Value New Value
            Assignee Igor Babaev [ igor ]
            serg Sergei Golubchik made changes -
            Description <SanjaByelkin> instead of creating new JOIN_TABs array (i.e. new plan) to process results in temporary table (GROUPING ORDERING)
            <SanjaByelkin> just additional JOIN_TABs added at the end which represent such operation
            <SanjaByelkin> so you never rewrite it
            <SanjaByelkin> it is backport from MySQL
            <SanjaByelkin> so you can add any number of postprocessing operations
            <SanjaByelkin> and he need it for window functions
            psergei Sergei Petrunia made changes -
            psergei Sergei Petrunia made changes -
            Fix Version/s 10.2 [ 14601 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-4 [ 29 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-4 [ 29 ] 10.2.0-4, 10.2.0-5 [ 29, 32 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            psergei Sergei Petrunia made changes -
            igor Igor Babaev (Inactive) made changes -
            Summary Re-factor the code for working tables Re-factor the code for post-join operations
            igor Igor Babaev (Inactive) made changes -
            Summary Re-factor the code for post-join operations Re-engineer the code for post-join operations
            igor Igor Babaev (Inactive) made changes -
            Component/s Optimizer [ 10200 ]
            Fix Version/s 10.2.0 [ 20700 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 71137 ] MariaDB v4 [ 132667 ]

            People

              igor Igor Babaev (Inactive)
              igor Igor Babaev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.