Bug #70853 Implemenation of CTE for recursive queries

• Submitted: 7 Nov 2013 10:26
• Modified: 11 Feb 2014 20:16
• Reporter: Daniël van Eeden (OCA)
• Status: Duplicate
• Category: MySQL Server: DML
• Severity: S4 (Feature request)
• Version: 5.7
• OS: Any
• CPU Architecture: Any

[7 Nov 2013 10:26] Daniël van Eeden

Description:
Please implement Common Table Expressions (CTE) for recursive queries.

This would also make it easier to migrate from PostgreSQL to MySQL

See also:
http://en.wikipedia.org/wiki/Hierarchical_and_recursive_queries_in_SQL
http://www.postgresql.org/docs/devel/static/queries-with.html

How to repeat:
See description

Suggested fix:
Implement CTE

[7 Nov 2013 10:41] MySQL Verification Team

http://bugs.mysql.com/bug.php?id=16244 ?

[11 Feb 2014 20:16] Daniël van Eeden

This is a duplicate of Bug #16244