From 77f641429f019d06cc467ec4e57ae94f808d70bd Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Thu, 25 Nov 2010 12:20:13 -0500
Subject: - Fixed operator precedence rules for multiple chains of a single
 non-associative operator. I.e. "x - (y - z)" will compile as "x - (y - z)"
 and not "x - y - z".  Also works with labels, i.e. "x - (y - z).label('foo')"
 [ticket:1984] - Single element tuple expressions inside an IN clause
 parenthesize correctly, also from [ticket:1984], added tests for PG - re-fix
 again importlater, [ticket:1983]

---
 test/dialect/test_postgresql.py | 31 +++++++++++++++++++++++++++++++
 1 file changed, 31 insertions(+)

(limited to 'test/dialect/test_postgresql.py')

diff --git a/test/dialect/test_postgresql.py b/test/dialect/test_postgresql.py
index 150dacf18..92c089480 100644
--- a/test/dialect/test_postgresql.py
+++ b/test/dialect/test_postgresql.py
@@ -2046,3 +2046,34 @@ class MatchTest(TestBase, AssertsCompiledSQL):
                 matchtable.c.title.match('nutshells'
                 )))).order_by(matchtable.c.id).execute().fetchall()
         eq_([1, 3, 5], [r.id for r in results])
+
+
+class TupleTest(TestBase):
+    __only_on__ = 'postgresql'
+    
+    def test_tuple_containment(self):
+        
+        for test, exp in [
+            ([('a', 'b')], True),
+            ([('a', 'c')], False),
+            ([('f', 'q'), ('a', 'b')], True),
+            ([('f', 'q'), ('a', 'c')], False)
+        ]:
+            eq_(
+                testing.db.execute(
+                    select([
+                            tuple_(
+                                literal_column("'a'"), 
+                                literal_column("'b'")
+                            ).\
+                                in_([
+                                    tuple_(*[
+                                            literal_column("'%s'" % letter) 
+                                            for letter in elem
+                                        ]) for elem in test
+                                ])
+                            ])
+                ).scalar(),
+                exp
+            )
+
-- 
cgit v1.2.1


From 582b12152eb80bad865326dcda2f0a4fc51042d6 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Tue, 30 Nov 2010 13:55:17 -0500
Subject: - Fixed bug whereby KeyError would occur with non-ENUM supported PG
 versions after a pool dispose+recreate would occur, [ticket:1989]

---
 test/dialect/test_postgresql.py | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

(limited to 'test/dialect/test_postgresql.py')

diff --git a/test/dialect/test_postgresql.py b/test/dialect/test_postgresql.py
index 92c089480..9a93ec7dc 100644
--- a/test/dialect/test_postgresql.py
+++ b/test/dialect/test_postgresql.py
@@ -411,6 +411,24 @@ class EnumTest(TestBase, AssertsExecutionResults, AssertsCompiledSQL):
             metadata.drop_all()
             assert not testing.db.dialect.has_type(testing.db,
                     'fourfivesixtype')
+    
+    def test_no_support(self):
+        def server_version_info(self):
+            return (8, 2)
+            
+        e = engines.testing_engine()
+        dialect = e.dialect
+        dialect._get_server_version_info = server_version_info
+        
+        assert dialect.supports_native_enum
+        e.connect()
+        assert not dialect.supports_native_enum
+        
+        # initialize is called again on new pool
+        e.dispose()
+        e.connect()
+        assert not dialect.supports_native_enum
+        
 
     def test_reflection(self):
         metadata = MetaData(testing.db)
-- 
cgit v1.2.1