- Fixed bug in :func:`.expression.text` construct where a double-colon

expression would not escape properly, e.g. ``some\:\:expr``, as is most
commonly required when rendering Postgresql-style CAST expressions.
fixes #3644

1 files changed, 11 insertions, 0 deletions

diff --git a/test/sql/test_text.py b/test/sql/test_text.py
index 78c3282ac..20cb2a6fb 100644
--- a/test/sql/test_text.py
+++ b/test/sql/test_text.py
@@ -281,6 +281,17 @@ class BindParamTest(fixtures.TestBase, AssertsCompiledSQL):
             dialect="postgresql"
         )
 
+    def test_escaping_double_colons(self):
+        self.assert_compile(
+            text(
+                "SELECT * FROM pg_attribute WHERE "
+                "attrelid = :tab\:\:regclass"),
+            "SELECT * FROM pg_attribute WHERE "
+            "attrelid = %(tab)s::regclass",
+            params={'tab': None},
+            dialect="postgresql"
+        )
+
     def test_text_in_select_nonfrom(self):
 
         generate_series = text("generate_series(:x, :y, :z) as s(a)").\