summaryrefslogtreecommitdiff
path: root/test/sql/test_text.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/sql/test_text.py')
-rw-r--r--test/sql/test_text.py9
1 files changed, 9 insertions, 0 deletions
diff --git a/test/sql/test_text.py b/test/sql/test_text.py
index 15f6f6048..4fff0ed7e 100644
--- a/test/sql/test_text.py
+++ b/test/sql/test_text.py
@@ -6,6 +6,7 @@ from sqlalchemy import bindparam
from sqlalchemy import Column
from sqlalchemy import desc
from sqlalchemy import exc
+from sqlalchemy import extract
from sqlalchemy import Float
from sqlalchemy import func
from sqlalchemy import Integer
@@ -182,6 +183,14 @@ class SelectCompositionTest(fixtures.TestBase, AssertsCompiledSQL):
"(select f from bar where lala=heyhey) foo WHERE foo.f = t.id",
)
+ def test_expression_element_role(self):
+ """test #7287"""
+
+ self.assert_compile(
+ extract("year", text("some_date + :param")),
+ "EXTRACT(year FROM some_date + :param)",
+ )
+
@testing.combinations(
(
None,