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

Feature_window_functions counts queries, not functions

    XMLWordPrintable

Details

    Description

      ariaDB [test]> show status like 'Feature_window_functions';
      +--------------------------+-------+
      | Variable_name            | Value |
      +--------------------------+-------+
      | Feature_window_functions | 0     |
      +--------------------------+-------+
      1 row in set (0.00 sec)
       
      MariaDB [test]> select rank() over (order by a), row_number() over (partition by b) from t1;
      Empty set (0.00 sec)
       
      MariaDB [test]> show status like 'Feature_window_functions';
      +--------------------------+-------+
      | Variable_name            | Value |
      +--------------------------+-------+
      | Feature_window_functions | 1     |
      +--------------------------+-------+
      1 row in set (0.00 sec)
      

      For example, in a similar situation Feature_subquery counts actual subqueries:

      MariaDB [test]> show status like 'Feature_subquery';
      +------------------+-------+
      | Variable_name    | Value |
      +------------------+-------+
      | Feature_subquery | 0     |
      +------------------+-------+
      1 row in set (0.00 sec)
       
      MariaDB [test]> select (select 1), (select 2);
      +------------+------------+
      | (select 1) | (select 2) |
      +------------+------------+
      |          1 |          2 |
      +------------+------------+
      1 row in set (0.00 sec)
      

      Attachments

        Issue Links

          Activity

            People

              cvicentiu Vicențiu Ciorbaru
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.