delta/python-packages/sqlalchemy.git/lib/sqlalchemy/sql, branch pr/274

Fix label referencing in SQL Server OFFSET logic

2016-05-10T16:55:23+00:00

Fixed bug where by ROW_NUMBER OVER clause applied for OFFSET
selects in SQL Server would inappropriately substitute a plain column
from the local statement that overlaps with a label name used by
the ORDER BY criteria of the statement.

Change-Id: Ic2500c886cbfc83a1ad5a2681783f008b9f23838
Fixes: #3711

Repair _orm_columns() to accommodate text()

2016-05-05T21:07:40+00:00

Fixed bug whereby passing a :func:`.text` construct to the
:meth:`.Query.group_by` method would raise an error, instead
of intepreting the object as a SQL fragment.

Change-Id: I5fc2f590b76508d52e23b5fa9cf037ddea8080c3
fixes: #3706

Adds parentheses around prints in documentation

2016-04-27T06:35:55+00:00

This makes the docstring example code compatible with both Python 2 and Python 3.

- Added :meth:`.Select.lateral` and related constructs to allow

2016-03-29T21:56:02+00:00

for the SQL standard LATERAL keyword, currently only supported
by Postgresql.  fixes #2857

- Added support for rendering "FULL OUTER JOIN" to both Core and ORM.

2016-03-28T15:50:09+00:00

Pull request courtesy Stefan Urbanek.  fixes #1957

- Fixed bug where the negation of an EXISTS expression would not

2016-03-21T14:57:40+00:00

be properly typed as boolean in the result, and also would fail to be
anonymously aliased in a SELECT list as is the case with a
non-negated EXISTS construct.
fixes #3682

Raise exception when we have multiple values with an unknown column. Fixes #3666.

2016-03-02T19:16:14+00:00

- unfortunately calling upon "_label" here makes it unclear if

2016-02-26T16:27:49+00:00

we're trying to hit columns without names yet and such, to suit the bug
right now just make it specific to FunctionElement

(cherry picked from commit 785224a92f39bd5bdd05bbc66f4dd79736abded5)

- Anonymous labeling is applied to a :attr:`.func` construct that is

2016-02-26T05:20:39+00:00

passed to :func:`.column_property`, so that if the same attribute
is referred to as a column expression twice the names are de-duped,
thus avoiding "ambiguous column" errors.   Previously, the
``.label(None)`` would need to be applied in order for the name
to be de-anonymized.
fixes #3663

- additional adjustment to the fix made in 8ad968f33100baeb3b13c7e0b724b6b79ab4277f

2016-02-22T03:49:29+00:00

for ref #3657.  The Oracle dialect makes more use of the "select_wraps_for"
feature than SQL server because Oracle doesn't have "TOP" for a limit-only
select, so tests are showing more happening here.  In the case where
the select() has some dupe columns, these are deduped from the .c collection
so a positional match between the wrapper and original can't use .inner_columns,
because these collections wont match.  Using _columns_plus_names
instead which is the deduped collection that determines the SELECT display,
which definitely have to match up.

(cherry picked from commit aa9ce3f521f254da9879ede011e520ec35b8270e)