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
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link | This issue relates to MDEV-15447 [ MDEV-15447 ] |
| Assignee | Igor Babaev [ igor ] |
| Description |
{noformat}
MariaDB [test]> set big_tables=0; Query OK, 0 rows affected (0.00 sec) MariaDB [test]> with recursive qn as -> (select 1 as a from dual group by a union all -> select a+1 from qn where a<3) -> select * from qn; +---+ | a | +---+ | 1 | | 2 | | 3 | +---+ 3 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 1 as a from dual group by a union all select a+1 from qn where a<3) select * from qn; +---+ | a | +---+ | 1 | | 2 | +---+ 2 rows in set (0.00 sec) {noformat} |
{noformat}
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) {noformat} |
| Fix Version/s | 10.2.15 [ 23006 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Affects Version/s | 10.3 [ 22126 ] |
| Fix Version/s | 10.3.7 [ 23005 ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Fix Version/s | 10.3.7 [ 23005 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.3.7 [ 23005 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 86050 ] | MariaDB v4 [ 153964 ] |