delta/python-packages/sqlalchemy.git/lib/sqlalchemy/testing/suite/test_select.py, branch ticket_4074

Add SQL Server CI coverage

2017-08-31T21:20:26+00:00

Change-Id: Ida0d01ae9bcc0573b86e24fddea620a38c962822

Add new "expanding" feature to bindparam()

2017-04-07T19:53:49+00:00

Added a new kind of :func:`.bindparam` called "expanding".  This is
for use in ``IN`` expressions where the list of elements is rendered
into individual bound parameters at statement execution time, rather
than at statement compilation time.  This allows both a single bound
parameter name to be linked to an IN expression of multiple elements,
as well as allows query caching to be used with IN expressions.  The
new feature allows the related features of "select in" loading and
"polymorphic in" loading to make use of the baked query extension
to reduce call overhead.   This feature should be considered to be
**experimental** for 1.2.

Fixes: #3953
Change-Id: Ie708414a3ab9c0af29998a2c7f239ff7633b1f6e

- make these failure cases more specific to catch Oracle.

2015-08-15T17:53:38+00:00

Would be nice to fix Oracle here

- The behavior of the :func:`.union` construct and related constructs

2015-08-12T18:26:11+00:00

such as :meth:`.Query.union` now handle the case where the embedded
SELECT statements need to be parenthesized due to the fact that they
include LIMIT, OFFSET and/or ORDER BY.   These queries **do not work
on SQLite**, and will fail on that backend as they did before, but
should now work on all other backends.
fixes #2528

Mark tests that they require OFFSET support in database

2015-05-05T14:00:09+00:00

The sqlalchemy_exasol dialect needs to support Exasol 4.x which does not support 
the OFFSET feature. Mark test with testing.requires.offset so that they can be skipped
of in the exasol specific test suite.

- fix this for pg8000 of all backends...

2015-03-24T21:11:22+00:00

- Turned off the "simple order by" flag on the MSSQL dialect; this

2015-03-24T16:28:19+00:00

is the flag that per :ticket:`2992` causes an order by or group by
an expression that's also in the columns clause to be copied by
label, even if referenced as the expression object.   The behavior
for MSSQL is now the old behavior that copies the whole expression
in by default, as MSSQL can be picky on these particularly in
GROUP BY expressions.
fixes #3338
- Add a test that includes a composed label in a GROUP BY

- ensure literal_binds works with LIMIT clause, FOR UPDATE

2014-09-03T23:42:38+00:00

- apply pep8 formatting to sqlalchemy/sql, sqlalchemy/util, sqlalchemy/dialects,

2014-07-20T16:44:40+00:00

sqlalchemy/orm, sqlalchemy/event, sqlalchemy/testing

- more tests, including backend tests

2014-05-16T19:33:39+00:00

- implement for SQL server, use window functions when simple limit/offset not available