Discussion on: How to write SQL recursive CTE in 5 steps

View post

Replies for: Yeah I get it Frank, it's like DECODE (now implemented CASE WHEN ... END), NVL and its friends, the (+) for outer joins and so on, and all remain i...

Yes, ANSI joins introduced 20 years ago and still many bugs 🤷🏼‍♂️
About pg_hint_plan, at in YugabyteDB we have it by default. I see no reason not to allow easy troubleshooting / workaround.