add a contains() override test

1 files changed, 11 insertions, 0 deletions

diff --git a/test/sql/test_operators.py b/test/sql/test_operators.py
index 5b7aa67ac..4f5659791 100644
--- a/test/sql/test_operators.py
+++ b/test/sql/test_operators.py
@@ -242,6 +242,17 @@ class NewOperatorTest(_CustomComparatorTests, fixtures.TestBase):
 class ExtensionOperatorTest(fixtures.TestBase, testing.AssertsCompiledSQL):
     __dialect__ = 'default'
 
+    def test_contains(self):
+        class MyType(UserDefinedType):
+            class comparator_factory(UserDefinedType.Comparator):
+                def contains(self, other, **kw):
+                    return self.op("->")(other)
+
+        self.assert_compile(
+            Column('x', MyType()).contains(5),
+            "x -> :x_1"
+        )
+
     def test_getitem(self):
         class MyType(UserDefinedType):
             class comparator_factory(UserDefinedType.Comparator):