[MDEV-10955] Document Recursive CTE functionality Created: 2016-10-04 Updated: 2017-05-09 Resolved: 2017-05-09 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Documentation |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Major |
| Reporter: | Geoff Montee (Inactive) | Assignee: | Ian Gilfillan |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | 10.2-ga | ||
| Description |
|
The knowledge base has a documentation page about CTEs, but there is currently not much information about Recursive CTEs: https://mariadb.com/kb/en/mariadb/with/ I've been told that recursive CTE syntax requires "WITH RECURSIVE", rather than just "WITH". If nothing else, that syntax should be documented. It should probably also show an example of a recursive CTE. |
| Comments |
| Comment by richardeaxon [ 2016-11-09 ] |
|
One type of recursive CTE use is to traverse graphs. Lots of examples can be found here: https://inviqa.com/blog/graphs-database-sql-meets-social-network |
| Comment by Ian Gilfillan [ 2017-05-09 ] |
|
Added syntax and example to the WITH article. The recursive CTE section in the overview article will also be expanded. |