Very interesting write up. Author alleges there’s nothing much to take away from the behavior of an individual engine on the matter but my take (valid or not) is that the more the result of this fun experiment deviates from the “expected” result, the more (potential) optimizations are taking place in the query planner.
Pretty cool example of “undefined behaviour” in databases :)
Very interesting write up. Author alleges there’s nothing much to take away from the behavior of an individual engine on the matter but my take (valid or not) is that the more the result of this fun experiment deviates from the “expected” result, the more (potential) optimizations are taking place in the query planner.