Bug #86444 | Add a max_recursion variable to limit recursion in CTEs | ||
---|---|---|---|
Submitted: | 24 May 2017 15:19 | Modified: | 3 Aug 2017 16:49 |
Reporter: | Guilhem Bichot | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S3 (Non-critical) |
Version: | OS: | Any | |
Assigned to: | CPU Architecture: | Any |
[24 May 2017 15:19]
Guilhem Bichot
[3 Aug 2017 16:49]
Paul DuBois
Posted by developer: Fixed in 8.0.3. The new cte_max_recursion_depth system variable implements a common table expression (CTE) maximum recursion depth. The server terminates execution of any CTE that recurses more levels than the value of this variable.