Starting with version 8.0.1, MySQL supports Common Table Expressions (CTEs), non-recursive and recursive. This talk will introduce these objects, demonstrate how they can be leveraged to create more readable queries, and produce some reports which would otherwise require writing some iterative or recursive stored procedures. Tree-traversal examples will be covered. The implementation will also be briefly discussed.
This is a double-length session: it runs from 11:20 to 13:10 in the same room.
After some solid scientific studies, Guilhem has been working for 15 years as full-time C++ developer of the MySQL Server, from MySQL 4.0 to the most recent releases. These last years he's part of the Optimizer team.