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

Window functions without a table crash

Details

    Description

      SELECT <win_func>() over ();
      

      This crashes. Since there is no table, we can't attach the window function computation step to it.

      There is a separate code path however for sum functions when we have such a select. We should handle window functions similarly in that case.

      Attachments

        Activity

          cvicentiu Vicențiu Ciorbaru created issue -
          cvicentiu Vicențiu Ciorbaru made changes -
          Field Original Value New Value
          Summary Window functions without a table crash Window functions without a table, crash
          cvicentiu Vicențiu Ciorbaru made changes -
          Summary Window functions without a table, crash Window functions without a table crash
          cvicentiu Vicențiu Ciorbaru made changes -
          Description {code:sql}
          SELECT <win_func>() over (...);
          {code}
          This crashes. Since there is no table, we can't attach the window function computation step to it.

          There is a separate code path however for sum functions when we have such a select. We should handle window functions similarly in that case.
          {code:sql}
          SELECT <win_func>() over ();
          {code}
          This crashes. Since there is no table, we can't attach the window function computation step to it.

          There is a separate code path however for sum functions when we have such a select. We should handle window functions similarly in that case.
          elenst Elena Stepanova made changes -
          Affects Version/s 10.2 [ 14601 ]
          elenst Elena Stepanova made changes -
          Labels 10.2-rc
          igor Igor Babaev made changes -
          Assignee Vicentiu Ciorbaru [ cvicentiu ] Igor Babaev [ igor ]
          igor Igor Babaev made changes -
          Fix Version/s 10.2.4 [ 22116 ]
          Fix Version/s 10.2 [ 14601 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 77227 ] MariaDB v4 [ 150968 ]

          People

            igor Igor Babaev
            cvicentiu Vicențiu Ciorbaru
            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.