diff options
| author | Marat Sharafutdinov <decaz89@gmail.com> | 2019-12-18 10:39:59 -0500 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2019-12-18 17:47:51 -0500 |
| commit | c18a04affd117cd6d7deb5b389de81b040b749a1 (patch) | |
| tree | ff6ca20fe3a54fc85d5db529642857ee405d1c00 /lib/sqlalchemy/sql/compiler.py | |
| parent | 051c2fde4c3b4bf7edcaa7578c0b1420986aaf0c (diff) | |
| download | sqlalchemy-c18a04affd117cd6d7deb5b389de81b040b749a1.tar.gz | |
Add CTE prefixes
Added support for prefixes to the :class:`.CTE` construct, to allow
support for Postgresql 12 "MATERIALIZED" and "NOT MATERIALIZED" phrases.
Pull request courtesy Marat Sharafutdinov.
Fixes: #5040
Closes: #5043
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/5043
Pull-request-sha: d1b9059a0b6dae8dc2479ac670999b4af07908e0
Change-Id: I2e9cb5d7f85961ec98ee51965de5b3ec4a97be2f
Diffstat (limited to 'lib/sqlalchemy/sql/compiler.py')
| -rw-r--r-- | lib/sqlalchemy/sql/compiler.py | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/lib/sqlalchemy/sql/compiler.py b/lib/sqlalchemy/sql/compiler.py index 4ec3b93ea..807b01c24 100644 --- a/lib/sqlalchemy/sql/compiler.py +++ b/lib/sqlalchemy/sql/compiler.py @@ -1851,7 +1851,8 @@ class SQLCompiler(Compiled): kwargs["positional_names"] = self.cte_positional[cte] = [] assert kwargs.get("subquery", False) is False - text += " AS \n(%s)" % ( + text += " AS %s\n(%s)" % ( + self._generate_prefixes(cte, cte._prefixes, **kwargs), cte.element._compiler_dispatch( self, asfrom=True, **kwargs ), |