From b0be3ef1b220edc64b3a72f3cf390f86eef8a7f9 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Thu, 9 Feb 2012 18:07:41 -0500 Subject: [PATCH] this is the actual case that #1401 will fix. confirmed broken in 0.7 --- test/orm/test_relationships.py | 15 +++++++++++++-- 1 file changed, 13 insertions(+), 2 deletions(-) diff --git a/test/orm/test_relationships.py b/test/orm/test_relationships.py index 484f1f3763..d718c9d2d5 100644 --- a/test/orm/test_relationships.py +++ b/test/orm/test_relationships.py @@ -141,12 +141,12 @@ class CompositeSelfRefFKTest(fixtures.MappedTest): Table('company_t', metadata, Column('company_id', Integer, primary_key=True, test_needs_autoincrement=True), - Column('name', sa.Unicode(30))) + Column('name', String(30))) Table('employee_t', metadata, Column('company_id', Integer, primary_key=True), Column('emp_id', Integer, primary_key=True), - Column('name', sa.Unicode(30)), + Column('name', String(30)), Column('reports_to_id', Integer), sa.ForeignKeyConstraint( ['company_id'], @@ -277,6 +277,17 @@ class CompositeSelfRefFKTest(fixtures.MappedTest): assert sess.query(Employee).\ get([c2.company_id, 3]).reports_to.name == 'emp5' + @testing.fails_if(lambda: True, "This will be fixed by #1401") + def go(): + eq_( + [n for n, in sess.query(Employee.name).\ + join(Employee.reports_to, aliased=True).\ + filter_by(name='emp5').\ + reset_joinpoint().\ + order_by(Employee.name)], + ['emp6', 'emp7'] + ) + go() class FKsAsPksTest(fixtures.MappedTest): """Syncrules on foreign keys that are also primary""" -- 2.47.3