A Conversation Between Myself and Developer #2
It’s not that Developer #2 is a dumb guy. In fact, he’s one of the smartest on my team (which perhaps is saying something.. but really, he’s not a dumb guy). It’s just that human capacity for obliviousness is so incredibly vast it seems to not only trump logic, but actively block it’s use.
Perhaps by cornering Logic in a darkened ally and bludgeoning it to death with a sharpened carrot. But I digress. Here follows my conversation
James to Developer #2: What happens if someone were to call your (common/global) stored proc with NULL in that field
(note: this is an intentional design thing, NULL=all records, and I’d sent 2 emails to my team documenting this fact)
Developer #2 to James: But when I call it, I pass in the LoanID of the loans I generated a schedule for
James to Developer #2: Riiigh… but if someone elsewhere were to call it with NULL
Developer #2 to James: [stares hard at the screen]
James to Developer #2: Like If I wanted to check all loans in the system, on a different screen
Developer #2 to James: [stares hard at the screen]
Developer #2 to James: But when I call it, I pass in the LoanID of the loans I generated a schedule for
James to Developer #2: But If I went and wrote a different screen that called it with NULL
Developer #2 to James: [stares hard at the screen]
Developer #2 to James: [eventually moves code around, because he figures out that must be what James wants him to do]
Upon hearing this tale, Vlad quiped “It’s not a one man project, you know”