A new, simple way to figure out why your recursive CTE is running away

In MySQL 8.0.1, I introduced support for recursive common table expressions (CTE). In the just-released version 8.0.19, I added an easy solution to a problem which nearly everybody meets when writing queries with recursive CTE’s: when infinite recursion happens, how to debug? You can read about it in my blog post on mysqlserverteam.

Commentaires

Posts les plus consultés de ce blog

WITH RECURSIVE and MySQL

Antijoin in MySQL 8

Optimizer tracing: how to configure it