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

Server hangs if OVER() is empty

    XMLWordPrintable

Details

    Description

      Empty OVER() clause is supported in PostgreSQL (no PARTITION BY or ORDER BY between parenthesis). I don't know if MariaDB is going to support it. However, if it doesn't, I'd expect an error message. Instead, the server simply hangs. No query is being executed, but the client freezes without showing any results or errors.

      CREATE OR REPLACE TABLE t
      (
               num INT UNSIGNED NOT NULL
      )
               ENGINE InnoDB
      ;
       
      INSERT INTO t VALUES (1), (2), (3);
       
      SELECT
      num, SUM(num) OVER () AS sum_salary
      FROM t;
      

      Attachments

        Issue Links

          Activity

            People

              cvicentiu Vicențiu Ciorbaru
              f_razzoli Federico Razzoli
              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.