]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
apply asbool reduction to the onclause in join()
authorMike Bayer <mike_mp@zzzcomputing.com>
Fri, 17 Jan 2020 19:31:10 +0000 (14:31 -0500)
committerMike Bayer <mike_mp@zzzcomputing.com>
Fri, 17 Jan 2020 21:29:27 +0000 (16:29 -0500)
commitbdbe164d392d41991b64ced0f097930a04a2c420
treefbaf0da3f3e68b211821220843c9b3ab944c38df
parenta711522650863dd368acfa90e09216ae37fc3ec2
apply asbool reduction to the onclause in join()

The :func:`.true` and :func:`.false` operators may now be applied as the
"onclause" of a :func:`.sql.join` on a backend that does not support
"native boolean" expressions, e.g. Oracle or SQL Server, and the expression
will render as "1=1" for true and "1=0" false.  This is the behavior that
was introduced many years ago in :ticket:`2804` for and/or expressions.

Change-Id: I85311c31c22d6e226c618f8840f6b95eca611153
doc/build/changelog/unreleased_14/asbool_join.rst [new file with mode: 0644]
lib/sqlalchemy/sql/selectable.py
lib/sqlalchemy/testing/suite/test_select.py
test/profiles.txt
test/sql/test_operators.py