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

              Assignee:
              igor Igor Babaev
              Reporter:
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: