Create a new account
Stuff with the Perl Foundation. A couple of patches in the Perl core. A few CPAN modules. That about sums it up.
In production code, if your SELECT statement returns more than one record and it doesn't have an ORDER BY clause, it's probably a bug.
I'm still amazed at the number of professional programmers who don't seem to realize this.
And what about the performance hit? I find that if I really need ordered data it's often better to just let Perl handle it on the client side.
What am I missing?
I think what you really want to say is "if your program implicitly depends on the order of rows without explicitly using an ORDER BY clause, it's definitely a bug."
I rarely use ORDER BY -- except when I need it. The trick is to know the difference.
Get More Comments