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

Error, while using aggregated functions/window functions in anchor part

    XMLWordPrintable

Details

    Description

      Using aggregated functions/window functions in anchor part (not in a recursive part)-is allowed in Mysql, Mariadb returns error 4008: Restrictions imposed on recursive definitions are violated for table

      create table t1(b int);
      insert into t1 values(10),(20),(10);
       
      with recursive qn as
        (select max(b) as a from t1 union
         select a from qn)
      select * from qn;
       
      with recursive qn as
        (select rank() over (order by b) as a from t1 union
         select a from qn)
      select * from qn;
      

      Attachments

        Issue Links

          Activity

            People

              igor Igor Babaev
              alice Alice Sherepa
              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.