- fixed bug where selectable.corresponding_column(selectable.c.col)

would not return selectable.c.col, if the selectable is a join
of a table and another join involving the same table.  messed
up ORM decision making [ticket:593]

1 files changed, 7 insertions, 0 deletions

diff --git a/test/sql/selectable.py b/test/sql/selectable.py
index cd434a184..221d8430c 100755
--- a/test/sql/selectable.py
+++ b/test/sql/selectable.py
@@ -27,6 +27,13 @@ table2 = Table('table2', db,
 )

 

 class SelectableTest(testbase.AssertMixin):

+    def testjoinagainstjoin(self):

+        j  = outerjoin(table, table2, table.c.col1==table2.c.col2)

+        jj = select([ table.c.col1.label('bar_col1')],from_obj=[j]).alias('foo')

+        jjj = join(table, jj, table.c.col1==jj.c.bar_col1)

+        assert jjj.corresponding_column(jjj.c.table1_col1) is jjj.c.table1_col1

+        

+        

     def testtablealias(self):

         a = table.alias('a')