MariaDB [test]> set big_tables=0;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> with recursive qn as (select 123 as a union all select 1+a from qn where a<130) select * from qn;

+-----+

| a   |

+-----+

| 123 |

| 124 |

| 125 |

| 126 |

| 127 |

| 128 |

| 129 |

| 130 |

+-----+

8 rows in set (0.00 sec)

MariaDB [test]> set big_tables=1;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> with recursive qn as (select 123 as a union all select 1+a from qn where a<130) select * from qn;

+-----+

| a   |

+-----+

| 123 |

| 124 |

+-----+

2 rows in set (0.00 sec)