Lets say its 2001 and you are writing some hot e-commerce stuff in plain php. You want to filter data depending on multiple fields in the submitted form. If some field is there, you add one more "AND" clause to the "WHERE", like this: if (isset($_POST['product'])) { $query .= "AND product = " . $_POST['product']; }. So in order not to check every time if the added clause is the first one you start with "WHERE 1=1 ", as "WHERE AND ..." would not work.
I get how this isn't good. But how else would you handle multi-field filtering, keep all the ANDs and use (product_id = $1 OR $1 IS NULL) so the unset filters are no-op? That's ok as long as the query planner is smart enough.
As most things CEO's do it will be a flippant display that will last about as long as a lettuce out of the fridge. However, those below will be expected to show evidence the rules are followed because there's nothing quite like cascading punishment, because that's the fun part of being a shitty boss, watching people suffer because they say so.
Look for teams that are flexible about remote work, those are the bosses you want to work for in this current day and age.
Every time I read one of these "back on site to do work" style posts, yet we'll offshore at the drop of a hat, it infuriates me as I can't see sense in the logic.
reply