Add unit test for UUID arrays in PostgreSQL.pr/68

1 files changed, 13 insertions, 0 deletions

diff --git a/test/dialect/postgresql/test_types.py b/test/dialect/postgresql/test_types.py
index ba4b63e1a..0b4c2dc19 100644
--- a/test/dialect/postgresql/test_types.py
+++ b/test/dialect/postgresql/test_types.py
@@ -936,6 +936,19 @@ class UUIDTest(fixtures.TestBase):
             uuid.uuid4()
         )
 
+    @testing.fails_on('postgresql+zxjdbc',
+                      'column "data" is of type uuid[] but expression is of type character varying')
+    @testing.fails_on('postgresql+pg8000', 'No support for UUID type')
+    def test_uuid_array(self):
+        import uuid
+        self._test_round_trip(
+            Table('utable', MetaData(),
+                Column('data', postgresql.ARRAY(postgresql.UUID()))
+            ),
+            [str(uuid.uuid4()), str(uuid.uuid4())],
+            [str(uuid.uuid4()), str(uuid.uuid4())],
+        )
+
     def test_no_uuid_available(self):
         from sqlalchemy.dialects.postgresql import base
         uuid_type = base._python_UUID