Explain CTE not working as expected I22301332 Created November 08, 2024 02:25 When I try to explain cte in UPDATE sql, it always does not work. But if I explain it in SELECT sql, it works again.
Yes, I may confirm there is a highlighting issue when running such a query. However, the query itself is executed and returns a result the way it should. I had it reported here
https://youtrack.jetbrains.com/issue/DBE-22234/Cant-resolve-EXPLAIN-causes