delta/python-packages/sqlalchemy.git/test/sql/test_operators.py, branch pr/67

- Added a new parameter :paramref:`.Operators.op.is_comparison`. This

2014-02-01T00:14:08+00:00

flag allows a custom op from :meth:`.Operators.op` to be considered
as a "comparison" operator, thus usable for custom
:paramref:`.relationship.primaryjoin` conditions.

- The precedence rules for the :meth:`.ColumnOperators.collate` operator

2013-12-06T00:03:31+00:00

have been modified, such that the COLLATE operator is now of lower
precedence than the comparison operators.  This has the effect that
a COLLATE applied to a comparison will not render parenthesis
around the comparison, which is not parsed by backends such as
MSSQL.  The change is backwards incompatible for those setups that
were working around the issue by applying :meth:`.Operators.collate`
to an individual element of the comparison expression,
rather than the comparison expression as a whole. [ticket:2879]

An overhaul of expression handling for special symbols particularly

2013-10-23T21:44:52+00:00

with conjunctions, e.g.
``None`` :func:`.expression.null` :func:`.expression.true`
:func:`.expression.false`, including consistency in rendering NULL
in conjunctions, "short-circuiting" of :func:`.and_` and :func:`.or_`
expressions which contain boolean constants, and rendering of
boolean constants and expressions as compared to "1" or "0" for backends
that don't feature ``true``/``false`` constants. [ticket:2804]

- Removed some now unneeded version checks [ticket:2829] courtesy alex gaynor

2013-09-23T00:35:40+00:00

- The :meth:`.Operators.notin_` operator added in 0.8 now properly

2013-08-07T18:28:45+00:00

produces the negation of the expression "IN" returns
when used against an empty collection.  Also in 0.8.3.

- remove the ``iter()`` with notimplemented since it interferes

2013-06-03T20:32:12+00:00

with legitimate iterable detection, [ticket:2726]

Fully implemented the IS and IS NOT operators with

2013-04-22T23:12:47+00:00

regards to the True/False constants.  An expression like
``col.is_(True)`` will now render ``col IS true``
on the target platform, rather than converting the True/
False constant to an integer bound parameter.
This allows the ``is_()`` operator to work on MySQL when
given True/False constants.
[ticket:2682]

The :meth:`.ColumnOperators.in_` operator will now coerce

2013-02-02T21:17:58+00:00

values of ``None`` to :func:`.null`.
[ticket:2496]

- BinaryExpression now keeps track of "left" and "right" as passed in,

2012-12-02T17:37:52+00:00

so that they can be compared in ``__nonzero__`` prior to their
self_group() step.  [ticket:2621]

Fixed a gotcha where inadvertently calling list() on a

2012-11-18T15:38:02+00:00

      :class:`.ColumnElement` would go into an endless loop, if
      :meth:`.ColumnOperators.__getitem__` were implemented.
      A new NotImplementedError is emitted via ``__iter__()``.