Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL)
-
None
Description
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)
|
|
Attachments
Issue Links
- relates to
-
MDEV-15447 Import CTE tests from MySQL 8
- Stalled