<?xml version="1.0" encoding="windows-1252"?>
<node id="673590" title="Re^4: SQL::Statement confusing literals and identifiers (now with workaround!)" created="2008-03-11 15:29:56" updated="2008-03-11 11:29:56">
<type id="11">
note</type>
<author id="381608">
ikegami</author>
<data>
<field name="doctext">
&lt;p&gt;That would surely fix the problem in my case, but it's a very incomplete fix. Simply removing the quotes is too minimalistic. That fix would remove some (maybe all) false negatives, but would introduce false positives.  Specifically, the following name column pairs become indistinguishable:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;&lt;c&gt;"foo.bar".baz&lt;/c&gt; and &lt;c&gt;foo."bar.baz"&lt;/c&gt;
&lt;li&gt;&lt;c&gt;"foo.bar"&lt;/c&gt; and &lt;c&gt;foo.bar&lt;/c&gt;
&lt;li&gt;&lt;c&gt;"*"&lt;/c&gt; and &lt;c&gt;*&lt;/c&gt;
&lt;/ul&gt;

&lt;p&gt;The simplest solution might be to *add* quotes everywhere internally.&lt;/p&gt;

&lt;p&gt;That said, I'll use the previously suggested &lt;c&gt;SELECT *&lt;/c&gt; rather than applying this incomplete patch.&lt;/p&gt;
</field>
<field name="root_node">
673399</field>
<field name="parent_node">
673466</field>
</data>
</node>
