Broke out a specific values test and indicated that it fails on mssql due to duplicate columns in the order by clause.

1 files changed, 12 insertions, 4 deletions

diff --git a/test/orm/query.py b/test/orm/query.py
index d0acc5e45..e5de70dc0 100644
--- a/test/orm/query.py
+++ b/test/orm/query.py
@@ -1523,10 +1523,6 @@ class MixedEntitiesTest(QueryTest):
         q2 = q.values(func.count(User.name))
         assert q2.next() == (4,)
 
-        u2 = aliased(User)
-        q2 = q.select_from(sel).filter(u2.id>1).order_by([User.id, sel.c.id, u2.id]).values(User.name, sel.c.name, u2.name)
-        self.assertEquals(list(q2), [(u'jack', u'jack', u'jack'), (u'jack', u'jack', u'ed'), (u'jack', u'jack', u'fred'), (u'jack', u'jack', u'chuck'), (u'ed', u'ed', u'jack'), (u'ed', u'ed', u'ed'), (u'ed', u'ed', u'fred'), (u'ed', u'ed', u'chuck')])
-        
         q2 = q.select_from(sel).filter(User.id==8).values(User.name, sel.c.name, User.name)
         self.assertEquals(list(q2), [(u'ed', u'ed', u'ed')])
 
@@ -1539,6 +1535,18 @@ class MixedEntitiesTest(QueryTest):
         self.assertEquals(list(q2), [(u'ed', u'jack', u'jack')])
 
     @testing.fails_on('mssql')
+    def test_values_specific_order_by(self):
+        sess = create_session()
+
+        assert list(sess.query(User).values()) == list()
+
+        sel = users.select(User.id.in_([7, 8])).alias()
+        q = sess.query(User)
+        u2 = aliased(User)
+        q2 = q.select_from(sel).filter(u2.id>1).order_by([User.id, sel.c.id, u2.id]).values(User.name, sel.c.name, u2.name)
+        self.assertEquals(list(q2), [(u'jack', u'jack', u'jack'), (u'jack', u'jack', u'ed'), (u'jack', u'jack', u'fred'), (u'jack', u'jack', u'chuck'), (u'ed', u'ed', u'jack'), (u'ed', u'ed', u'ed'), (u'ed', u'ed', u'fred'), (u'ed', u'ed', u'chuck')])
+
+    @testing.fails_on('mssql')
     def test_values_with_boolean_selects(self):
         """Tests a values clause that works with select boolean evaluations"""
         sess = create_session()