logoalt Hacker News

mattdeboardtoday at 2:07 AM1 replyview on HN

Interesting note about left join in the CTE being converted into an inner join. Didn't know that


Replies

whoami4041today at 2:19 AM

Yeah, it's one of those things that is hard to catch unless you've been bit by it before and know to look for it. Analytics teams at scale are at a much higher risk of this sneaking in, which is where automatic blocking with Lexega is helpful. No one wants to have to explain to their leadership why their dashboards were wrong from such a subtle SQL bug months down the road.