From 333414fe94941a6a58e7d8e45042548eb2d58119 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Fri, 30 Sep 2016 10:09:56 -0400 Subject: Add "eager_parenthesis" late-compilation rule, use w/ PG JSON/HSTORE Added compiler-level flags used by Postgresql to place additional parenthesis than would normally be generated by precedence rules around operations involving JSON, HSTORE indexing operators as well as within their operands since it has been observed that Postgresql's precedence rules for at least the HSTORE indexing operator is not consistent between 9.4 and 9.5. Fixes: #3806 Change-Id: I5899677b330595264543b055abd54f3c76bfabf2 --- lib/sqlalchemy/dialects/postgresql/base.py | 2 ++ 1 file changed, 2 insertions(+) (limited to 'lib/sqlalchemy/dialects/postgresql/base.py') diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py index a9f11aae0..bde855fbe 100644 --- a/lib/sqlalchemy/dialects/postgresql/base.py +++ b/lib/sqlalchemy/dialects/postgresql/base.py @@ -1270,11 +1270,13 @@ class PGCompiler(compiler.SQLCompiler): ) def visit_json_getitem_op_binary(self, binary, operator, **kw): + kw['eager_grouping'] = True return self._generate_generic_binary( binary, " -> ", **kw ) def visit_json_path_getitem_op_binary(self, binary, operator, **kw): + kw['eager_grouping'] = True return self._generate_generic_binary( binary, " #> ", **kw ) -- cgit v1.2.1