Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Find the "SELECT *" Bug 3 Comments More | Login | Reply /

 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.

  • I prefer to name my primary key column `id` and use `foo_id` as the name for foreign key columns. Then I use `ON` explicitly.

    LEFT JOIN dead_things ON thing.id = dead_things.thing_id

    Overall the query becomes more verbose, but I prefer it that way. It makes my schemata much more easily readable when columns immediately reveal themselves for what they are by their name.

    • That still doesn't fix the bug :)

      • I’m saying that you got bitten this easily because you combined two bad ideas.

        Although now that I think of it, the naming scheme I use means that any join would lead to duplicate id columns.

        Good thing I avoid SELECT * like the pest, then. Hmm, looking at some of my own source code, I find I do use the star quite a lot in the older parts. However, it’s always qualified with a table name, which explains why I never ran into your bug.

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.