2 ms·
I think you hit the most likely reason for the "1 <> 1" clauses: it was basically "commenting out" branches of the query (or something programmatically generate
by zbentley 9y ago
I think you hit the most likely reason for the "1 <> 1" clauses: it was basically "commenting out" branches of the query (or something programmatically generated the query in a way that needed to switch branches on and off without changing the query text so much that the query builder would have to understand more SQL syntax).
> It was the one time I took over someone else's code and felt like swearing.
The one time? Y'all hiring?
- krylon 9y agoWell, to be honest, I have taken over about four pieces of software over the years, and one of them was a one-and-a-half time maintenance job (adding one tiny little feature, later finding a bug that turned out to be not in the application after all). I was exceedingly lucky, I guess, because except for that hairy SQL view, they were all gems of clarity.