MariaDB 10.5

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select @@version;


@@version


10.5.17-MariaDB-1:10.5.17+maria~deb11


WITH RECURSIVE t(n) AS (
    SELECT 1
  UNION 
    SELECT t.n + f.n
    FROM t, t AS f
    WHERE t.n < 4 AND f.n < 4
) SELECT * FROM t;

Restrictions imposed on recursive definitions are violated for table 't'


SET  @@standard_compliant_cte=0;
WITH RECURSIVE t(n) AS (
    SELECT 1
  UNION -- ALL
    SELECT t.n + f.n
    FROM t, t AS f
    WHERE t.n < 4 AND f.n < 4
) SELECT * FROM t;


n


1

2

3

4

5

6