Re:Ask HN: What's the largest amount of bad code you have ev...
by karulont on Thursday November 15, 2018 @06:05AM
(#18458374)
I guess that is just because SQL as a standard is not coherent nor something beatifully designed. SQL is mashup of vendor specific features all bashed togehter into one standard.
[ Parent
| on HN ]
Re:Ask HN: What's the largest amount of bad code you have ev...
by majewsky on Thursday November 15, 2018 @07:03AM
(#18458571)
There's also a lot of essential complexity there. SQL provides, in essence, a generic interface for entering and analyzing data. Imagine the number of ways to structure and analyze data. Now square that number to get the number of two tests for how two basic features of the language interact with each other. And that's not even near full test coverage.
Re:Ask HN: What's the largest amount of bad code you have ev...
by 9question1 on Thursday November 15, 2018 @09:48AM
(#18459591)
Your point about essential complexity is absolutely correct, but your faux mathematical analysis is totally not a legit way to analyze the complexity of something or determine test coverage. I feel like as programmers we should be comfortable making sensible statements without making up shady pseudo-math to sound convincing.
Re:Ask HN: What's the largest amount of bad code you have ev...
by majewsky on Thursday November 15, 2018 @10:46AM
(#18460130)
It's abundantly clear that I'm not making a precise computation here. My argument is that tests don't scale linearly with the number of features because interactions between features need to be tested as well.