diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2013-06-02 20:23:03 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2013-06-02 20:23:03 -0400 |
| commit | 2b0b802b4973e84871d1f266cc2e8aac6c125d17 (patch) | |
| tree | a58a7b70b5f6da7d76db92f386d50c365f8cc7df /test/orm | |
| parent | 35a674aab4a832e76232e7be4b16b7a635a19824 (diff) | |
| download | sqlalchemy-2b0b802b4973e84871d1f266cc2e8aac6c125d17.tar.gz | |
working through tests....
Diffstat (limited to 'test/orm')
| -rw-r--r-- | test/orm/test_subquery_relations.py | 23 |
1 files changed, 11 insertions, 12 deletions
diff --git a/test/orm/test_subquery_relations.py b/test/orm/test_subquery_relations.py index d493e0b7e..a6cc37691 100644 --- a/test/orm/test_subquery_relations.py +++ b/test/orm/test_subquery_relations.py @@ -1533,19 +1533,18 @@ class CyclicalInheritingEagerTestTwo(fixtures.DeclarativeMappedTest, q = ctx.attributes[('subquery', (inspect(Director), inspect(Director).attrs.movies))] self.assert_compile(q, - "SELECT anon_1.movie_id AS anon_1_movie_id, " - "anon_1.persistent_id AS anon_1_persistent_id, " - "anon_1.movie_director_id AS anon_1_movie_director_id, " - "anon_1.movie_title AS anon_1_movie_title, " - "anon_2.director_id AS anon_2_director_id FROM " - "(SELECT director.id AS director_id FROM persistent JOIN director " - "ON persistent.id = director.id) AS anon_2 " - "JOIN (SELECT persistent.id AS persistent_id, movie.id AS movie_id, " + "SELECT movie.id AS movie_id, persistent.id AS persistent_id, " "movie.director_id AS movie_director_id, " - "movie.title AS movie_title FROM persistent JOIN movie " - "ON persistent.id = movie.id) AS anon_1 " - "ON anon_2.director_id = anon_1.movie_director_id " - "ORDER BY anon_2.director_id") + "movie.title AS movie_title, " + "anon_1.director_id AS anon_1_director_id " + "FROM (SELECT director.id AS director_id " + "FROM persistent JOIN director " + "ON persistent.id = director.id) AS anon_1 " + "JOIN (persistent JOIN movie ON persistent.id = movie.id) " + "ON anon_1.director_id = movie.director_id " + "ORDER BY anon_1.director_id", + dialect="default" + ) def test_integrate(self): Director = self.classes.Director |