commit 8c6a9aa30f9e74388aaf923ac8e3b19ca0f86188

Author: Igor Babaev <igor@askmonty.org>

Date:   Thu Jun 30 15:13:12 2016 -0700

    Added a proper check for acceptable mutually recursive CTE.

create table ten(a int primary key);

insert into ten values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);

create table one_k(a int primary key);

insert into one_k select A.a + B.a* 10 + C.a * 100 from ten A, ten B, ten C;

create view v1 as select * from ten;

mysql> select * from v1;

+------+

| a    |

+------+

|    0 |

|    1 |

|    2 |

|    3 |

|    4 |

|    5 |

|    6 |

|    7 |

|    8 |

|    9 |

+------+

10 rows in set (0.01 sec)

mysql> with ten as (select  a from one_k where a<20) select * from v1;

+------+

| a    |

+------+

|    0 |

|    1 |

|    2 |

|    3 |

|    4 |

|    5 |

|    6 |

|    7 |

|    8 |

|    9 |

|   10 |

|   11 |

|   12 |

|   13 |

|   14 |

|   15 |

|   16 |

|   17 |

|   18 |

|   19 |

+------+

20 rows in set (0.06 sec)