<?xml version="1.0" encoding="windows-1252"?>
<node id="43766" title="Re: Topics in Perl Programming: Table-Mutation Tolerant Database Fetches with DBI" created="2000-11-28 19:41:58" updated="2005-07-19 14:08:39">
<type id="11">
note</type>
<author id="2680">
davorg</author>
<data>
<field name="doctext">
&lt;p&gt;Surely this is only a problem if you use
&lt;tt&gt;select * from tab1&lt;/tt&gt; and I can't believe that
anyone would be stupid enough to do that in production 
code.&lt;/p&gt;
&lt;p&gt;For exactly the reason that you discuss, you should
&lt;b&gt;always&lt;/b&gt; use &lt;tt&gt;select col1, col2 from tab1&lt;/tt&gt;&lt;/p&gt;
&lt;p&gt;The problem is not with Perl or DBI, but with your
usage of SQL.&lt;/p&gt;
-- &lt;br&gt;
&amp;lt;&lt;a href="http://www.dave.org.uk"&gt;http://www.dave.org.uk&lt;/a&gt;&gt;
&lt;p&gt;
"Perl makes the fun jobs fun&lt;br&gt;
and the boring jobs bearable" - me&lt;/p&gt;
</field>
<field name="root_node">
43748</field>
<field name="parent_node">
43748</field>
</data>
</node>
