[#MDEV-10933] Syntax error when WITH clause is used in CREATE SELECT.

When a WITH clause is attached to the unit from CREATE ... SELECT and the unit with this clause are parenthesis then the parser returns a syntax error:

MariaDB [test]> create table my_ancestors ( with recursive ancestor_ids (id) as (   select father from folks where name = 'Me'   union   select mother from folks where name = 'Me'   union   select father from folks, ancestor_ids a  where folks.id = a.id   union   select mother from folks, ancestor_ids a  where folks.id = a.id ) select p.* from folks as p, ancestor_ids as a where p.id = a.id );

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'recursive ancestor_ids (id) as (   select father from folks where name = 'Me'   ' at line 1

[MDEV-10933] Syntax error when WITH clause is used in CREATE SELECT. Created: 2016-09-30 Updated: 2016-10-11 Resolved: 2016-10-11
Status:	Closed
Project:	MariaDB Server
Component/s:	Optimizer - CTE
Affects Version/s:	10.2.2
Fix Version/s:	10.2.3

[MDEV-10933] Syntax error when WITH clause is used in CREATE SELECT. Created: 2016-09-30 Updated: 2016-10-11 Resolved: 2016-10-11