]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Flatten operator precedence for comparison operators
authorMichael Birtwell <michael.birtwell@starleaf.com>
Thu, 25 May 2017 15:11:21 +0000 (11:11 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Thu, 25 May 2017 20:02:13 +0000 (16:02 -0400)
commitf8a3f14e4f862a4bf0be591699f1f72815c72514
tree23352abe2b074a5470ec37a2151c11b039b44e77
parentde11c5217b4c62f86dfd05a28689159095ab1024
Flatten operator precedence for comparison operators

The operator precedence for all comparison operators such as LIKE, IS,
IN, MATCH, equals, greater than, less than, etc. has all been merged
into one level, so that expressions which make use of these against
each other will produce parentheses between them.   This suits the
stated operator precedence of databases like Oracle, MySQL and others
which place all of these operators as equal precedence, as well as
Postgresql as of 9.5 which has also flattened its operator precendence.

Co-authored-by: Mike Bayer <mike_mp@zzzcomputing.com>
Fixes: #3999
Change-Id: I3f3d5124a64af0d376361cdf15a97e2e703be56f
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/367
doc/build/changelog/changelog_12.rst
doc/build/changelog/migration_12.rst
doc/build/core/tutorial.rst
lib/sqlalchemy/sql/operators.py
test/orm/test_relationships.py
test/sql/test_operators.py