<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">First
things first, I’m coming from a .10 release of Storm, and I am trying to
upgrade to .12 but I’m stuck at this problem. I basically took the .12 release
and copied it over the old .10 release and removed all the .pyc files. 
Onto the problem.</span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial"> </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">I have this
table definition:</span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial"> </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">           
Class Foo(Storm)</span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">           
fooId                            
=  Int(name=”foo_id”, primary = True);</span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">           
barId                            
=  …</span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">           
pieId                            
=  …</span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">           
</span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">           
#then some references</span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">           
barRef                          
= Reference(barId, Bar.barId)</span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">           
pieRef                          
= Reference(pieId, Pie.pieId)</span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial"> </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">           
#and now some proxies  </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial"> </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">           
bar       
                       
= Proxy(barRef, Bar.name);</span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">           
pie                               
= Proxy(pieRef, Pie.name);</span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial"> </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial"> </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">When I do a
find like this</span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial"> </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">           
Store.find(Foo, Foo.bar = “brown”, Foo.pie = “cherry”) the resulting sql
statement comes out </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">           
</span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">SELECT
Foo.fooId, Foo.barId …  FROM Foo LEFT JOIN bar ON foo.bar_Id = bar.bar_Id
WHERE <a href="http://bar.name">bar.name</a> = ‘brown’, foo LEFT JOIN pie on pie.pie_id = foo.pie_id WHERE
<a href="http://bar.name">bar.name</a> = “brown” AND <a href="http://pie.name">pie.name</a> = “cherry”.</span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial"> </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">Which gives
me that Not unique table/alias error. Remove one of the conditional statements
and storm returns a result. From my testing, it seems that if I include
multiple conditions that use the references/proxy storm compiles the sql
incorrectly. Namely here</span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial"> </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial"><a href="http://bar.name">bar.name</a> =
‘brown’, foo LEFT JOIN </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial"> </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">Where
there’s a comma as well as foo coming out of nowhere. Remove the comma and the
foo and the statement works.  Did something change that I need to be aware
of in order to get this to work as I’ve looked through the mailing list and
figured this situation would have cropped up sooner if it is indeed a bug with
storm. </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial"> </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">Thanks for
the help</span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial"> </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial">Hamilton</span><span style="font-size:10.0pt;font-family:Arial"></span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial"> </span></p>