- implement "literal binds" for the text() clause, [ticket:2882]

1 files changed, 11 insertions, 0 deletions

diff --git a/test/sql/test_text.py b/test/sql/test_text.py
index 827f4dfb9..37346437e 100644
--- a/test/sql/test_text.py
+++ b/test/sql/test_text.py
@@ -165,6 +165,17 @@ class BindParamTest(fixtures.TestBase, AssertsCompiledSQL):
             checkparams={'bar': 4, 'whee': 7},
         )
 
+    def test_literal_binds(self):
+        t = text("select * from foo where lala=:bar and hoho=:whee")
+        t = t.bindparams(bindparam('bar', 4), whee='whee')
+
+        self.assert_compile(
+            t,
+            "select * from foo where lala=4 and hoho='whee'",
+            checkparams={},
+            literal_binds=True
+        )
+
     def _assert_type_map(self, t, compare):
         map_ = dict(
             (b.key, b.type) for b in t._bindparams.values()